Issue: DATABASE ERROR DELETE FROM `vw_lastupdatecache`

Issue Tools
- View Changes

August 23, 2018 3:39 AM

expanserpb

Junior Member

DATABASE ERROR DELETE FROM `vw_lastupdatecache`

XenForo_Exception: Database Error: DELETE FROM `vw_lastupdatecache` WHERE nodetypeid = AND `nodeid` IN (57) LIMIT 1 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 'AND `nodeid` IN (57) LIMIT 1' at line 1 - vault/core/controller/db/xf.php:187
Generated By: Netherworld, Yesterday at 8:59 PM
Stack Trace
#0 /var/www/html/vault/core/controller/db/xf.php(171): vw_DB_Controller_XF->throw_error(Object(Zend_Db_Statement_Mysqli_Exception) , 'DELETE FROM `vw...')
#1 /var/www/html/vault/core/model/db/mysql/vw.php(1125): vw_DB_Controller_XF->query_write('DELETE FROM `vw...')
#2 /var/www/html/vault/core/model/db/mysql/vw.php(352): vw_DB_MySQL_Model->shutdown_or_run('DELETE FROM `vw...', false)
#3 /var/www/html/vault/core/controller/dm/base/vw.php(1482): vw_DB_MySQL_Model->delete(Array)
#4 /var/www/html/vault/core/controller/dm/item/category/vw.php(447): vw_DM_Base_Controller->move_lastupdate(Array, Array, Array)
#5 /var/www/html/vault/core/controller/dm/vw.php(118): vw_DM_Item_Category_Controller->delete_multiple(Array)
#6 /var/www/html/vault/core/controller/ui/imod/vw.php(2107): vw_DM_Controller->delete_multiple(Array)
#7 /var/www/html/vault/core/controller/ui/imod/vw.php(171): vw_UI_iMod_Controller->kill_from_node()
#8 /var/www/html/library/vw/XenForo/ControllerPublic/Wiki/Moderate.php(51): vw_UI_iMod_Controller->execute()
#9 /var/www/html/library/XenForo/FrontController.php(369): vw_XenForo_ControllerPublic_Wiki_Moderate->actionIndex()
#10 /var/www/html/library/XenForo/FrontController.php(152): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#11 /var/www/html/index.php(13): XenForo_FrontController->run()
#12 {main}
Request State
array(3) {
["url"] => string(59) "https://chroniclesrp.net/Folklore-moderate/?do=dodeletefrom"
["_GET"] => array(1) {
["do"] => string(12) "dodeletefrom"
}
["_POST"] => array(8) {
["sbutton"] => string(3) "Yes"
["do"] => string(12) "dodeletefrom"
["_xfToken"] => string(8) "********"
["rootid"] => string(2) "57"
["roottype"] => string(2) "15"
["returnid"] => string(2) "57"
["returntype"] => string(1) "1"
["items"] => array(1) {
[1] => array(1) {
[54] => string(2) "54"
}
}
}
}

Issue Details

Issue Number 5456

Issue Type Bug

Project VaultWiki 4.x Series

Category Categories

Status Fixed

Priority 4 - Warnings / Script Errors

Affected Version 4.0.23

Fixed Version 4.0.24

Milestone (none)

Software DependencyAny

License TypePaid

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

August 23, 2018 10:15 AM

pegasus

VaultWiki Team

Fixed in the next release. In vault/core/model/node/vw.php, find:

Code:

			if (isset($key['itemtypeid']))
			{
				$key = $key['itemtypeid'];
			}

After it, add:

Code:

			else if (isset($key['accesskey']))
			{
				// probably passed what we will return anyway
				$key = $key['accesskey'];
			}

August 24, 2018 6:33 AM

expanserpb

Junior Member

That quite neatly broke the wiki as there is another else right after it:

if (is_array($key))
{
if (isset($key['itemtypeid']))
{
$key = $key['itemtypeid'];
}
else
{
return null;
}

ParseError: syntax error, unexpected 'else' (T_ELSE) - vault/core/model/node/vw.php:32
Generated By: Unknown Account, A moment ago
Stack Trace
#0 /var/www/html/vault/core/model/vw.php(331): vw_Hard_Core::locate_class('Model', 'Node_Model', '/var/www/html/v...', Array)
#1 /var/www/html/vault/core/model/vw.php(697): vw_Hard_Core::fetch_object('Model', 'Node', '')
#2 /var/www/html/vault/core/controller/route/vw.php(1278): vw_Hard_Core::model('Node')
#3 /var/www/html/vault/core/controller/route/vw.php(1216): vw_Route_Controller->construct_routecache(Array, 0, Array)
#4 /var/www/html/vault/core/controller/route/vw.php(367): vw_Route_Controller->fetch_routes(Array)
#5 /var/www/html/vault/core/controller/route/xf.php(91): vw_Route_Controller->resolve_path(Array, 1, true)
#6 /var/www/html/library/vw/XenForo/Route/Prefix/vw.php(99): vw_Route_Controller_XF->resolve_path(Array, 1)
#7 /var/www/html/library/XenForo/Router.php(72): vw_XenForo_Route_Prefix_vw->match('Folklore/', Object(Zend_Controller_Request_Http), Object(XenForo_Router))
#8 /var/www/html/library/XenForo/Dependencies/Abstract.php(107): XenForo_Router->match(Object(Zend_Controller_Request_Http), 'Folklore/')
#9 /var/www/html/library/XenForo/FrontController.php(307): XenForo_Dependencies_Abstract->route(Object(Zend_Controller_Request_Http), NULL)
#10 /var/www/html/library/XenForo/FrontController.php(148): XenForo_FrontController->route()
#11 /var/www/html/index.php(13): XenForo_FrontController->run()
#12 {main}
Request State
array(3) {
["url"] => string(34) "https://chroniclesrp.net/Folklore/"
["_GET"] => array(0) {
}
["_POST"] => array(0) {
}
}

Reply
August 24, 2018 9:57 AM

pegasus

VaultWiki Team

You performed a code replace. The instructions were to insert the new code after the original code.

Reply
August 24, 2018 10:36 AM

expanserpb

Junior Member

Quite right

Reply

+ Reply

All times are GMT -4. The time now is 3:29 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 ERROR DELETE FROM `vw_lastupdatecache`

Issue Tools