Issue: Update error

Issue Tools
- View Changes

October 15, 2024 5:24 AM

hollosch

Senior Member

Update error

XF\Db\InvalidQueryException: MySQL statement prepare error [1064]

Next error:

XF\Db\InvalidQueryException: MySQL statement prepare error [1064]: 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 'GROUP BY log_date ORDER BY log_date ASC' at line 1 in src/XF/Db/AbstractStatement.php at line 230
XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 207
XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 43
XF\Db\Mysqli\Statement->prepare() in src/XF/Db/Mysqli/Statement.php at line 61
XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
XF\Db\AbstractAdapter->query() in src/addons/vw/vw/_core/controller/db/xf2.php at line 172
vw_DB_Controller_XF2->query_read() in src/addons/vw/vw/_core/model/db/mysql/vw.php at line 25
vw_DB_MySQL_Model->select() in src/addons/vw/vw/Handler/ActivityLog/Page.php at line 236
vw\vw\Handler\ActivityLog\PageAbstract->vwGetHistoryTypeMetrics() in src/addons/vw/vw/Handler/ActivityLog/Page.php at line 214
vw\vw\Handler\ActivityLog\PageAbstract->vwGetHistoryMetrics() in src/addons/vw/vw/Handler/ActivityLog/Base.php at line 262
vw\vw\Handler\ActivityLog\Base->getVweditMetrics() in src/addons/vw/vw/Handler/ActivityLog/Base.php at line 139
vw\vw\Handler\ActivityLog\Base->rebuildVweditMetrics() in src/addons/vw/vw/XF/Repository/ActivityLog.php at line 83
vw\vw\XF\Repository\ActivityLog->rebuildVweditMetrics() in src/addons/vw/vw/_install/lib/upgradepath/steps/4/1/8/XF23/xf2.php at line 298
vw_Install_UpgradePath_Steps_418_XF23_Controller_XF2->rebuild_activity() in src/addons/vw/vw/_install/lib/upgradepath/steps/4/1/8/XF23/xf2.php at line 263
vw_Install_UpgradePath_Steps_418_XF23_Controller_XF2->rebuild_edit_activity() in src/addons/vw/vw/_install/lib/upgradepath/steps/4/1/8/XF23/xf2.php at line 229
vw_Install_UpgradePath_Steps_418_XF23_Controller_XF2->{closure}() in src/addons/vw/vw/Setup.php at line 350
vw\vw\Setup->vwRunStep() in src/addons/vw/vw/Setup.php at line 1090
vw\vw\Setup->upgrade() in src/XF/Admin/Controller/AddOnController.php at line 617
XF\Admin\Controller\AddOnController->actionUpgrade() in src/XF/Mvc/Dispatcher.php at line 362
XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 264
XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 121
XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 63
XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2826
XF\App->run() in src/XF.php at line 806
XF::runApp() in admin.php at line 15

Issue Details

Issue Number 6450

Issue Type Bug

Project VaultWiki 4.x Series

Category Install / Upgrade

Status Fixed

Priority 2 - Fatal / Database Errors

Affected Version 4.1.8

Fixed Version (none)

Milestone (none)

Software DependencyXenForo 2.x

License TypePaid

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags update

October 15, 2024 9:57 AM
pegasus

VaultWiki Team
Hard to tell, but I believe this can happen if we try to rebuild the activity log for a wiki attachment page that is corrupt by all the attachment-related rows being missing from the database.

In src/addons/vw/vw/Handler/ActivityLog/Page.php, find:

Code:

if ($parenttype['isPage'])

Replace with:

Code:

if ($parenttype['isPage'] AND !empty($item[$parenttype['idfield']]))
Reply

+ Reply

All times are GMT -4. The time now is 11:10 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: Update error

Issue Tools