Database Error on creating Areas
Attempted to create a new area to store pages for projects on the Wiki.
Upon creating the Area, I received this error in the AdminCP:
Server Error
Database Error: SELECT * FROM `vw_lastupdate` WHERE nodetypeid = 3 AND nodeid = ORDER BY lastdateline DESC LIMIT 10 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 'ORDER BY lastdateline DESC LIMIT 10' at line 1
vw_DB_Controller_XF->throw_error() in /var/www/html/vault/core/controller/db/xf.php at line 203
vw_DB_Controller_XF->query_read() in /var/www/html/vault/core/model/db/mysql/vw.php at line 27
vw_DB_MySQL_Model->select() in /var/www/html/vault/core/controller/dm/base/vw.php at line 1363
vw_DM_Base_Controller->move_lastupdate() in /var/www/html/vault/core/controller/dm/area/vw.php at line 465
vw_DM_Area_Controller->post_save_once() in /var/www/html/vault/core/controller/dm/area/xf.php at line 96
vw_DM_Area_Controller_XF->_postSaveAfterTransaction() in XenForo/DataWriter.php at line 1437
XenForo_DataWriter->save() in /var/www/html/vault/core/controller/dm/xf.php at line 431
vw_DM_Controller_XF->save() in /var/www/html/vault/core/controller/cp/area/vw.php at line 490
vw_CP_Area_Controller->do_save() in /var/www/html/vault/core/controller/cp/area/vw.php at line 167
vw_CP_Area_Controller->process_save() in /var/www/html/vault/core/controller/cp/area/vw.php at line 152
vw_CP_Area_Controller->save() in /var/www/html/vault/core/controller/cp/area/vw.php at line 65
vw_CP_Area_Controller->execute() in vw/XenForo/ControllerAdmin/Wiki.php at line 125
vw_XenForo_ControllerAdmin_Wiki->actionIndex() in XenForo/FrontController.php at line 369
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 152
XenForo_FrontController->run() in /var/www/html/admin.php at line 13
The Area was created. Upon navigating to the Area, I received this error:
Server Error
Invalid argument supplied for foreach()
XenForo_Application::handlePhpError() in /var/www/html/vault/core/view/ui/area/vw.php at line 62
vw_UI_Area_View->view() in /var/www/html/vault/core/controller/ui/area/vw.php at line 159
vw_UI_Area_Controller->view() in /var/www/html/vault/core/controller/ui/stack/vw.php at line 374
vw_UI_Stack_Controller->view() in /var/www/html/vault/core/controller/ui/stack/vw.php at line 290
vw_UI_Stack_Controller->execute() in vw/XenForo/ControllerPublic/Wiki.php at line 70
vw_XenForo_ControllerPublic_Wiki->actionIndex() in XenForo/FrontController.php at line 369
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 152
XenForo_FrontController->run() in /var/www/html/index.php at line 13
The Area could be edited. I edited the Display Order - changing it from 999 to 100. The edit went through and I could access the Area on the Wiki. I changed the Display Order back to 999 and I didn't receive a repeat error.
The problem is repeatable by creating new Areas. Editing the Display Order removes the problem.