Issue: Update error

Issue Tools
- View Changes

October 14, 2024 12:32 PM

hollosch

Senior Member

Update error

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

When updating the deactivated plugin the following error occurred:

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 'AND 1726327809 < dateline 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/Base.php at line 341
vw\vw\Handler\ActivityLog\Base->vwGetSynonymMetrics() in src/addons/vw/vw/Handler/ActivityLog/Page.php at line 150
vw\vw\Handler\ActivityLog\PageAbstract->vwGetContentMetrics() in src/addons/vw/vw/Handler/ActivityLog/Base.php at line 246
vw\vw\Handler\ActivityLog\Base->getVwcontentMetrics() in src/addons/vw/vw/Handler/ActivityLog/Base.php at line 127
vw\vw\Handler\ActivityLog\Base->rebuildVwcontentMetrics() in src/addons/vw/vw/XF/Repository/ActivityLog.php at line 47
vw\vw\XF\Repository\ActivityLog->rebuildVwcontentMetrics() 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 253
vw_Install_UpgradePath_Steps_418_XF23_Controller_XF2->rebuild_content_activity() in src/addons/vw/vw/_install/lib/upgradepath/steps/4/1/8/XF23/xf2.php at line 212
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 6448

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 4.1.8

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 14, 2024 1:22 PM
pegasus

VaultWiki Team
Fixed in the next build. This occurs when rebuilding the XenForo activity log for existing wiki pages that are corrupt and cannot be accessed. It should be possible to fix/cleanup such wiki pages after upgrading using "Remove Corrupt Content", followed by "Rebuild Content URLs".

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

Code:

$trends[] = $this->vwGetSynonymMetrics($item['routeid'], $cutoff);

Replace with:

Code:

if (!empty($item['routeid'])) $trends[] = $this->vwGetSynonymMetrics($item['routeid'], $cutoff);
Reply

+ Reply

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