database error, new install
I create forums for all the namespaces, and then when I try to modify a related forum (for the "default" namespace") to be a "wiki", I get the following error:
Code:
Database error in vBulletin 3.8.2:
Invalid SQL:
SELECT thread.threadid, thread.title, forum.forumid, thread.prefixid
post.pagetext, post.userid, post.dateline
FROM thread AS thread
LEFT JOIN post AS post ON (thread.firstpostid = post.postid)
LEFT JOIN forum AS forum ON (forum.forumid = thread.forumid)
WHERE thread.forumid IN (29)
ORDER BY thread.dateline DESC;
MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.pagetext, post.userid, post.dateline
FROM thread AS thread
LEFT JOIN post A' at line 2
Error Number : 1064
Request Date : Tuesday, April 14th 2009 @ 05:17:36 AM
Error Date : Tuesday, April 14th 2009 @ 05:17:36 AM
Script : http://geekhack.org/admincp/forum.php?do=update
Referrer : http://geekhack.org/admincp/forum.php?do=edit&forumid=29
IP Address : 63.97.176.127
Username : admin
Classname : vB_Database
MySQL Version : 5.0.51a-3ubuntu5.4