database errors during upgrade
 

This morning I attempted to upgrade my reviewpost from Version 3.01 to 4.2

On the upgrade screen I selected :

3.0 -> 3.1 Upgrade from ReviewPost 3.0X -> 3.1

and then got these errors during the first step.

Ideas?

The bottom of the screen says to continue - should I really continue?

------------------------------

Preparing to update database...

Error performing MySQL command: CREATE TABLE cache (id tinyint(1) NOT NULL default '1', timestamp int(15) NOT NULL default '0', statscache mediumtext, recentcache mediumtext, popularcache mediumtext, randomcache mediumtext, calcache mediumtext, catcache mediumtext, catprops mediumtext, PRIMARY KEY (id), KEY id (id)) TYPE=MyISAM
Error: Table 'cache' already exists

Error performing MySQL command: INSERT INTO cache VALUES (1,'',null,null,null,null,null,null,null)
Error: Duplicate entry '1' for key 1

Error performing MySQL command: INSERT INTO settings VALUES (239,'Minutes to cache index page data for featured photos, statistics and PALs?','cachetimeout','Number of minutes to cache information. Default is 10 minutes, 0 means no caching.','10',36,1)
Error: Duplicate entry '239' for key 1

Error performing MySQL command: INSERT INTO settings VALUES (240,'Show Calendar PAL?','calpal','Do you want to display the calendar pal, yes or no.','yes',16,11)
Error: Duplicate entry '240' for key 1

Error performing MySQL command: INSERT INTO settings VALUES (241, 'Use Whos Online PAL?', 'onlinepal', '', 'yes', 17, 11)
Error: Duplicate entry '241' for key 1


Done! You should continue to next step

chuck - just noticed something wierd...

even though the config file I have on my existing version says: 3.01

the database field in the settings table says 3.1

was there some oversight back in the 3.01/3.1 that would have gotten the two fields out of synch?

ok - based on what I found out I reloaded everything and restored the db to it's original state and tried to 3.1 to 3.2 upgrade...

and I received on error at the bottom of the screen -

should I continue?

Preparing to update 3.11 database...

Performing MySQL command: REPLACE INTO settings VALUES (84,'ReviewPost Version','pversion','','3.2',53,0); ... Successful!
Performing MySQL command: REPLACE INTO settings VALUES (37,'cright','cright','','Powered by: ReviewPost --replaceme--
Copyright 2006 All Enthusiast, Inc.',300,'0') ... Successful!
Performing MySQL command: INSERT INTO settings VALUES (242,'Do you want to enable the Announcement box?','news', '', 'no', 12, 3) ... Successful!
Performing MySQL command: INSERT INTO settings VALUES (243,'Title for the Announcement box?','newstitle', '', 'News', 13, 3) ... Successful!
Performing MySQL command: INSERT INTO settings VALUES (244,'Contents of the Announcement box?','newscopy', 'This block can contain HTML code (200 character limit)', '', 14, 3) ... Successful!
Performing MySQL command: INSERT INTO settings VALUES (245,'Use category cache?','catcache','On some larger sites, using the category cache can actually reduce performance.','no',36,1) ... Successful!
Performing MySQL command: INSERT INTO settings VALUES (246,'Display Featured Ads on this page?','features','On larger sites this option can slow down the showcat page. Turn off to speed up this page.','yes',8,5) ... Successful!
Performing MySQL command: INSERT INTO settings VALUES (247,'Display Admin quick move/delete options under ad?','quickopts','On larger sites this option can slow down the showproduct page. Turn off to speed up this page.','yes',8,5) ... Successful!
Performing MySQL command: INSERT INTO settings VALUES (248,'Load limit for server?','loadlimit','If running *nix and you want to disable your forums when load goes over a certain limit; place the high limit here.','0',35,1) ... Successful!
Performing MySQL command: ALTER TABLE categories ADD intro VARCHAR(3) default 'no' NOT NULL, ADD introtitle VARCHAR(128) DEFAULT NULL, ADD introcopy TEXT DEFAULT NULL, ADD theme VARCHAR(32) NOT NULL, ADD sortorder INT(2) DEFAULT '1' NOT NULL, ADD frames VARCHAR(32) NULL ... Successful!
Performing MySQL command: REPLACE INTO settings VALUES (206,'Show Last Product column on Index?','showlast','','yes',17,3) ... Successful!
Performing MySQL command: REPLACE INTO settings VALUES (79,'Show Most Popular products on Index page?','dispopular','','no',5,3) ... Successful!
Performing MySQL command: REPLACE INTO settings VALUES (224, 'setting224', 'ppboards', 'open', 20, 1); ... Error: Column count doesn't match value count at row 1

you get duplicate mysql messages because you have already ran the upgrade so thats not an issue.

Now your config file is not going to be updated until you actually edit it in admin and save ;)

So what is your actual error here besides you seem to have ran upgrades already?