Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > Premium Archives > vbBux / vbPlaza
Database error when importing v3arcade addon product Details »»
Database error when importing v3arcade addon product
Version: , by soulface soulface is offline
Developer Last Online: Dec 2019 Show Printable Version Email this Page

Version: Unknown Rating:
Released: 06-30-2006 Last Update: Never Installs: 0
 
No support by the author.

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

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #2  
Old 06-30-2006, 05:48 PM
Guest0321
Guest
 
Posts: n/a
Default

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?
Reply With Quote
  #3  
Old 07-01-2006, 08:34 AM
Greek Wizard Greek Wizard is offline
 
Join Date: Jun 2006
Posts: 94
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Attached Files
File Type: (21.4 KB, 23 views)
Reply With Quote
  #4  
Old 07-01-2006, 11:55 AM
soulface's Avatar
soulface soulface is offline
 
Join Date: Sep 2005
Location: Dhaka, BD
Posts: 183
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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 ?
Reply With Quote
  #5  
Old 07-01-2006, 01:35 PM
Guest0321
Guest
 
Posts: n/a
Default

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.
Attached Files
File Type: (21.4 KB, 13 views)
Reply With Quote
  #6  
Old 07-07-2006, 01:08 PM
Me2Be's Avatar
Me2Be Me2Be is offline
 
Join Date: Oct 2001
Posts: 88
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

thanks!
Reply With Quote
  #7  
Old 07-10-2006, 11:21 PM
Polo's Avatar
Polo Polo is offline
 
Join Date: Jun 2004
Posts: 893
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

thanks for the fix
Reply With Quote
  #8  
Old 07-12-2006, 12:43 PM
mrmike mrmike is offline
 
Join Date: May 2006
Location: Sweden
Posts: 54
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thanx for the Fix, Greek Wizard!
Reply With Quote
  #9  
Old 07-13-2006, 07:54 PM
CMX_CMGSCCC CMX_CMGSCCC is offline
 
Join Date: Sep 2003
Posts: 1,218
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thanx, I will edit these files for the next v1.5.8 release.

-CMX
Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 02:20 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04530 seconds
  • Memory Usage 2,283KB
  • Queries Executed 23 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)bbcode_code
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (9)post_thanks_box
  • (9)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (9)post_thanks_postbit_info
  • (8)postbit
  • (2)postbit_attachment
  • (7)postbit_onlinestatus
  • (9)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • postbit_attachment
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete