Issue: Subscriptions DB error

Issue Tools
- View Changes

August 19, 2014 2:39 AM

delicateglow delicateglow is offline

Junior Member

Subscriptions DB error

when accessing Wiki Subscriptions

Code:

Database error in vBulletin 4.2.2:

Invalid SQL:
SELECT * FROM `vw_lastupdate` WHERE  `nodeid` IN ()  AND nodetypeid = 1 ORDER BY lastdateline 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 ')  AND nodetypeid = 1 ORDER BY lastdateline DESC' at line 1
Error Number  : 1064

Issue Details

Issue Number 3934

Issue Type Bug

Project VaultWiki 4.x Series

Category Subscriptions

Status Fixed

Priority 2 - Fatal / Database Errors

Affected Version 4.0.0 RC 1

Fixed Version 4.0.0 RC 2

Milestone VaultWiki 4.0 Gold

Software DependencyAny

License TypePaid

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

August 19, 2014 8:41 AM

pegasus

VaultWiki Team

Fixed in the next release.

This occurred if users were subscribed to a page or discussion that later was deleted by a moderator. The code that was designed to remove subscriptions whenever the original content was deleted was not working properly (I'm surprised it wasn't throwing database errors itself).

This code has been fixed in the next release. Also, the upgrade script contains a number of steps that will cleanup the stale subscriptions from the database, so that users who were already affected will be able to manage their subscriptions again.

Reply

+ Reply

All times are GMT -4. The time now is 2:13 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: Subscriptions DB error

Issue Tools