Issue: Error when deleting feed

Issue Tools
- View Changes

July 23, 2015 12:59 AM

Gossamer

Junior Member

Error when deleting feed

I tried to delete a feed and received this error:

Code:

Server Error

Database Error: DELETE FROM `vw_lastupdate` WHERE `nodeid` IN (1) AND nodetypeid = Mysqli prepare 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 '' at line 1

vw_DB_Controller_XF->throw_error() in /home/pandorar/public_html/markedrp.com/vault/core/controller/db/xf.php at line 157
vw_DB_Controller_XF->query_write() in /home/pandorar/public_html/markedrp.com/vault/core/model/db/mysql/vw.php at line 951
vw_DB_MySQL_Model->shutdown_or_run() in /home/pandorar/public_html/markedrp.com/vault/core/model/db/mysql/vw.php at line 340
vw_DB_MySQL_Model->delete() in /home/pandorar/public_html/markedrp.com/vault/core/controller/dm/feed/vw.php at line 326
vw_DM_Feed_Controller->delete_multiple() in /home/pandorar/public_html/markedrp.com/vault/core/controller/dm/vw.php at line 113
vw_DM_Controller->delete_multiple() in /home/pandorar/public_html/markedrp.com/vault/core/controller/ui/imod/vw.php at line 394
vw_UI_iMod_Controller->kill() in /home/pandorar/public_html/markedrp.com/vault/core/controller/ui/imod/vw.php at line 108
vw_UI_iMod_Controller->execute() in vw/XenForo/ControllerPublic/Wiki/Moderate.php at line 50
vw_XenForo_ControllerPublic_Wiki_Moderate->actionIndex() in XenForo/FrontController.php at line 347
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
XenForo_FrontController->run() in /home/pandorar/public_html/markedrp.com/index.php at line 13

I'm not sure if the feed deleted entirely. It's still present on the wiki front page: http://markedrp.com/wiki/

But if I go to the page for the feed, it says it doesn't exist. But the feed is still listed in the list of all feeds: http://markedrp.com/wiki/?do=feeds

Issue Details

Issue Number 4350

Issue Type Bug

Project VaultWiki 4.x Series

Category Moderator Tools

Status Fixed

Priority 2 - Fatal / Database Errors

Affected Version 4.0.5

Fixed Version 4.0.6

Milestone (none)

Software DependencyXenForo 1.x

License TypePaid

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

July 23, 2015 8:03 AM
pegasus

VaultWiki Team
In vault/core/controller/dm/feed/vw.php, find:

Code:

vw_DB::get()->query()->eq('nodetypeid', $itemtypeid)

Replace with:

Code:

vw_DB::get()->query()->eq('nodetypeid', $this->node['id'])

Then you should be able to delete the feed again using inline moderation.
Reply
July 23, 2015 8:21 AM

Gossamer

Junior Member

Thanks! Fixed now!

Reply

+ Reply

All times are GMT -4. The time now is 10:44 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: Error when deleting feed

Issue Tools