Issue: Error while upgrade vaultwiki

Issue Tools
- View Changes

June 18, 2011 7:30 AM

hollosch

Senior Member

Error while upgrade vaultwiki

I want to upgrade to the latest vaultwiki-version

Following error:

Code:

Step 1) Import latest plugins

Importing ces_nwsp_spec-plugins.xml

Parse error: syntax error, unexpected T_STRING in /../forum/vault/install/mysql-insert.php on line 245

Issue Details

Issue Number 2353

Issue Type Bug

Project VaultWiki 3.x Series

Category Install / Upgrade

Status Fixed

Priority 2 - Fatal / Database Errors

Affected Version 3.0.12

Fixed Version 3.0.12

Milestone (none)

Software DependencyAny

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

June 18, 2011 7:40 AM

Mokonzi

Senior Member

There's a fix here, but I came across a further problem after that. Let me know if you get that other error as well... just make sure you backup before following through on my fix, as I need pegasus to confirm it's a real fix.

Reply

June 18, 2011 7:48 AM

hollosch

Senior Member

Yes - the following database-error:

Code:

Datenbankfehler in vBulletin 4.1.4:

Invalid SQL:

			INSERT INTO vb3_setting
				(varname, grouptitle, value, defaultvalue, datatype, optioncode, displayorder,
				advanced, volatile, validationcode, blacklist, product)
			VALUES
			(
				'ces_default_forumid',
				'vault_version',
				'6',
				'2',
				'free',
				'',
				10,
				0,
				1,
				'',
				0,
				'vaultwiki'
			),
	(
				'vault_namespaces',
				'vault_version',
				'a:11:{i:1;a:8:{s:11:\"namespaceid\";s:1:\"1\";s:5:\"title\";s:32:\"a:1:{i:-1;s:13:\"Spezialseiten\";}\";s:12:\"displaytitle\";s:18:\"a:1:{i:-1;s:0:\"\";}\";s:9:\"bbcodetag\";s:7:\"special\";s:7:\"forumid\";s:1:\"0\";s:7:\"options\";s:1:\"3\";s:12:\"displayorder\";s:1:\"0\";s:4:\"path\";s:18:\"a:1:{i:-1;s:0:\"\";}\";}i:2;a:8:{s:11:\"namespaceid\";s:1:\"2\";s:5:\"title\";s:26:\"a:1:{i:-1;s:8:\"Template\";}\";s:12:\"displaytitle\";s:18:\"a:1:{i:-1;s:0:\"\";}\";s:9:\"bbcodetag\";s:8:\"template\";s:7:\"forumid\";s:3:\"266\";s:7:\"options\";s:1:\"0\";s:12:\"displayorder\";s:1:\"0\";s:4:\"path\";s:18:\"a:1:{i:-1;s:0:\"\";}\";}i:3;a:8:{s:11:\"namespaceid\";s:1:\"3\";s:5:\"title\";s:27:\"a:1:{i:-1;s:9:\"HilfeWiki\";}\";s:12:\"displaytitle\";s:18:\"a:1:{i:-1;s:0:\"\";}\";s:9:\"bbcodetag\";s:4:\"help\";s:7:\"forumid\";s:3:\"268\";s:7:\"options\";s:1:\"0\";s:12:\"displayorder\";s:1:\"0\";s:4:\"path\";s:18:\"a:1:{i:-1;s:0:\"\";}\";}i:4;a:8:{s:11:\"namespaceid\";s:1:\"4\";s:5:\"title\";s:24:\"a:1:{i:-1;s:6:\"Header\";}\";s:12:\"displaytitle\";s:18:\"a:1:{i:-1;s:0:\"\";}\";s:9:\"bbcodetag\";s:0:\"\";s:7:\"forumid\";s:3:\"269\";s:7:\"options\";s:1:\"2\";s:12:\"displayorder\";s:1:\"0\";s:4:\"path\";s:18:\"a:1:{i:-1;s:0:\"\";}\";}i:5;a:8:{s:11:\"namespaceid\";s:1:\"5\";s:5:\"title\";s:32:\"a:1:{i:-1;s:13:\"Publikationen\";}\";s:12:\"displaytitle\";s:18:\"a:1:{i:-1;s:0:\"\";}\";s:9:\"bbcodetag\";s:3:\"pub\";s:7:\"forumid\";s:3:\"270\";s:7:\"options\";s:1:\"0\";s:12:\"displayorder\";s:1:\"0\";s:4:\"path\";s:18:\"a:1:{i:-1;s:0:\"\";}\";}i:6;a:8:{s:11:\"namespaceid\";s:1:\"6\";s:5:\"title\";s:32:\"a:1:{i:-1;s:13:\"wollmilchwiki\";}\";s:12:\"displaytitle\";s:32:\"a:1:{i:-1;s:13:\"WollmilchWIKI\";}\";s:9:\"bbcodetag\";s:4:\"wiki\";s:7:\"forumid\";s:3:\"263\";s:7:\"options\";s:1:\"1\";s:12:\"displayorder\";s:1:\"0\";s:4:\"path\";s:18:\"a:1:{i:-1;s:0:\"\";}\";}i:7;a:8:{s:11:\"namespaceid\";s:1:\"7\";s:5:\"title\";s:29:\"a:1:{i:-1;s:10:\"Kategorien\";}\";s:12:\"displaytitle\";s:18:\"a:1:{i:-1;s:0:\"\";}\";s:9:\"bbcodetag\";s:8:\"category\";s:7:\"forumid\";s:3:\"264\";s:7:\"options\";s:1:\"0\";s:12:\"displayorder\";s:1:\"0\";s:4:\"path\";s:18:\"a:1:{i:-1;s:0:\"\";}\";}i:8;a:8:{s:11:\"namespaceid\";s:1:\"8\";s:5:\"title\";s:24:\"a:1:{i:-1;s:6:\"Bilder\";}\";s:12:\"displaytitle\";s:18:\"a:1:{i:-1;s:0:\"\";}\";s:9:\"bbcodetag\";s:5:\"image\";s:7:\"forumid\";s:3:\"265\";s:7:\"options\";s:1:\"0\";s:12:\"displayorder\";s:1:\"0\";s:4:\"path\";s:18:\"a:1:{i:-1;s:0:\"\";}\";}i:10;a:8:{s:11:\"namespaceid\";s:2:\"10\";s:5:\"title\";s:21:\"a:1:{i:-1;s:3:\"POP\";}\";s:12:\"displaytitle\";s:36:\"a:1:{i:-1;s:17:\"Power of Politics\";}\";s:9:\"bbcodetag\";s:3:\"pop\";s:7:\"forumid\";s:3:\"236\";s:7:\"options\";s:1:\"9\";s:12:\"displayorder\";s:2:\"10\";s:4:\"path\";s:18:\"a:1:{i:-1;s:0:\"\";}\";}i:11;a:8:{s:11:\"namespaceid\";s:2:\"11\";s:5:\"title\";s:24:\"a:1:{i:-1;s:6:\"Island\";}\";s:12:\"displaytitle\";s:18:\"a:1:{i:-1;s:0:\"\";}\";s:9:\"bbcodetag\";s:0:\"\";s:7:\"forumid\";s:1:\"0\";s:7:\"options\";s:1:\"2\";s:12:\"displayorder\";s:1:\"0\";s:4:\"path\";s:18:\"a:1:{i:-1;s:0:\"\";}\";}i:14;a:8:{s:11:\"namespaceid\";s:2:\"14\";s:5:\"title\";s:21:\"a:1:{i:-1;s:3:\"FST\";}\";s:12:\"displaytitle\";s:41:\"a:1:{i:-1;s:22:\"Ferienstadt Konzeption\";}\";s:9:\"bbcodetag\";s:3:\"fst\";s:7:\"forumid\";s:3:\"242\";s:7:\"options\";s:1:\"9\";s:12:\"displayorder\";s:2:\"30\";s:4:\"path\";s:18:\"a:1:{i:-1;s:0:\"\";}\";}}',
				'a:2:{i:0;a:2:{s:11:\"namespaceid\";i:0;s:5:\"title\";s:6:\"Island\";}i:1;a:5:{s:11:\"namespaceid\";i:1;s:5:\"title\";s:7:\"Special\";s:9:\"bbcodetag\";s:7:\"special\";s:7:\"options\";i:3;s:12:\"displayorder\";i:60;}}',
				'free',
				'',
				902,
				0,
				1,
				'',
				0,
				'vaultwiki'
			),
	(
				'vault_domains',
				'vault_version',
				'a:0:{}',
				'a:0:{}',
				'free',
				'',
				903,
				0,
				1,
				'',
				0,
				'vaultwiki'
			),
	(
				'vault_replaces',
				'vault_version',
				'a:1:{i:1;a:3:{i:0;a:3:{i:0;s:5:\"&amp;\";i:1;s:5:\" and \";i:2;i:10;}i:1;a:3:{i:0;s:1:\"&\";i:1;s:5:\" and \";i:2;i:20;}i:2;a:3:{i:0;s:1:\"+\";i:1;s:6:\" Plus \";i:2;i:30;}}}',
				'a:1:{i:-1;a:3:{i:0;a:3:{i:0;s:5:\"&amp;\";i:1;s:5:\" and \";i:2;i:10;}i:1;a:3:{i:0;s:1:\"&\";i:1;s:5:\" and \";i:2;i:20;}i:2;a:3:{i:0;s:1:\"+\";i:1;s:6:\" Plus \";i:2;i:30;}}}',
				'free',
				'',
				1019,
				0,
				1,
				'',
				0,
				'vaultwiki'
			),
	(
				'vault_importer',
				'vault_version',
				'0',
				'0',
				'boolean',
				'yesno',
				1029,
				0,
				1,
				'',
				0,
				'vaultwiki'
			),
	(
				'ces_island_forumid',
				'vault_version',
				'11',
				'3',
				'number',
				'',
				1039,
				0,
				1,
				'',
				0,
				'vaultwiki'
			),
	(
				'ces_template_forumid',
				'vault_version',
				'2',
				'0',
				'number',
				'',
				1049,
				0,
				1,
				'',
				0,
				'vaultwiki'
			),
	(
				'ces_header_forumid',
				'vault_version',
				'4',
				'0',
				'number',
				'',
				1059,
				0,
				1,
				'',
				0,
				'vaultwiki'
			),
	(
				'ces_book_forumid',
				'vault_version',
				'5',
				'0',
				'number',
				'',
				1069,
				0,
				1,
				'',
				0,
				'vaultwiki'
			);

