Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > Premium Archives > uCash & uShop
SQL error on install Details »»
SQL error on install
Version: , by angelicGrace angelicGrace is offline
Developer Last Online: Mar 2012 Show Printable Version Email this Page

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

hack version: .95c
vb version: 3.0.7
errror recieved while running the installer (page 3 or 4 into it to be exact

Error:
Quote:
Database error in vBulletin 3.0.7:

Invalid SQL: INSERT INTO settinggroup (grouptitle, displayorder, volatile) VALUES ('uttpoints', '1081', '0')
mysql error: Duplicate entry 'uttpoints' for key 1

mysql error number: 1062

Date: Tuesday 14th of June 2005 06:07:32 PM
Script: http://localhost/forum/admincp/ushop...tep=dosettings
Referer: http://localhost/forum/admincp/ushop...php?step=start
Username: angelicGrace
IP Address: ****.****.****.****
Ok I have tried running this installer 3 times. Here is the deal. All three times were on fresh databases on fresh installs of vB (meaning no other hacks or template mods had been made prior to running the installer to add this hack). I am running this on my test board on my pc (mainly cause i don't want to waist the space on my server to do it there).

Has anyone else had this error or can tell me away to fix it?

I refuse to attempt to add this to my live forum until I have had the chance to fully test it on my test forum. Please help my members are very excited and demanding to get the store.

Show Your Support

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

Comments
  #2  
Old 06-15-2005, 06:14 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

This indicates that UCS have been installed before and have not been cleanly uninstalled. The settinggroup uttpoints (which is only used by UCS) already exist.

You could try removing it in debug mode.
Reply With Quote
  #3  
Old 06-15-2005, 01:31 PM
angelicGrace angelicGrace is offline
 
Join Date: Jun 2004
Location: Up in the clouds
Posts: 100
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

But that is the thing it hasn't been installed before. When I say clean I mean clean. The databases were all only moments old when the installer was run. I know I created them, installed vB, then tried to install the store.

All three times were brandnew databases, brandnew installs of vb. At one point i have 4 different databases and 4 different copys of vB running on my pc. 1 of 3.5 beta and 3 of 3.0.7 where I was tring to install the store and kept getting that stupid error.
Reply With Quote
  #4  
Old 06-18-2005, 03:50 AM
angelicGrace angelicGrace is offline
 
Join Date: Jun 2004
Location: Up in the clouds
Posts: 100
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

all figured out now. thanks for those who looked at helping.
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 01:32 PM.


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.07817 seconds
  • Memory Usage 2,220KB
  • Queries Executed 17 (?)
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_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (4)post_thanks_box
  • (4)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (4)post_thanks_postbit_info
  • (3)postbit
  • (4)postbit_onlinestatus
  • (4)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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete