Have attempted twice now from fresh snapshots. Have tried full file list and just new files.
What is the most sensible way forward?
Kind Regards,
Expanse
Each time:
Code:
Upgrading to 4.0.21
Step 5
Updating data in table: vw_counter
An exception occurred: Database Error: SELECT COUNT(`revisionid`) AS `counter` FROM `vw_revision` WHERE pageid = AND revisionid != AND visible = 1 AND !(`flags` & 2) 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 revisionid != AND visible = 1 AND !(`flags` & 2)' at line 1 in [path]/vault/core/controller/db/xf.php on line 187
#0: vw_DB_Controller_XF->throw_error() in [path]/vault/core/controller/db/xf.php at line 268
#1: vw_DB_Controller_XF->query_first() in [path]/vault/core/model/db/mysql/vw.php at line 27
#2: vw_DB_MySQL_Model->select() in [path]/vault/install/lib/upgradepath/steps/4/0/21/base/vw.php at line 376
#3: vw_Install_UpgradePath_Steps_4021_base_Controller->{closure}() in [path]/vault/core/controller/progress/steps/vw.php at line 83
#4: vw_Progress_Steps_Controller->call() in [path]/vault/core/controller/progress/steps/vw.php at line 53
#5: vw_Progress_Steps_Controller->execute() in [path]/vault/install/lib/upgradepath/vw.php at line 62
#6: vw_Install_UpgradePath_Controller->exec_script() in [path]/vault/core/controller/progress/vw.php at line 74
#7: vw_Progress_Controller->execute() in [path]/vault/core/controller/cp/progress/vw.php at line 37
#8: vw_CP_Progress_Controller->process() in [path]/vault/core/controller/cp/install/vw.php at line 330
#9: vw_CP_Install_Controller->upgrade() in [path]/vault/core/controller/cp/install/vw.php at line 56
#10: vw_CP_Install_Controller->execute() in [path]/library/vw/XenForo/ControllerAdmin/Wiki.php at line 125
#11: vw_XenForo_ControllerAdmin_Wiki->actionIndex() in [path]/library/vw/XenForo/ControllerAdmin/Wiki.php at line 182
#12: vw_XenForo_ControllerAdmin_Wiki->actionUpgrade() in [path]/library/XenForo/FrontController.php at line 369
#13: XenForo_FrontController->dispatch() in [path]/library/XenForo/FrontController.php at line 152
#14: XenForo_FrontController->run() in [path]/admin.php at line 13
I think this might happen if the upgrade script processes a feed, although I'm not sure how it got through QA, as the wikis we use contain a number of feeds.
In vault/install/lib/upgradepath/steps/4/0/21/base/vw.php, find:
I see that the upgrade script is not properly regenerating missing BB-Codes in XenForo. I was able to reproduce the issue on a test board that was upgrade from the Lite version.
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.