PhpDig.net

Go Back   PhpDig.net > PhpDig Forums > How-to Forum

Reply
 
Thread Tools
Old 12-09-2004, 06:39 AM   #1
zaartix
Orange Mole
 
Join Date: May 2004
Location: russia, samara
Posts: 56
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?
zaartix is offline   Reply With Quote
Old 12-09-2004, 12:40 PM   #2
Charter
Head Mole
 
Charter's Avatar
 
Join Date: May 2003
Posts: 2,539
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.
__________________
Responses are offered on a voluntary if/as time is available basis, no guarantees. Double posting or bumping threads will not get your question answered any faster. No support via PM or email, responses not guaranteed. Thank you for your comprehension.
Charter is offline   Reply With Quote
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
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Upgrade and Update histrenact How-to Forum 2 06-01-2007 03:53 AM
upgrade a 1.8.3 database to 1.8.6 renehaentjens How-to Forum 6 01-06-2005 05:22 PM
New Upgrade CrazyCanuck Script Installation 9 07-26-2004 05:23 PM
Upgrade xiodaos Script Installation 1 07-19-2004 01:01 PM
vB Upgrade Charter Feedback & News 1 09-06-2003 12:20 PM


All times are GMT -8. The time now is 12:56 PM.


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