Issue: Error when hard deleting pages

Issue Tools
- View Changes

October 7, 2013 8:08 AM

dustinmattison dustinmattison is offline

New Member

Error when hard deleting pages

I tried to delete and got error

I tried to hard delete pages and got this error:

Server Error

Code:

Mysqli prepare error: Unknown column 'defer' in 'field list'

Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
Zend_Db_Adapter_Abstract->query() in /home/dustinma/public_html/888innovation.com/vault/core/controller/db/xf.php at line 107
vw_DB_Controller_XF->query_write() in /home/dustinma/public_html/888innovation.com/vault/core/model/db/mysql/vw.php at line 829
vw_DB_MySQL_Model->shutdown_or_run() in /home/dustinma/public_html/888innovation.com/vault/core/model/db/mysql/vw.php at line 699
vw_DB_MySQL_Model->insert() in /home/dustinma/public_html/888innovation.com/vault/core/controller/dm/base/vw.php at line 1442
vw_DM_Base_Controller->defer() in /home/dustinma/public_html/888innovation.com/vault/core/controller/dm/node/vw.php at line 309
vw_DM_Node_Controller->delete_discussions() in /home/dustinma/public_html/888innovation.com/vault/core/controller/dm/page/vw.php at line 1544
vw_DM_Page_Controller->delete_multiple() in /home/dustinma/public_html/888innovation.com/vault/core/controller/dm/vw.php at line 113
vw_DM_Controller->delete_multiple() in /home/dustinma/public_html/888innovation.com/vault/core/controller/ui/imod/vw.php at line 348
vw_UI_iMod_Controller->kill() in /home/dustinma/public_html/888innovation.com/vault/core/controller/ui/imod/vw.php at line 82
vw_UI_iMod_Controller->execute() in vw/XenForo/ControllerPublic/Wiki/Moderate.php at line 41
vw_XenForo_ControllerPublic_Wiki_Moderate->actionIndex() in XenForo/FrontController.php at line 337
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
XenForo_FrontController->run() in /home/dustinma/public_html/888innovation.com/index.php at line 13

Issue Details

Issue Number 3374

Issue Type Bug

Project VaultWiki 4.x Series

Category Moderator Tools

Status Fixed

Priority 4 - Warnings / Script Errors

Affected Version 4.0.0 Beta 6

Fixed Version 4.0.0 Beta 6

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)

October 7, 2013 9:32 AM
pegasus

VaultWiki Team
Fixed in the current build. In vault/core/controller/dm/base/vw.php, find:

Code:

'logtype' => 'defer',

Replace with:

Code:

'logtype' => "'defer'",
Reply

October 7, 2013 6:59 PM

dustinmattison dustinmattison is offline

New Member

I tried that, and I get this error

Server Error

Code:

Argument 2 passed to XenForo_Application::defer() must be an array, none given, called in /home/dustinma/public_html/888innovation.com/vault/core/controller/dm/xf.php on line 406 and defined

XenForo_Application::handlePhpError() in XenForo/Application.php at line 1237
XenForo_Application::defer() in /home/dustinma/public_html/888innovation.com/vault/core/controller/dm/xf.php at line 406
vw_DM_Controller_XF->defer() in /home/dustinma/public_html/888innovation.com/vault/core/controller/dm/base/vw.php at line 1444
vw_DM_Base_Controller->defer() in /home/dustinma/public_html/888innovation.com/vault/core/controller/dm/node/vw.php at line 309
vw_DM_Node_Controller->delete_discussions() in /home/dustinma/public_html/888innovation.com/vault/core/controller/dm/page/vw.php at line 1544
vw_DM_Page_Controller->delete_multiple() in /home/dustinma/public_html/888innovation.com/vault/core/controller/dm/vw.php at line 113
vw_DM_Controller->delete_multiple() in /home/dustinma/public_html/888innovation.com/vault/core/controller/ui/imod/vw.php at line 348
vw_UI_iMod_Controller->kill() in /home/dustinma/public_html/888innovation.com/vault/core/controller/ui/imod/vw.php at line 82
vw_UI_iMod_Controller->execute() in vw/XenForo/ControllerPublic/Wiki/Moderate.php at line 41
vw_XenForo_ControllerPublic_Wiki_Moderate->actionIndex() in XenForo/FrontController.php at line 337
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
XenForo_FrontController->run() in /home/dustinma/public_html/888innovation.com/index.php at line 13

