Issue: MySQL Error with Blog

Issue Tools
- View Changes

May 23, 2009 12:04 PM

Mokonzi

Senior Member

MySQL Error with Blog

MySQL Error with Blog

I'm got the following error crop up, and suspect it's VaultWiki related.

Code:

Database error in vBulletin 3.7.6:

Invalid SQL:
DELETE FROM vb3_vault_link WHERE type = 'blog_9') AND type2 = 'nonforum';

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 ') AND type2 = 'nonforum'' at line 1
Error Number  : 1064
Request Date  : Saturday, May 23rd 2009 @ 03:15:02 PM
Error Date    : Saturday, May 23rd 2009 @ 03:15:02 PM
Script        : hxxp://www.mysite.com/forum/blog_inlinemod.php?b=&blogids=9,%208
Referrer      : hxxp://www.mysite.com/forum/blog_inlinemod.php

Issue Details

Issue Number 601

Issue Type Bug

Project VaultWiki 3.x Series

Category Inline Moderation

Status Fixed

Priority 6 - Dev-Related Tasks

Affected Version 2.3.0 Patch Level 1

Fixed Version 2.3.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 23, 2009 12:22 PM

pegasus

VaultWiki Team

Do you know what blog inline mod action was performed? Does it still occur after you updated special_plugins_inlinemod.php from before?

I can't see any reason that a ) would be there. I don't see it anywhere in the code.

Reply
May 23, 2009 6:00 PM
Mokonzi

Senior Member
I've no further information, though I can ask. Will let you know if anything comes up.

The second instance of the error read:

Code:

DELETE FROM vb3_vault_link WHERE type = 'blog_[b]8[/b]') AND type2 = 'nonforum';

(Bold added to show the change)
Reply
May 25, 2009 3:28 AM

Mokonzi

Senior Member

Details from the user are that he'd tried to delete multiple blogs when the error occurred.

I tested this myself... and found that two blog entries deleted at the same time cause the error.

The first of the entries is deleted when the error occurs, but the second isn't. Deleting the second on it's own still creates the error, but the entry is gone.

Hope this helps in some way.

Reply
May 26, 2009 12:06 AM
pegasus

VaultWiki Team
Go to AdminCP -> Plugins & Products -> Plugin Manager. Under CES VaultWiki, find the plugin called "Blog Data - Uncache Links" at hook blog_data_delete.

Find:

Code:

'blog_{$blogid}')

Replace with:

Code:

'blog_{$blogid}'
Reply
May 26, 2009 7:39 PM

Mokonzi

Senior Member

Fixed. Brilliant job matey.

Reply

+ Reply

All times are GMT -4. The time now is 11:47 AM.

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 with Blog

Issue Tools