This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.
The active forums are here.
January 17, 2011 10:11am
Subscribe [4]#1 / Jan 17, 2011 10:11am
Hi,
I am trying to do a upgrade from 1.7.0 to 2.1.3, but walking against some troubles. I am getting this error message while converting.
Error Number: 1068
\n\n
Multiple primary key defined
\n\n
ALTER TABLE `exp_forum_read_topics` ADD PRIMARY KEY `member_id_board_id` (`member_id`, `board_id`)
Anyone has a clue how to fix this in PHPMyAdmin?
Regards,
Steve
#2 / Jan 17, 2011 4:14pm
Can you confirm the value of $conf[‘app_version’] in your /system/config.php file prior to starting the upgrade?
#3 / Jan 17, 2011 4:18pm
$conf[‘app_version’] = “170”;
#4 / Jan 18, 2011 3:52am
steve-o-lution,
What version of the forum did you have installed?
have a look in the exp_modules table and you can find the version there quickly
#5 / Jan 18, 2011 4:57am
2.2.0
Downloaded it last Friday from EE Download Center.
#6 / Jan 18, 2011 8:00pm
Hi, Steve. Had you attempting to upgrade earlier?
If you DESC exp_forum_read_topics, which fields do you have in there?
#7 / Jan 19, 2011 4:04am
Not with this database. Everytime i try to convert i upload a clean backup of the 170 database.
These are the fields i have:
member_id, board_id, topics and last_visit,
#8 / Jan 19, 2011 5:23pm
2.2.0
Downloaded it last Friday from EE Download Center.
That’s the EE 1.x compatible version. You have uploaded the Forum 3.1.2 files, correct?
#9 / Jan 20, 2011 10:57am
Yes, with the new one the files are from 3.2.1.
#10 / Jan 20, 2011 5:38pm
When you are restoring the database tables, are you dropping all the tables first, and then putting back in the 1.7.0 database?
#11 / Jan 21, 2011 12:02pm
Yes, everything is cleaned and dropped before putting back the database. Also tried with 1.6.8 database. Same problem.
It’s a very large database +/- 350MB. So everytime trying to do a succesfull convert takes a long time. Is there maybe a freelance expert here that could try it for us?
#12 / Jan 22, 2011 10:27am
If it’s a very large database, that may be part of the problem. Have you considered downloading the database and converting on a local install, then uploading the db back again? You might want to contact someone from the Pro Network to help out. Have you also considered things like removing bogus members, spam comments, older entries, that sort of thing?