PDA

View Full Version : Installation Problem with MySQL database


kreichelt
26 Dec 2009, 13:55
I am getting an error in Step 3 of the upgrade script (from 3.8.4). I am sure there's something wrong with my database, which I created by exporting my MySQL 4.0 database and then importing it into 4.1. I am using GoDaddy, and have tried a number of ways to do the export/import -- backing up the database and restoring it, exporting it and then importing it into a new database set up in 4.1... Not sure what settings I need to use in this export/import process to get this working properly. Anyone know?

Here's my error message:

Database error in vBulletin 3.8.4:

Invalid SQL:
INSERT INTO tagcontent
(tagid, contenttypeid, contentid, userid, dateline)
SELECT tagid, 2, threadid, userid, dateline
FROM tagthread;

MySQL Error : Duplicate entry '1-2-175' for key 1
Error Number : 1062
Request Date : Saturday, December 26th 2009 @ 07:36:23 AM
Error Date : Saturday, December 26th 2009 @ 07:36:24 AM
Script : http://www.waylandenews.com/forum/install/upgrade_400a1.php?step=3
Referrer : http://www.waylandenews.com/forum/install/upgrade_400a1.php?step=2
IP Address : 72.93.248.212
Username :
Classname : vB_Database
MySQL Version : 4.1.22-max-log

Lynne
26 Dec 2009, 17:01
Have you tried running repair/optimize on your tagcontent table?