Welcome to Geeklog, Anonymous Sunday, June 16 2024 @ 07:51 pm EDT

Geeklog Forums

Help sql error


cansas

Anonymous
I noticed this help request from November, but coul not find a resolution. When editing or creating new stories from a remote machine I get the following error "1064 You have an error in your SQL syntax near '' at line 1" In the error log the following appears "SQL in question: SELECT username FROM users WHERE uid = " I can edit on the host machine, but this is not a good solution. Any ideas? Using geeklog-1.3.1. P.S. I have a another machine with the same install that works perfectly.
 Quote

Status: offline

Tony

Site Admin
Admin
Registered: 12/17/01
Posts: 405
Location:Urbandale, Iowa
For the account in question do this. Get the uid for that user: SELECT uid FROM users WHERE username = 'yourusername'; The do: SELECT count(*) FROM userprefs WHERE uid = 'idfromabove' If you get 0 let me know and insert a record into the userprefs table for that user and it should start working for you. ----- The reason people blame things on previous generations is that there's only one other choice.
The reason people blame things on previous generations is that there's only one other choice.
 Quote

cansas

Anonymous
"Got 1" - userprefs exists - this occurs with a clean install admin user also.
 Quote

cansas

Anonymous
I had either a permissions or host error going. Thanks.
 Quote

cansas

Anonymous
having same problem again. Very puzzling.
 Quote

Status: offline

dlcheetham

Forum User
Newbie
Registered: 04/04/02
Posts: 7
Did you ever get to the bottom of this problem ? I get it when I try to edit topics....
 Quote

All times are EDT. The time is now 07:51 pm.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content