PDA

View Full Version : SQL error on install


angelicGrace
06-14-2005, 09:27 PM
hack version: .95c
vb version: 3.0.7
errror recieved while running the installer (page 3 or 4 into it to be exact

Error:

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_install.php?do=install&step=dosettings
Referer: http://localhost/forum/admincp/ushop_install.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.

Marco van Herwaarden
06-15-2005, 06:14 AM
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.

angelicGrace
06-15-2005, 01:31 PM
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.

angelicGrace
06-18-2005, 03:50 AM
all figured out now. thanks for those who looked at helping.