AbstractStatement.php:228

Issue Tools
- View Changes

December 5, 2020 3:27 AM

mazzly

Junior Member

XF\Db\Exception: Job XF:UserRenameCleanUp: MySQL statement prepare error [1146]: Table 'DBNAME.vw_reactions' doesn't exist src/XF/Db/AbstractStatement.php:228

XF\Db\Exception: Job XF:UserRenameCleanUp: MySQL statement prepare error [1146]: Table 'DBNAME.vw_reactions' doesn't exist src/XF/Db/AbstractStatement.php:228

Stack trace
UPDATE (
SELECT content_id FROM xf_reaction_content
WHERE content_type = ?
AND reaction_user_id = ?
) AS temp
INNER JOIN vw_reactions AS reaction_table ON (reaction_table.itemtypeid = 25 AND reaction_table.itemid = temp.content_id)
SET reaction_table.reaction_users = REPLACE(reaction_table.reaction_users, ?, ?)

------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL statement...', 1146, '42S02')
#1 src/XF/Db/Mysqli/Statement.php(39): XF\Db\Mysqli\Statement->getException('MySQL statement...', 1146, '42S02')
#2 src/XF/Db/Mysqli/Statement.php(54): XF\Db\Mysqli\Statement->prepare()
#3 src/XF/Db/AbstractAdapter.php(94): XF\Db\Mysqli\Statement->execute()
#4 src/addons/vw/vw/Handler/Reaction/base.php(136): XF\Db\AbstractAdapter->query('
UPDATE (
...', Array)
#5 src/XF/Service/User/ContentChange.php(348): vw\vw\Handler\Reaction\base->updateRecentCacheForUserChange(10615, 10615, 'catriona88', 'Prissy_Hobbit')
#6 src/XF/MultiPartRunnerTrait.php(48): XF\Service\User\ContentChange->stepRebuildReactions(3, G)
#7 src/XF/Service/User/ContentChange.php(203): XF\Service\User\ContentChange->runLoop(G)
#8 src/XF/Job/UserRenameCleanUp.php(34): XF\Service\User\ContentChange->apply(G)
#9 src/XF/Job/Manager.php(258): XF\Job\UserRenameCleanUp->run(G)
#10 src/XF/Job/Manager.php(200): XF\Job\Manager->runJobInternal(Array, G)
#11 src/XF/Job/Manager.php(84): XF\Job\Manager->runJobEntry(Array, G)
#12 job.php(43): XF\Job\Manager->runQueue(false, 8)
#13 {main}

Issue Details

Issue Number 6133

Issue Type Bug

Project VaultWiki 4.x Series

Category Moderator Tools

Status Fixed

Priority 1 - Security / Login / Data Loss

Affected Version 4.1.1

Fixed Version 4.1.1

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 (none)

December 5, 2020 7:09 AM

gerryvz

New Member

Same issue that I had immediately below.

The "fix" didn't work and I still have received the error after making the fix (inserting the code mentioned).

Reply
December 5, 2020 2:04 PM
pegasus

VaultWiki Team
In src/addons/vw/vw/Handler/Reaction/base.php, find:

Code:

INNER JOIN vw_reactions AS reaction_table

Replace with:

Code:

INNER JOIN " . \vw_DB::get()->query()->prefix('vw_reactions') . " AS reaction_table

In src/addons/vw/vw/Handler/Like/base.php, find:

Code:

\XF::db()->query("

BEFORE it, add:

Code:

$vwtable = \vw_DB::get()->query()->prefix($vwtable);
Reply

+ Reply

All times are GMT -4. The time now is 8:12 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: XF\Db\Exception: Job XF:UserRenameCleanUp: MySQL statement prepare error [1146]: Table 'DBNAME.vw_reactions' doesn't exist src/XF/Db/AbstractStatement.php:228

Issue Tools