Issue: DB Error on Commenting

Issue Tools
- View Changes

September 19, 2014 3:44 PM

delicateglow delicateglow is offline

Junior Member

DB Error on Commenting

Code:

Database error in vBulletin 4.2.2:

Invalid SQL:
DELETE FROM `vw_subscribe` WHERE  `subscribeid` IN ()  LIMIT 1;

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 ')  LIMIT 1' at line 1
Error Number  : 1064

When commenting/quoting a user on a page.

Issue Details

Issue Number 4007

Issue Type Bug

Project VaultWiki 4.x Series

Category Discussions / Comments

Status Fixed

Priority 2 - Fatal / Database Errors

Affected Version 4.0.0 RC 2

Fixed Version 4.0.0 RC 3

Milestone VaultWiki 4.0 Gold

Software DependencyvBulletin 4.x w/ ckEditor

License TypePaid

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

September 23, 2014 10:40 AM
pegasus

VaultWiki Team
Fixed in the next release. This occurred when the user is not currently subscribed to the discussion, selects not to subscribe to the discussion when making the new comment, but has default subscription preferences set in the UserCP for wiki subscriptions.

In vault/core/controller/ui/watch/vw.php, find:

Code:

if (!$old) { return; }

Replace with:

Code:

if (empty($old['subscribeid'])) { return; }
Reply

+ Reply

All times are GMT -4. The time now is 7:40 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: DB Error on Commenting

Issue Tools