Issue: InvalidArgumentException when upgrading from 4.0.15 to 4.1.0 Beta 2

Issue Tools
- View Changes

July 31, 2019 11:49 PM

Vilandra

New Member

InvalidArgumentException when upgrading from 4.0.15 to 4.1.0 Beta 2

Received an error when running the upgrade script

When trying to run the upgrade script, I receive the following error:

Code:

InvalidArgumentException: Unknown relation Likes in src/XF/Mvc/Entity/Entity.php at line 457
XF\Mvc\Entity\Entity->hydrateRelation() in src/addons/vw/vw/Helper/Entity/Entity.php at line 200
vw\vw\Helper\Entity\Entity::doCreate() in src/addons/vw/vw/Helper/Entity/Entity.php at line 107
vw\vw\Helper\Entity\Entity::create() in src/addons/vw/vw/_core/instance/parser/renderer/xf2.php at line 188
vw_Parser_Renderer_Instance_XF2->set_item() in src/addons/vw/vw/_core/model/parser/instance/xf2.php at line 108
vw_Parser_Instance_Model_XF2->parse() in src/addons/vw/vw/_core/controller/dm/page/vw.php at line 1202
vw_DM_Page_Controller->process_links() in src/addons/vw/vw/_core/controller/dm/page/vw.php at line 896
vw_DM_Page_Controller->process_revision() in src/addons/vw/vw/_core/controller/dm/page/vw.php at line 787
vw_DM_Page_Controller->pre_save() in src/addons/vw/vw/XF/Entity/EntityBase.php at line 490
vw\vw\XF\Entity\EntityBase->_preSave() in src/XF/Mvc/Entity/Entity.php at line 1297
XF\Mvc\Entity\Entity->preSave() in src/addons/vw/vw/XF/Entity/EntityBase.php at line 481
vw\vw\XF\Entity\EntityBase->vwPreSave() in src/addons/vw/vw/XF/Entity/EntityBase.php at line 536
vw\vw\XF\Entity\EntityBase->vwSave() in src/addons/vw/vw/_core/controller/dm/xf2.php at line 363
vw_DM_Controller_XF2->save() in src/addons/vw/vw/_install/lib/upgradepath/steps/4/0/16/base/vw.php at line 2216
vw_Install_UpgradePath_Steps_4016_base_Controller->{closure}() in src/addons/vw/vw/Setup.php at line 299
vw\vw\Setup->vwRunStep() in src/addons/vw/vw/Setup.php at line 954
vw\vw\Setup->upgrade() in src/XF/Admin/Controller/AddOn.php at line 576
XF\Admin\Controller\AddOn->actionUpgrade() 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 2178
XF\App->run() in src/XF.php at line 390
XF::runApp() in admin.php at line 13

Issue Details

Issue Number 5804

Issue Type Bug

Project VaultWiki 4.x Series

Category Install / Upgrade

Status Fixed

Priority 2 - Fatal / Database Errors

Affected Version 4.1.0 Beta 2

Fixed Version 4.1.0 Beta 2

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)

August 10, 2019 2:47 PM

Vilandra

New Member

Originally Posted by pegasus

Wow. I'm amazed by some of these you're finding. The fact that people managed to get through the 4.0.18 upgrades for over 2 years with problems like this in there boggles my mind.

I'm just lucky I guess

Originally Posted by pegasus

If at any point you get fatigued by these, please don't hesitate to request a ticket and I'll complete the rest of the upgrade for you.

As long as you're okay with it, I'm okay with it

But if it's annoying you to do it piecemeal, just let me know.

Okay, so that got us to 4.0.19 Step 12 and this error:

Code:

XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'minorid' in 'where clause' 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/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/controller/cp/counter/contribute/vw.php at line 41
vw_CP_Counter_Contribute_Controller->update() in src/addons/vw/vw/_install/lib/upgradepath/steps/4/0/19/base/vw.php at line 1271
vw_Install_UpgradePath_Steps_4019_base_Controller->{closure}() in src/addons/vw/vw/Setup.php at line 299
vw\vw\Setup->vwRunStep() in src/addons/vw/vw/Setup.php at line 954
vw\vw\Setup->upgrade() in src/XF/Admin/Controller/AddOn.php at line 576
XF\Admin\Controller\AddOn->actionUpgrade() 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 2178
XF\App->run() in src/XF.php at line 390
XF::runApp() in admin.php at line 13

August 10, 2019 3:58 PM

pegasus

VaultWiki Team

In src/addons/vw/vw/_core/controller/cp/counter/contribute/vw.php, find:

