vb.org Archive

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.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

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