mysql error number: 1062

hiskitten · June 3rd, 2005, 06:30 PM

I have RC3 installed but and trying to upgrade to Gold. I have followed all of the PHP file steps and am running vB 3.0.7.

When I try to upgrade via the ACP:

Quote:

Database error in vBulletin 3.0.7:

Invalid SQL: INSERT INTO datastore (title) VALUES ('gallery_ugroups')
mysql error: Duplicate entry 'gallery_ugroups' for key 1

mysql error number: 1062

Date: Friday 03rd of June 2005 07:27:39 PM
Script: http://www.thegrimescene.com/forums/...ry_install.php
Referer: http://www.thegrimescene.com/forums/...ry_install.php
Username: xx
IP Address: x

June 3rd, 2005, 07:10 PM

Did you refresh the page or anything? There's not any way you would get that error unless you did, or you had RC4 installed and manually changed... What version number shows in your footer?

mholtum · June 3rd, 2005, 07:30 PM

Powered by vBadvanced Gallery v1.0 RC3

hiskitten · June 3rd, 2005, 07:33 PM

The first page loaded, then it timed out so I restarted and am now receiving this error msg.

June 3rd, 2005, 07:43 PM

If you'd like to just submit a support ticket I'll be glad to take a look and make sure we get you upgraded.

corriewf · June 3rd, 2005, 08:25 PM

Same problem but there was no time out. Support ticket submitted.

Reefland · June 3rd, 2005, 08:26 PM

Yup same problem here, support ticket submitted.

corriewf · June 3rd, 2005, 08:27 PM

Well I feel better that I didnt screw something up.... I feel bad for Brian but I am sure its something simple.

Reefland · June 3rd, 2005, 08:39 PM

I hope it's something simple.

June 3rd, 2005, 09:08 PM

For anyone else that's having this problem (and hasn't submitted a ticket yet), just run this query through phpMyAdmin or in your Admin CP:

UPDATE adv_setting SET value = '1.0 RC4' WHERE varname = 'gallery_version'

Then go back to the install script in your browser, select the option to upgrade again, and that should allow it to finish the upgrade. The install script has also been updated on here so that others won't have this problem when they first try to upgrade.

corriewf · June 3rd, 2005, 09:17 PM

Your a gallery pimp Brian... Good Job.

June 3rd, 2005, 09:21 PM

If I was really a pimp then I wouldn't have had that break; statement in there in the first place telling it to stop once it got done making the changes from RC3.

corriewf · June 3rd, 2005, 10:46 PM

Quote:

Originally Posted by Brian

If I was really a pimp then I wouldn't have had that break; statement in there in the first place telling it to stop once it got done making the changes from RC3.

The code seen a pimp coming through and said whoa lets let the man come on through.

Thanks for the prompt response. The exact reason why I always tell everyone your gallery is the best. Hard to put a price on customer service and yours cant be beat.