PhpDig.net

PhpDig.net (http://www.phpdig.net/forum/index.php)
-   How-to Forum (http://www.phpdig.net/forum/forumdisplay.php?f=33)
-   -   bug? upgrade to 1.8.4 (http://www.phpdig.net/forum/showthread.php?t=1591)

zaartix 12-09-2004 06:39 AM

bug? upgrade to 1.8.4
 
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

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)


All times are GMT -8. The time now is 10:09 AM.

Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright © 2001 - 2005, ThinkDing LLC. All Rights Reserved.