vb.org Archive - Database error when importing v3arcade addon product

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vbBux / vbPlaza (https://vborg.vbsupport.ru/forumdisplay.php?f=171)

- - Database error when importing v3arcade addon product (https://vborg.vbsupport.ru/showthread.php?t=119966)

soulface

06-30-2006 08:52 AM

Database error when importing v3arcade addon product

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)

Code:

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

1 Attachment(s)

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

1 Attachment(s)

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

All times are GMT. The time now is 01:08 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01040 seconds Memory Usage 1,720KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (9)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: