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.

Status: offline

Tony

Site Admin
Admin
Registered: 12/17/01
Posts: 405
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.

cansas

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

cansas

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

cansas

Anonymous
having same problem again. Very puzzling.

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....