Issue: [XF2.2.1] MySQL statement prepare error [1146]: Table 'xenforo.vw_page' doesn't exist

Issue Tools
- View Changes

December 2, 2020 7:11 AM

gerryvz

New Member

[XF2.2.1] MySQL statement prepare error [1146]: Table 'xenforo.vw_page' doesn't exist

I received this error last night, just one of them. Looks like it may be a mis-named table?

Code:

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

    Generated by: Unknown account Dec 1, 2020 at 7:00 PM 

Stack trace

						UPDATE IGNORE `vw_page` SET
							`creatorid` = 0, `creatorname` = 'romanash95'
						WHERE `creatorid` = ?
					
------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException()
#1 src/XF/Db/Mysqli/Statement.php(39): XF\Db\Mysqli\Statement->getException()
#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/XF/Service/User/ContentChange.php(256): XF\Db\AbstractAdapter->query()
#5 src/XF/MultiPartRunnerTrait.php(48): XF\Service\User\ContentChange->stepReassignContent()
#6 src/XF/Service/User/ContentChange.php(203): XF\Service\User\ContentChange->runLoop()
#7 src/XF/Service/User/DeleteCleanUp.php(308): XF\Service\User\ContentChange->apply()
#8 src/XF/MultiPartRunnerTrait.php(48): XF\Service\User\DeleteCleanUp->stepChangeOwner()
#9 src/XF/Service/User/DeleteCleanUp.php(94): XF\Service\User\DeleteCleanUp->runLoop()
#10 src/XF/Job/UserDeleteCleanUp.php(32): XF\Service\User\DeleteCleanUp->cleanUp()
#11 src/XF/Job/Manager.php(258): XF\Job\UserDeleteCleanUp->run()
#12 src/XF/Job/Manager.php(200): XF\Job\Manager->runJobInternal()
#13 src/XF/Job/Manager.php(84): XF\Job\Manager->runJobEntry()
#14 job.php(43): XF\Job\Manager->runQueue()
#15 {main}

Request state

array(4) {
  ["url"] => string(15) "/forums/job.php"
  ["referrer"] => string(83) "https://www.500eboard.co/forums/threads/valve-timing-camshaft-jumped-1-tooth.14790/"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(0) {
  }
}

Delete

Issue Details

Issue Number 6129

Issue Type Bug

Project VaultWiki 4.x Series

Category Unknown

Status Fixed

Priority 5 - Minor Bugs / Small Tweaks

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 2, 2020 1:08 PM
pegasus

VaultWiki Team
Fixed in the next build. This occurs during cleanup when a user is deleted or merged. In src/addons/vw/vw/XF/Service/User/ContentChange.php, find:

Code:

if (isset($this->updates[$update['table']]))

BEFORE it, add:

Code:

$update['table'] = \vw_DB::get()->query()->prefix($update['table']);
Reply
December 4, 2020 7:09 AM
gerryvz

New Member
Made the change per above.

Still got the same error last night.

Code:

MySQL statement prepare error [1146]: Table 'xenforo.vw_page' doesn't exist

In addition to a file integrity check error, which I guess is to be expected.
Reply
December 7, 2020 12:31 PM

pegasus

VaultWiki Team

Considering that another user reported: https://www.vaultwiki.org/issues/6133/
It would only be possible for the user to receive that error if the change posted above did actually fix the issue you reported here. And I do not see another way for the error to occur, assuming it is the same stack trace from the first post.

Therefore it is likely that your PHP installation is using a long-lived opcache. When making changes to your .php files, you may need to restart the server's PHP process in order to reset the cache. Otherwise PHP will keep using the old file contents (from before your code change) until the opcache lifetime is reached.

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: [XF2.2.1] MySQL statement prepare error [1146]: Table 'xenforo.vw_page' doesn't exist

Issue Tools