Issue: [4.1 Alpha 3] XF1.5 to XF2.1 upgrade: vw_autolinkcache table missing, database exception error

Please send the upgrade log located in internal_data/vw_logs to:

For some reason, the whole vw_logs folder is missing . When the next Alpha release comes out, I will try upgrading to it from 1.5 and send you that log if vw_autolinkcache is missing at that time.

On a fresh test board running XF 1.5 with VW 4.0.25:
1. I upgraded XF to 2.1.
2. I upgraded VW to 4.0.0 Alpha 3 build 003.

After upgrading, my database correctly contains vw_autolinkcache.

However, I did not end up with a vw_logs folder. This was an issue with the recursive flag being omitted when creating the log file, and it will be fixed in the next release.

Thanks for trying to reproduce this.

I started with XF1.5 VW 4.0.24 and then:
1. Upgraded VW to 4.1.0. Alpha 3 build 002 (003 was not available at the time)
2. Upgraded XF to 2.1
3. Upgraded VW legacy addon to Alpha 3 build 002 (XF2.1 version, same version number)

FWIW, this testing XF instance is the same one that issue 5701 relates to, where I repeated the upgrade process.

I'll attempt this again with the next 4.1 release (possibly Alpha 4) to see whether this occurs again ... perhaps it was a side effect of the other fixed issue.

Same issue moving from Xf 1.5 with VW 4.1 alpha 2 build 3 to Xf 2.1 upgraded legacy addon to alpha 2 build 3:


Server error log
XF\Db\Exception: MySQL statement prepare error [1146]: Table 'chroniclesrp.vw_autolinkcache' doesn't exist src/XF/Db/AbstractStatement.php:217
Generated by: Unknown account Apr 12, 2019 at 7:22 PM
Stack trace
SELECT `xf_user_profile`.*, `vw_autolinkcache_vwAutoLinkCache_1`.*
FROM `xf_user_profile`
LEFT JOIN `vw_autolinkcache` AS `vw_autolinkcache_vwAutoLinkCache_1` ON (`vw_autolinkcache_vwAutoLinkCache_1`.`content_type` = 'user' AND `vw_autolinkcache_vwAutoLinkCache_1`.`content_id` = `xf_user_profile`.`user_id`)
WHERE (`xf_user_profile`.`user_id` = 8)


LIMIT 1
------------

