MySQL Error in vBulletin Blog 2.0.2 When Posting New Blog
MySQL Error in vBulletin Blog 2.0.2 When Posting New Blog
I'm getting the following error when I post in the blog (just installed 2.0.2):
Code:
Database error in vBulletin 3.7.6:
Invalid SQL:
REPLACE INTO vb3_blog_editlog (blogtextid, userid, username, dateline, reason)
VALUES (, 2000, 'username', 1242502786, '');
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 ' 2000, 'username', 1242502786, '')' at line 2
Error Number : 1064
Request Date : Saturday, May 16th 2009 @ 08:39:46 PM
Error Date : Saturday, May 16th 2009 @ 08:39:47 PM
Script : hxxp://www.mysite.com/forum/blog_post.php?do=updateblog&blogid=
Referrer : hxxp://www.mysite.com/forum/blog_post.php?do=newblog
And if I preview it instead of submitting...
Code:
Database error in vBulletin 3.7.6:
Invalid SQL:
SELECT dateline, thumbnail_dateline, filename, filesize, visible, attachmentid,
IF(thumbnail_filesize > 0, 1, 0) AS hasthumbnail, thumbnail_filesize,
attachmenttype.thumbnail AS build_thumbnail, attachmenttype.newwindow
FROM vb3_blog_attachment
LEFT JOIN vb3_attachmenttype AS attachmenttype USING (extension)
WHERE blogid =
ORDER BY attachmentid;
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 'ORDER BY attachmentid' at line 7
Error Number : 1064
Request Date : Saturday, May 16th 2009 @ 08:43:16 PM
Error Date : Saturday, May 16th 2009 @ 08:43:24 PM
Script : hxxp://www.mysite.com/forum/blog_post.php?do=updateblog&blogid=
Referrer : hxxp://www.mysite.com/forum/blog_post.php?do=newblog
Disabling the wiki revmoves the error...
Any solutions?