zaartix
12-09-2004, 06:39 AM
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?
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?