October 7, 2013 7:30 PM

pegasus

VaultWiki Team

In vault/core/controller/dm/xf.php, find:

Code:

XenForo_Application::defer('vw_XenForo_Deferred_vw');

Replace with:

Code:

XenForo_Application::defer('vw_XenForo_Deferred_vw', array());

October 7, 2013 10:00 PM

dustinmattison dustinmattison is offline

New Member

I get this error now

Code:

Fatal error: Call to undefined method vw_DB_MySQL_Model_XF::var() in /home/dustinma/public_html/888innovation.com/vault/core/controller/dm/item/chapter/vw.php on line 436

October 8, 2013 10:30 AM
pegasus

VaultWiki Team
Fixed in the current release. This was due to the function name actually being a reserved term in older versions of PHP.

In vault/core/controller/dm/item/chapter/vw.php, find:

Code:

$varname = vw_DB::get()->query()->var('new_chapter_order');

Replace with:

Code:

$varname = vw_DB::get()->query()->varname('new_chapter_order');
Reply
October 8, 2013 7:38 PM

dustinmattison

New Member

ok, now it works

Reply

October 11, 2013 6:51 AM

dustinmattison dustinmattison is offline

New Member

I tried deleted a chapter with many sub chapter pages, I got this error

Server Error

Code:

Mysqli statement execute error : Duplicate entry 'defer-1381488486' for key 'PRIMARY'

Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
Zend_Db_Adapter_Abstract->query() in /home/dustinma/public_html/888innovation.com/vault/core/controller/db/xf.php at line 107
vw_DB_Controller_XF->query_write() in /home/dustinma/public_html/888innovation.com/vault/core/model/db/mysql/vw.php at line 829
vw_DB_MySQL_Model->shutdown_or_run() in /home/dustinma/public_html/888innovation.com/vault/core/model/db/mysql/vw.php at line 699
vw_DB_MySQL_Model->insert() in /home/dustinma/public_html/888innovation.com/vault/core/controller/dm/base/vw.php at line 1442
vw_DM_Base_Controller->defer() in /home/dustinma/public_html/888innovation.com/vault/core/controller/dm/area/vw.php at line 461
vw_DM_Area_Controller->delete_multiple() in /home/dustinma/public_html/888innovation.com/vault/core/controller/dm/base/vw.php at line 541
vw_DM_Base_Controller->delete() in /home/dustinma/public_html/888innovation.com/vault/core/controller/dm/area/xf.php at line 114
vw_DM_Area_Controller_XF->delete() in /home/dustinma/public_html/888innovation.com/vault/core/controller/dm/xf.php at line 416
vw_DM_Controller_XF->delete() in /home/dustinma/public_html/888innovation.com/vault/core/controller/cp/area/vw.php at line 445
vw_CP_Area_Controller->kill() in /home/dustinma/public_html/888innovation.com/vault/core/controller/cp/area/vw.php at line 53
vw_CP_Area_Controller->execute() in vw/XenForo/ControllerAdmin/Wiki.php at line 94
vw_XenForo_ControllerAdmin_Wiki->actionIndex() in XenForo/FrontController.php at line 337
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
XenForo_FrontController->run() in /home/dustinma/public_html/888innovation.com/admin.php at line 13

October 11, 2013 12:58 PM

pegasus

VaultWiki Team

That last error is actually the same bug that causes this: https://www.vaultwiki.org/issues/3393/

Reply

+ Reply

All times are GMT -4. The time now is 11:30 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: Error when hard deleting pages

Issue Tools