Issue: Upgrade to RC2 Failed

Issue Tools
- View Changes

April 14, 2020 5:29 AM

expanserpb

Junior Member

Upgrade to RC2 Failed

XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'fakecategory.areaid' in 'where clause' in src/XF/Db/AbstractStatement.php at line 228
XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 196
XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 39
XF\Db\Mysqli\Statement->prepare() in src/XF/Db/Mysqli/Statement.php at line 54
XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
XF\Db\AbstractAdapter->query() in src/addons/vw/vw/_core/controller/db/xf2.php at line 148
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/_core/model/cron/deferred/node/vw.php at line 74
vw_Cron_Deferred_Node_Model->run() in src/addons/vw/vw/_core/model/cron/deferred/vw.php at line 64
vw_Cron_Deferred_Model->exec() in src/addons/vw/vw/Handler/Job/Defer.php at line 30
vw\vw\Handler\Job\Defer->run() in src/XF/Job/Manager.php at line 253
XF\Job\Manager->runJobInternal() in src/XF/Job/Manager.php at line 195
XF\Job\Manager->runJobEntry() in src/XF/Job/Manager.php at line 111
XF\Job\Manager->runByIds() in src/XF/Admin/Controller/Tools.php at line 120
XF\Admin\Controller\Tools->actionRunJob() in src/XF/Mvc/Dispatcher.php at line 350
XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2184
XF\App->run() in src/XF.php at line 391
XF::runApp() in admin.php at line 13

Now recurring:

XF\Db\Exception: Job vw\vw\Handler\Job\Defer: MySQL statement prepare error [1054]: Unknown column 'fakecategory.areaid' in 'where clause' src/XF/Db/AbstractStatement.php:228
Generated by: Unknown account Apr 14, 2020 at 10:28 AM
Stack trace
SELECT * FROM `vw_fakecategory` `fakecategory` WHERE `fakecategory`.`areaid` IN (909) LIMIT 1000
------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL statement...', 1054, '42S22')
#1 src/XF/Db/Mysqli/Statement.php(39): XF\Db\Mysqli\Statement->getException('MySQL statement...', 1054, '42S22')
#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/_core/controller/db/xf2.php(148): XF\Db\AbstractAdapter->query('SELECT * FROM `...')
#5 src/addons/vw/vw/_core/model/db/mysql/vw.php(25): vw_DB_Controller_XF2->query_read('SELECT * FROM `...')
#6 src/addons/vw/vw/_core/model/cron/deferred/node/vw.php(74): vw_DB_MySQL_Model->select(Array)
#7 src/addons/vw/vw/_core/model/cron/deferred/vw.php(64): vw_Cron_Deferred_Node_Model->run(Array)
#8 src/addons/vw/vw/Handler/Job/Defer.php(30): vw_Cron_Deferred_Model->exec()
#9 src/XF/Job/Manager.php(253): vw\vw\Handler\Job\Defer->run(G)
#10 src/XF/Job/Manager.php(195): XF\Job\Manager->runJobInternal(Array, G)
#11 src/XF/Job/Manager.php(79): XF\Job\Manager->runJobEntry(Array, G)
#12 job.php(42): XF\Job\Manager->runQueue(false, 8)
#13 {main}
Request state
array(4) {
["url"] => string(8) "/job.php"
["referrer"] => string(46) "https://chroniclesrp.net/Folklore/Raigryn-Vayd"
["_GET"] => array(0) {
}
["_POST"] => array(0) {
}
}

Cant tell if the upgrade has worked or I need to restore from backup?

Can't seem to see comments on any articles any more.

Issue Details

Issue Number 6021

Issue Type Bug

Project VaultWiki 4.x Series

Category Unknown

Status Fixed

Priority 1 - Security / Login / Data Loss

Affected Version 4.1.0 RC 1

Fixed Version 4.1.0 RC 2

Milestone (none)

Software DependencyAny

License TypePaid

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

April 14, 2020 5:35 AM

expanserpb

Junior Member

Ah, comments is down to new permissions

Reply
April 14, 2020 5:46 AM

expanserpb

Junior Member

Seems to be working...

Reply
April 14, 2020 11:59 AM
pegasus

VaultWiki Team
This is queued when deleting an area. Template-categories, while they are tagged internally as content, are not actually saved in an area, so this will fail every time. You will need to manually delete the task from your database, or you will see this same error at the end every time you upgrade.

You probably have a recent task that will respond to this query:

Code:

SELECT * FROM vw_defer WHERE defer = 'node' AND hold = 1

The one that needs to be removed will have blob-data referring to 'fakecategory'.

To prevent this from happening the next time you delete an area, in src/addons/vw/vw/_core/controller/dm/area/vw.php, find:

Code:

$alias = strtolower($cNode['table']);

BEFORE it, add:

Code:

if (!$cNode['isAllowed']) continue;
Reply

+ Reply

All times are GMT -4. The time now is 8:08 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: Upgrade to RC2 Failed

Issue Tools