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.

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.

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

I had either a permissions or host error going.

Thanks.

having same problem again. Very puzzling.

Did you ever get to the bottom of this problem ?

I get it when I try to edit topics....