| users are unable to register with the forum, SQL error, fresh install [message #9031] |
Sat, 08 March 2003 15:39  |
bbarnett
Messages: 19
Registered: March 2003
Karma:
|
Junior Member |
|
|
I've installed FUDforum (the .8 version, just downloaded it today) several times, and no matter what users are unable to register with the forum.
Actually, the first user can always register, but the second user and beyond seem to have the problem. The user can initially register (and see the forum), but the confirmation email causes an SQL error.
Once this SQL error has occured (that is, once the user has visited the confirmation url), the user can no longer log in or do anything.
The log from the admin panel is:
Time Error Description
Sat Mar 8 15:32:40 GMT 2003 (rid=&S=c6395b2380133e52337a4768d1f26ed3) 1064: You have an error in your SQL syntax near ') AND cat_id!=0' at line 1
Query: SELECT MAX(last_post_id) FROM fud23_forum WHERE id IN() AND cat_id!=0
Server Version: 3.23.49-log
Sat Mar 8 15:37:43 GMT 2003 (rid=&S=c407a9c887408d0844c2e37650c4c4b6) 1064: You have an error in your SQL syntax near ') AND cat_id!=0' at line 1
Query: SELECT MAX(last_post_id) FROM fud23_forum WHERE id IN() AND cat_id!=0
Server Version: 3.23.49-log
Sat Mar 8 15:38:11 GMT 2003 (t=index&rid=4&S=c407a9c887408d0844c2e37650c4c4b6) 1064: You have an error in your SQL syntax near ') AND cat_id!=0' at line 1
Query: SELECT MAX(last_post_id) FROM fud23_forum WHERE id IN() AND cat_id!=0
Server Version: 3.23.49-log
[Referring Page] http://www.l8r.net/fud/FUDforum2/index.php?t=subscribed&rid=4&S=c40 7a9c887408d0844c2e37650c4c4b6
Sat Mar 8 15:38:19 GMT 2003 () 1064: You have an error in your SQL syntax near ') AND cat_id!=0' at line 1
Query: SELECT MAX(last_post_id) FROM fud23_forum WHERE id IN() AND cat_id!=0
Server Version: 3.23.49-log
Sat Mar 8 15:40:49 GMT 2003 () 1064: You have an error in your SQL syntax near ') AND cat_id!=0' at line 1
Query: SELECT MAX(last_post_id) FROM fud23_forum WHERE id IN() AND cat_id!=0
Server Version: 3.23.49-log
[Updated on: Sat, 08 March 2003 15:40] Report message to a moderator |
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]