MySQL-Fehler  : Duplicate entry 'ces_default_forumid' for key 1
Fehler-Nr.    : 1062
Fehler-Zeit   : Saturday, 18.06.2011 @ 13:46:23
Datum         : Saturday, 18.06.2011 @ 13:46:23
Skript        : /../forum/vault/install/finalupgrade.php?step=2
Referrer      : /../forum/vault/install/finalupgrade.php?step=1
IP-Adresse    : xxx.xxx.xxx.xxx
Benutzername  : hollosch
Klassenname   : vB_Database
MySQL-Version : 5.0.92-1~ui40+1

June 18, 2011 7:57 AM

Mokonzi

Senior Member

So you get exactly the same faults I do. I'm not sure whether my initial fix doesn't go far enough, or whether this is something separate. We need pegasus now...

Reply
June 18, 2011 8:01 AM

hollosch

Senior Member

Yes, we have to wait now...

Reply
June 18, 2011 12:38 PM

pegasus

VaultWiki Team

Ugh, looks like my custom SVN went and merged VaultWiki 3's install folder with VaultWiki 4. I have to unbork this now.

Reply
June 18, 2011 12:46 PM

pegasus

VaultWiki Team

Fixed in the current ZIP.

Reply
June 18, 2011 2:57 PM

Mokonzi

Senior Member

Thanks pegasus. Will try upgrading again later this evening if I get chance

Reply

+ Reply

All times are GMT -4. The time now is 8:23 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: Error while upgrade vaultwiki

Issue Tools