Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > Premium Archives > uCash & uShop
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
DB Queries Error Details »»
DB Queries Error
Version: , by ryne661 ryne661 is offline
Developer Last Online: Oct 2006 Show Printable Version Email this Page

Version: Unknown Rating:
Released: 07-17-2005 Last Update: Never Installs: 0
 
No support by the author.

vBulletin Version 3.0.7
uShop & uCash 0.95b
Error happens when it is suppose to do DB queries in install.

Exact error....
Code:
Database error in vBulletin 3.0.7:

Invalid SQL: CREATE TABLE utt_store_action (
  `actionid` int(5) NOT NULL auto_increment,
  `shortname` varchar(255) NOT NULL default '',
  `name` varchar(255) NOT NULL default '',
  `description` text NOT NULL,
  `displayorder` int(10) NOT NULL default '0',
  `cost` varchar(20) NOT NULL default '',
  `tax` varchar(20) NOT NULL default '',
  `sold` bigint(10) NOT NULL default '0',
  `defaultquantity` bigint(10) NOT NULL default '0',
  `quantity` bigint(10) NOT NULL default '0',
  `allowedgroups` varchar(255) NOT NULL default '',
  `deniedgroups` varchar(255) NOT NULL default '',
  `filelocation` varchar(255) NOT NULL default '',
  `imagelocation` varchar(255) NOT NULL default '',
  `showinstore` tinyint(1) NOT NULL default '0',
  `active` tinyint(1) NOT NULL default '0',
  `asvs` TEXT NOT NULL,
  PRIMARY KEY  (`actionid`)
) TYPE=MyISAM AUTO_INCREMENT=18
mysql error: Table 'utt_store_action' already exists

mysql error number: 1050
Alright, I figured out why it is already there, but now how can I bypass the Database step?

Show Your Support

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


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 12:17 PM.


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.08876 seconds
  • Memory Usage 2,191KB
  • Queries Executed 16 (?)
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
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit_onlinestatus
  • (1)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_postinfo_query
  • fetch_postinfo
  • 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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete