Thread: Major Additions - microCART: Shopping System for vB4
View Single Post
  #578  
Old 07-15-2011, 11:44 PM
RcHelp RcHelp is offline
 
Join Date: Apr 2011
Posts: 27
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I have deleted the mysql tables, I have deleted every file and uninstalled the microcart, but I still get these same errors. I have done everythign you have said to do in this entire thread, and nothing is working. Hope you can help out here.

Code:
Database error in vBulletin 4.1.4:

Invalid SQL:
INSERT INTO `microcart_product_types` SET id='1', name='Downloadable', shipping='0', downloads='1';

MySQL Error   : Duplicate entry '1' for key 1
Error Number  : 1062
Request Date  : Friday, July 15th 2011 @ 04:57:22 PM
Error Date    : Friday, July 15th 2011 @ 04:57:22 PM
Script        : http://rc-help.com/admincp/plugin.php?do=productimport
Referrer      : http://rc-help.com/admincp/plugin.php?do=productadd
IP Address    : 
Username      : Tony
Classname     : vB_Database
MySQL Version : 5.0.91
This is the first code that I get after I dump the tables. If I try to install after I get this code, I get the code above. We have traced it to the usergroup table, but don't know if we can delete the microcart in there or not. Any help would be great.

Code:
Database error in vBulletin 4.1.4:

Invalid SQL:
ALTER TABLE usergroup ADD microcart INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL;

MySQL Error   : Duplicate column name 'microcart'
Error Number  : 1060
Request Date  : Friday, July 15th 2011 @ 06:14:15 PM
Error Date    : Friday, July 15th 2011 @ 06:14:15 PM
Script        : http://rc-help.com/admincp/plugin.php?do=productimport
Referrer      : http://rc-help.com/admincp/plugin.php?do=productadd
IP Address    : 
Username      : Tony
Classname     : vB_Database
MySQL Version : 5.0.91
Sorry about all the posts, but after backing up my database, and going on a deleting party, I deleted everything that said "microcart" and "mh_******" in the database, usergroup and user tables. After I did all of that, it finally installed. I'm going to give this a try, and if it works the way I think it will, then I will order the commercial version to support the coder. And I have to say, it's well worth what they are wanting for it.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01126 seconds
  • Memory Usage 1,768KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)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
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • 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
  • showpost_complete