View Single Post
Old October 17th, 2005, 12:49 PM   #7 (permalink)
DefenceTalk.com
Member
Verified Customer
 
Join Date: Feb 2005
Posts: 387
I ran the upgrade script as well and got this:

Quote:
Preparing to update database...
Error performing MySQL command: CREATE TABLE pics_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 'pics_cache' already exists

Error performing MySQL command: INSERT INTO pics_cache VALUES (1,0,null,null,null,null,null,null,null)
Error: Can't open file: 'pics_cache.MYI'. (errno: 145)

Error performing MySQL command: INSERT INTO pics_settings VALUES (211,'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 '211' for key 1

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


Upgrade complete! You may now remove the upgrade.php script
.
DefenceTalk.com is offline   Reply With Quote