Issue: Database Errors on deleting comments

Issue Tools
- View Changes

November 1, 2013 12:39 PM
Morrus

Regular Member
Database Errors on deleting comments

I get the following db error when trying to delete a comment:

Code:

Database error in vBulletin 4.2.2: Invalid SQL: REPLACE INTO `vw_lastupdate` (`lasttypeid`, `nodetypeid`, `nodeid`, `lastdateline`, `lastiteminfo`) VALUES ... Script : /forum/wiki_inlinemod.php?do=kill Referrer : /forum/wiki_inlinemod.php Classname : vB_Database MySQL Version : 5.5.29

I also get a db error when trying to delete and article.

Note, though - the article deletion still works despite the error, though the comment deletion does not.

Issue Details

Issue Number 3445

Issue Type Bug

Project VaultWiki 4.x Series

Category Moderator Tools

Status Fixed

Priority 2 - Fatal / Database Errors

Affected Version 4.0.0 Beta 7

Fixed Version 4.0.0 Gamma 1

Milestone VaultWiki 4 Beta X

Software DependencyAny

License TypePaid

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

November 1, 2013 4:15 PM

pegasus

VaultWiki Team

Your site is running Beta 4. The current, much more stable release is Beta 7. I cannot say whether it will fix this particular error, but there is no logic to the error you posted. It suggests that a particular wrapper function is not used in a place where it definitely is.

Please PM the full error message to me so that I can look into it more closely. The error may have security implications for your site, so I have removed it from the post above.

Reply
November 1, 2013 7:32 PM

Morrus

Regular Member

I upgraded it to the latest version just a few days ago. I'll PM you the error again when I next get on a PC.

Reply
November 2, 2013 2:34 PM
pegasus

VaultWiki Team
This issue doesn't relate to a security problem, it's just that one of the fields being updated is submitted empty.

In vault/core/controller/dm/last/discussion/vw.php, find:

Code:

$prep['cs']['fields']['commentid'] => 'itemid',

Add before:

Code:

$prep['cs']['fields']['dateline'] => 'dateline',

As you mentioned, this issue prevents moderators from deleting wiki comments by throwing a database error. That is the extent of it. Once the code is patched as above, deletes should apply normally.
Reply

+ Reply

All times are GMT -4. The time now is 10:31 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: Database Errors on deleting comments

Issue Tools