#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/XF/Mvc/Entity/Finder.php(1261): XF\Db\AbstractAdapter->query('
SELECT `xf_...')
#5 src/XF/Mvc/Entity/Manager.php(149): XF\Mvc\Entity\Finder->fetchOne()
#6 src/XF/Mvc/Entity/Manager.php(357): XF\Mvc\Entity\Manager->find('XF:UserProfile', 8, Array)
#7 src/XF/Mvc/Entity/Entity.php(385): XF\Mvc\Entity\Manager->getRelation(Array, Object(vw\vw\XF\Entity\User))
#8 src/XF/Mvc/Entity/Entity.php(177): XF\Mvc\Entity\Entity->getRelation('Profile')
#9 src/XF/Mvc/Entity/Entity.php(101): XF\Mvc\Entity\Entity->get('Profile')
#10 src/XF/Session/Session.php(258): XF\Mvc\Entity\Entity->__get('Profile')
#11 src/XF/Admin/Controller/Login.php(108): XF\Session\Session->changeUser(Object(vw\vw\XF\Entity\User))
#12 src/XF/Admin/Controller/Login.php(70): XF\Admin\Controller\Login->completeLogin(Object(vw\vw\XF\Entity\User))
#13 src/XF/Mvc/Dispatcher.php(321): XF\Admin\Controller\Login->actionLogin(Object(XF\Mvc\ParameterBag))
#14 src/XF/Mvc/Dispatcher.php(248): XF\Mvc\Dispatcher->dispatchClass('XF:Login', 'Login', Object(XF\Mvc\RouteMatch), Object(XF\Admin\Controller\Login), NULL)
#15 src/XF/Mvc/Dispatcher.php(100): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(XF\Admin\Controller\Login), NULL)
#16 src/XF/Mvc/Dispatcher.php(50): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#17 src/XF/App.php(2177): XF\Mvc\Dispatcher->run()
#18 src/XF.php(390): XF\App->run()
#19 admin.php(13): XF::runApp('XF\\Admin\\App')
#20 {main}
Request state
array(4) {
["url"] => string(22) "/admin.php?login/login"
["referrer"] => string(39) "https://chroniclesrptests.com/admin.php"
["_GET"] => array(1) {
["login/login"] => string(0) ""
}
["_POST"] => array(6) {
["login"] => string(12) "Raigryn Vayd"
["password"] => string(8) "********"
["_xfToken"] => string(8) "********"
["_xfRequestUri"] => string(10) "/admin.php"
["_xfWithData"] => string(1) "1"
["_xfResponseType"] => string(4) "json"
}
}

I also do not have a vw_logs

I was able to reproduce the database error after following the upgrade procedure outlined by ACL.

This occurs when performing an upgrade in XF 2, if there is a branch of the VaultWiki upgrade that was never started before:
That is, specific changes for 1.3, 1.5, 2.0, etc that were not already performed at the initial install, and this is the first time the upgrade is noticing a branch change -
* The first step of the first upgrade script in the new branch was being skipped.

In src/addons/vw/vw/Setup.php, find:
Replace with:
To correct an existing installation that already upgraded, run the following MySQL queries:
Then you will be able to perform the upgrade again.

After the upgrade, you may want to cleanup any widgets / widget definitions that might have been duplicated.

Great news that you were able to produce this, thanks . I manually created the vw_autolinkcache table structure to fix the error - this issue occurred with a testing instance of VW 4.1 that I don't intend to keep.

Cheers, I'll give this a go!

I'm still in testing also!

Okay the change worked and now the vaultwiki works.

However I've lost access to the admin panel (this happened before) and get the following if I try and open a thread:


Chronicles RP - Fantasy Roleplay Forum
Chronicles RP - Fantasy Roleplay Forum
XF\Db\Exception: MySQL statement prepare error [1146]: Table 'chroniclesrp.vw_autolinkcache' doesn't exist in src/XF/Db/AbstractStatement.php at line 217
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/XF/Mvc/Entity/Finder.php at line 1261
XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 149
XF\Mvc\Entity\Manager->find() in src/XF/Pub/Controller/Thread.php at line 204
XF\Pub\Controller\Thread->actionPost() in src/XF/Mvc/Dispatcher.php at line 321
XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 248
XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
XF\App->run() in src/XF.php at line 390
XF::runApp() in index.php at line 20

Mine is alpha 2 (happen to open a seperate ticket if necessary)

XF\Db\Exception: MySQL statement prepare error [1146]: Table 'chroniclesrp.vw_autolinkcache' doesn't exist src/XF/Db/AbstractStatement.php:217
Generated by: Unknown account Apr 17, 2019 at 3:27 PM
Stack trace
SELECT `xf_user_profile`.*, `vw_autolinkcache_vwAutoLinkCache_1`.*
FROM `xf_user_profile`
LEFT JOIN `vw_autolinkcache` AS `vw_autolinkcache_vwAutoLinkCache_1` ON (`vw_autolinkcache_vwAutoLinkCache_1`.`content_type` = 'user' AND `vw_autolinkcache_vwAutoLinkCache_1`.`content_id` = `xf_user_profile`.`user_id`)
WHERE (`xf_user_profile`.`user_id` = 8)


LIMIT 1
------------

#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/XF/Mvc/Entity/Finder.php(1261): XF\Db\AbstractAdapter->query('
SELECT `xf_...')
#5 src/XF/Mvc/Entity/Manager.php(149): XF\Mvc\Entity\Finder->fetchOne()
#6 src/XF/Mvc/Entity/Manager.php(357): XF\Mvc\Entity\Manager->find('XF:UserProfile', 8, Array)
#7 src/XF/Mvc/Entity/Entity.php(385): XF\Mvc\Entity\Manager->getRelation(Array, Object(vw\vw\XF\Entity\User))
#8 src/XF/Mvc/Entity/Entity.php(177): XF\Mvc\Entity\Entity->getRelation('Profile')
#9 src/XF/Mvc/Entity/Entity.php(101): XF\Mvc\Entity\Entity->get('Profile')
#10 src/XF/Session/Session.php(258): XF\Mvc\Entity\Entity->__get('Profile')
#11 src/XF/Admin/Controller/Login.php(108): XF\Session\Session->changeUser(Object(vw\vw\XF\Entity\User))
#12 src/XF/Admin/Controller/Login.php(70): XF\Admin\Controller\Login->completeLogin(Object(vw\vw\XF\Entity\User))
#13 src/XF/Mvc/Dispatcher.php(321): XF\Admin\Controller\Login->actionLogin(Object(XF\Mvc\ParameterBag))
#14 src/XF/Mvc/Dispatcher.php(248): XF\Mvc\Dispatcher->dispatchClass('XF:Login', 'Login', Object(XF\Mvc\RouteMatch), Object(XF\Admin\Controller\Login), NULL)
#15 src/XF/Mvc/Dispatcher.php(100): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(XF\Admin\Controller\Login), NULL)
#16 src/XF/Mvc/Dispatcher.php(50): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#17 src/XF/App.php(2177): XF\Mvc\Dispatcher->run()
#18 src/XF.php(390): XF\App->run()
#19 admin.php(13): XF::runApp('XF\\Admin\\App')
#20 {main}
Request state
array(4) {
["url"] => string(22) "/admin.php?login/login"
["referrer"] => string(39) "https://chroniclesrptests.com/admin.php"
["_GET"] => array(1) {
["login/login"] => string(0) ""
}
["_POST"] => array(6) {
["login"] => string(12) "Raigryn Vayd"
["password"] => string(8) "********"
["_xfToken"] => string(8) "********"
["_xfRequestUri"] => string(10) "/admin.php"
["_xfWithData"] => string(1) "1"
["_xfResponseType"] => string(4) "json"
}
}

Oh good, so it wasn't just me.

As stated before, I created the table structure manually to stop the error. I used phpmyadmin to copy the vw_autolinkcache table structure from a functional VW instance in a different database. Then I switched to my testing DB and ran the CREATE TABLE sql code. I could PM you the code if you wanted it. Or wait for proper fixes/instructions from pegasus.

Thanks for this. It looks like it is not actually possible to fix this state just by running the upgrade again, since the table is referenced in the AdminCP and you need access to the AdminCP in order to run the upgrade.

You can manually create the table as ACL has done:
###
For now, we will just have to assume that all existing installations are broken and make some changes in the ZIP. If you created the table, you don't need to do the following.

In src/addons/vw/vw/XF/Entity/Post.php, UserProfile.php, and ConversationMessage.php, find:
Replace with:
This will defer the feature until a later version so we have a chance to try the table creations again.