PDA

View Full Version : Database error when importing v3arcade addon product


soulface
06-30-2006, 08:52 AM
after updating from vbplaza 1.5.6 to vbplaza 1.5.7 & then importing the v3arcade addon product, am getting this msg (i did uploaded those v3arcade plugins file before)

Database error in vBulletin 3.5.4:

Invalid SQL:

### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO plugin
(`active`, `executionorder`, `title`, `hookname`, `phpcode`, `product`)
VALUES
('1', '5', 'vbBux / vbPlaza - v3 Arcade Game Bit', 'arcade_game_bit', '// include the vbplaza_arcade_gamebit.php\r\ninclude(DIR . \'/plugins/vbplaza_arcade_gamebit.php\');', 'v3arcade_vbplaza');

MySQL Error : Unknown column 'executionorder' in 'field list'
Error Number : 1054
Date : Friday, June 30th 2006 @ 05:48:52 AM
Script : http://www.******.com/admincp/plugin.php
Referrer : http://www.******.com/admincp/plugin.php?do=productadd
IP Address : xxx.xxx.xxx.xxx
Username : Eros
Classname : vb_database

Guest0321
06-30-2006, 05:48 PM
I got the same thing adding the ibproarcade add-on.

I think "executionorder" may be a new column on on the "plugin" table for 3.6?

Greek Wizard
07-01-2006, 08:34 AM
I know this is my first post (new vBulletin user after many many years of phpBB) but I had the same issues as you, but I uninstalled the original addon, edited the xml and re-installed it and it worked perfectly.

Feel free to try this xml and I think you will find it will solve your issues.

I hope it's OK that I posted this.

soulface
07-01-2006, 11:55 AM
thx greek wiz, your xml file imported without any error. btw you removed the executionorder from the product, will it effect on vbplaza for any setting ?

Guest0321
07-01-2006, 01:35 PM
No, I think 'executionorder' is specific to the vb 3.6 and is only used to determine in what order plugins should run.

This revised product XML worked for me, if you have vb 3.5.4 and ibproarcade, uninstall the vbplaza ibproarcade addon, and reinstall the product with this file.

Me2Be
07-07-2006, 01:08 PM
thanks!

Polo
07-10-2006, 11:21 PM
thanks for the fix ;)

mrmike
07-12-2006, 12:43 PM
Thanx for the Fix, Greek Wizard!

CMX_CMGSCCC
07-13-2006, 07:54 PM
Thanx, I will edit these files for the next v1.5.8 release.

-CMX