Issue: MySQL Error in vBulletin Blog 2.0.2 When Posting New Blog

Issue Tools
- View Changes

May 16, 2009 3:43 PM

Mokonzi

Senior Member

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?

Issue Details

Issue Number 595

Issue Type Bug

Project VaultWiki 3.x Series

Category Non-Wiki Threads / Posts

Status Fixed

Priority 4 - Warnings / Script Errors

Affected Version 2.3.0 Patch Level 1

Fixed Version 2.3.0 Patch Level 1

Milestone (none)

Software DependencyAny

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

May 16, 2009 3:54 PM

pegasus

VaultWiki Team

Fixed in the current ZIP. In vault/special_plugins_bbcode.php, find:

Code:

			if (empty($bloginfo))
			{
				$bloginfo['blogid'] = $post['blogid'];
			}

			$forumid = 'blog_' . $bloginfo['blogid'];

Replace with:

Code:

			if (empty($bloginfo))
			{
				$forumid = 'blog_' . $post['blogid'];
			}
			else
			{
				$forumid = 'blog_' . $bloginfo['blogid'];
			}

May 16, 2009 4:10 PM

Mokonzi

Senior Member

Perfect Fix!

Now I've got to install all the different mods and patches to the live server... :S

Reply

+ Reply

All times are GMT -4. The time now is 11:26 PM.

This site uses cookies to help personalize content, to tailor your experience, and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.

Learn more… Accept Remind me later

Welcome to VaultWiki.org, home of the wiki add-on for vBulletin and XenForo!

Issue: MySQL Error in vBulletin Blog 2.0.2 When Posting New Blog

Issue Tools