PDA

View Full Version : bug? upgrade to 1.8.4


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?

Charter
12-09-2004, 12:40 PM
This is not a bug. The table was indeed a part of PhpDig 1.8.3. Check the sql directory and look at the update files. The table was added in v.1.8.1 but now for v.1.8.4 the table sites_days_upd is no longer needed, so it is dropped.

mirdin
12-12-2004, 06:52 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?

I have the same issue, how did you fix this? (I posted here http://www.phpdig.net/forum/showthread.php?t=1609)