Posted on: 01/25/02 08:17am
By: Anonymous (cansas)
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.
missing userpref's record?
Posted on: 01/25/02 10:40am
By: Tony
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.
missing userpref's record?
Posted on: 01/25/02 11:30am
By: Anonymous (cansas)
"Got 1" - userprefs exists - this occurs with a clean install admin user also.
Duh! fixed.
Posted on: 01/25/02 01:17pm
By: Anonymous (cansas)
I had either a permissions or host error going.
Thanks.
broken again?
Posted on: 01/28/02 02:58pm
By: Anonymous (cansas)
having same problem again. Very puzzling.
broken again?
Posted on: 04/12/02 09:42pm
By: dlcheetham
Did you ever get to the bottom of this problem ?
I get it when I try to edit topics....