Code:

	public function get_query_contribs()
	{

AFTER it, add:

Code:

		if (!vw_Hard_Core::model('Version')->installed('4.1.0 Beta 1'))
		{
			$minor = vw_Hard_Core::model('Bitfield')->get_bit('misc', 'vw_revision_flags', 'minor');

			return array(
				'fields' => array(
					'userid',
					vw_DB::get()->query()->count('revisionid') => 'counter'
				),
				'table' => 'vw_revision',
				'where' => array(
					vw_DB::get()->query()->gt('userid', 0),
					vw_DB::get()->query()->eq('visible', 1),
					vw_DB::get()->query()->bc('flags', $minor, false)
				),
				'order' => array('userid' => 'ASC'),
				'group' => array('userid')
			);
		}

August 10, 2019 4:09 PM

Vilandra

New Member

Now 4.0.20 Step 10 ==Updating data in table: vw_special:

Code:

Error: Call to undefined method vw_Fetch_Index_Controller::get() in src/addons/vw/vw/_core/controller/fetch/index/vw.php at line 139
vw_Fetch_Index_Controller->query() in src/addons/vw/vw/_core/controller/fetch/vw.php at line 539
vw_Fetch_Controller->query() in src/addons/vw/vw/_core/controller/fetch/vw.php at line 388
vw_Fetch_Controller->get() in src/addons/vw/vw/_core/controller/fetch/index/vw.php at line 78
vw_Fetch_Index_Controller->cached() in src/addons/vw/vw/_core/controller/fetch/vw.php at line 279
vw_Fetch_Controller->cached() in src/addons/vw/vw/Handler/Search/Data/Base.php at line 94
vw\vw\Handler\Search\Data\Base->getIndexData() in src/XF/Search/Search.php at line 37
XF\Search\Search->index() in src/addons/vw/vw/Behavior/Indexable.php at line 30
vw\vw\Behavior\Indexable->vw\vw\Behavior\{closure}() in src/XF.php at line 290
XF::triggerRunOnce() in src/addons/vw/vw/_core/instance/progress/xf2.php at line 50
vw_Progress_Instance_XF2->shutdown() in src/addons/vw/vw/_core/instance/progress/xf2.php at line 140
vw_Progress_Instance_XF2->except() in src/addons/vw/vw/_core/instance/progress/xf2.php at line 106
vw_Progress_Instance_XF2->write() in src/addons/vw/vw/_core/instance/progress/vw.php at line 111
vw_Progress_Instance->next() in src/addons/vw/vw/Setup/Caller/AbstractCaller.php at line 215
vw\vw\Setup\Caller\AbstractCaller->close() in src/addons/vw/vw/_install/lib/upgradepath/steps/4/0/20/base/vw.php at line 479
vw_Install_UpgradePath_Steps_4020_base_Controller->{closure}() in src/addons/vw/vw/Setup.php at line 299
vw\vw\Setup->vwRunStep() in src/addons/vw/vw/Setup.php at line 954
vw\vw\Setup->upgrade() in src/XF/Admin/Controller/AddOn.php at line 576
XF\Admin\Controller\AddOn->actionUpgrade() 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 2178
XF\App->run() in src/XF.php at line 390
XF::runApp() in admin.php at line 13

August 10, 2019 4:22 PM
pegasus

VaultWiki Team
In src/addons/vw/vw/_core/controller/fetch/index/vw.php, find:

Code:

$index_pages = $this->get('Page', array(

Replace with:

Code:

$index_pages = $caller->get('Page', array(
Reply

August 10, 2019 4:48 PM

Vilandra

New Member

Upgrading to 4.0.22 ==

== Step 28 (0) ==
Updating data in table: vw_moderator

Code:

XF\Db\InvalidQueryException: MySQL statement prepare error [1064]: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '= 0' at line 10 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
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/controller/fetch/vw.php at line 398
vw_Fetch_Controller->get() in src/addons/vw/vw/_core/controller/fetch/index/vw.php at line 141
vw_Fetch_Index_Controller->query() in src/addons/vw/vw/_core/controller/fetch/vw.php at line 539
vw_Fetch_Controller->query() in src/addons/vw/vw/_core/controller/fetch/vw.php at line 388
vw_Fetch_Controller->get() in src/addons/vw/vw/_install/lib/upgradepath/steps/4/0/22/base/vw.php at line 1041
vw_Install_UpgradePath_Steps_4022_base_Controller->{closure}() in src/addons/vw/vw/Setup.php at line 299
vw\vw\Setup->vwRunStep() in src/addons/vw/vw/Setup.php at line 954
vw\vw\Setup->upgrade() in src/XF/Admin/Controller/AddOn.php at line 576
XF\Admin\Controller\AddOn->actionUpgrade() 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 2178
XF\App->run() in src/XF.php at line 390
XF::runApp() in admin.php at line 13

August 11, 2019 4:24 PM

pegasus

VaultWiki Team

In src/addons/vw/vw/_core/controller/fetch/index/vw.php, find:

Code:

$index_pages = $caller->get('Page', array(

BEFORE it, add:

Code:

		$prep = vw_DB::get()->query()->prepare(array(
			'p' => array(
				'table' => 'vw_page',
				'alias' => 'page',
				'fields' => array(
					'areaid' => ''
				)
			)
		));

August 11, 2019 4:54 PM

Vilandra

New Member

Success!!

Thank you so much for your continued help with this pegasus!

Reply

+ Reply

All times are GMT -4. The time now is 2:40 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: InvalidArgumentException when upgrading from 4.0.15 to 4.1.0 Beta 2

Issue Tools