View Single Post
Old 12-12-2004, 06:52 AM   #3
mirdin
Green Mole
 
Join Date: Apr 2004
Posts: 14
Quote:
Originally Posted by zaartix
i try to update 1.8.3 to 1.8.4 and after mysql udpating script show only errors.

this is content of update_db_to_1_8_4.sql

# Update from the 1.8.3 version
# Add the table prefix if needed
# ---------------------------------
ALTER TABLE sites ADD COLUMN stopped TINYINT(1) NOT NULL DEFAULT 0;
ALTER TABLE site_page ADD COLUMN days INT(4) NOT NULL DEFAULT 0;
ALTER TABLE site_page ADD COLUMN depth INT(4) NOT NULL DEFAULT 5;
ALTER TABLE site_page CHANGE num_page links INT(4) NOT NULL DEFAULT 5;
DROP TABLE sites_days_upd;

so, last string droping table sites_days_upd and script can't find it, that's error. Is this table really doesnt needed?
I have the same issue, how did you fix this? (I posted here http://www.phpdig.net/forum/showthread.php?t=1609)
mirdin is offline   Reply With Quote