PhpDig.net

Go Back   PhpDig.net > PhpDig Forums > Script Installation

Reply
 
Thread Tools
Old 07-17-2004, 05:52 AM   #1
CrazyCanuck
Green Mole
 
Join Date: Apr 2004
Location: Canada
Posts: 6
New Upgrade

1.8.0 to 1.8.3

My first time upgrading.
I copied all the new files over, now it seems like whatever I do I get an html error page with a few different warnings including Tables click missing. It seems like all the arguements in the update_to_181.sql.

How do I update the database?
CrazyCanuck is offline   Reply With Quote
Old 07-17-2004, 06:07 AM   #2
vinyl-junkie
Purple Mole
 
Join Date: Jan 2004
Posts: 694
When all else fails, read the directions. No, I'm not making fun of you. I ran into the same thing myself until I read the installation instructions and found out there are new tables for this version.

Run the sql code in update_db_to_1_8_1.sql and update_db_to_1_8_2.sql to create those tables, and you shouldn't have any other problems.
vinyl-junkie is offline   Reply With Quote
Old 07-17-2004, 06:56 AM   #3
ibrown
Green Mole
 
ibrown's Avatar
 
Join Date: Mar 2004
Location: London
Posts: 10
Quote:
Originally posted by vinyl-junkie
When all else fails, read the directions. No, I'm not making fun of you. I ran into the same thing myself until I read the installation instructions and found out there are new tables for this version.

Run the sql code in update_db_to_1_8_1.sql and update_db_to_1_8_2.sql to create those tables, and you shouldn't have any other problems.


Aha! That is not in the installation instructions! I tried to upgrade from 1.8.0 to 1.8.3 but ran into major problems. Luckily I had a backup of my 1.8.0 files and was able to reinstall them over the 1.8.3 files and get my search engine working again.

I will have to look at what the benefits of upgrading to 1.8.3 are now, before I try any more.
ibrown is offline   Reply With Quote
Old 07-17-2004, 07:11 AM   #4
Charter
Head Mole
 
Charter's Avatar
 
Join Date: May 2003
Posts: 2,539
>> Aha! That is not in the installation instructions!

http://www.phpdig.net/navigation.php?action=doc#toc6
__________________
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 07-17-2004, 07:29 AM   #5
vinyl-junkie
Purple Mole
 
Join Date: Jan 2004
Posts: 694
This does point up the need for a better error message, I think. I reinstalled phpdig (with my original database still intact) and made some code customizations at the same time, so it was hard to distinguish between custom code errors and something that I should have had in place for a straight install/upgrade.

Not a big deal, but just a suggestion for something to include in the next release.
vinyl-junkie is offline   Reply With Quote
Old 07-17-2004, 07:30 AM   #6
ibrown
Green Mole
 
ibrown's Avatar
 
Join Date: Mar 2004
Location: London
Posts: 10
Quote:
Originally posted by Charter
>> Aha! That is not in the installation instructions!

http://www.phpdig.net/navigation.php?action=doc#toc6
Not quite as explicit as vinyl-junkie's instructions: "Run the sql code in update_db_to_1_8_1.sql and update_db_to_1_8_2.sql to create those tables"

I was also looking for an 'UPGRADE' instruction file in the .zip. Perhaps one could be inserted to save my forehead? And/or include a note in the 'Quick Installation Directions' to "See below for upgrading instructions" This would save a lot of hassle and headaches and blue language.
ibrown is offline   Reply With Quote
Old 07-17-2004, 07:32 AM   #7
vinyl-junkie
Purple Mole
 
Join Date: Jan 2004
Posts: 694
Quote:
Originally posted by ibrown
I will have to look at what the benefits of upgrading to 1.8.3 are now, before I try any more.
There is a changelog file which details the differences between the versions. I think you might want to upgrade. For one thing, the authorization security has been beefed up.
vinyl-junkie is offline   Reply With Quote
Old 07-26-2004, 05:01 PM   #8
Wayne McBryde
Orange Mole
 
Join Date: Oct 2003
Location: NC, USA
Posts: 34
Question

Umm I read the install instructions, but I know very little about running commands.

From a shell prompt i ran:
mysql update_db_to_1_8_2.sql

And get "Incorrect Database Name"

What am I doing wrong.

Thanks
Wayne McBryde
Wayne McBryde is offline   Reply With Quote
Old 07-26-2004, 05:16 PM   #9
vinyl-junkie
Purple Mole
 
Join Date: Jan 2004
Posts: 694
You need to run that from phpMyAdmin. Select your phpdig database. Then click on the SQL link, browse for the file name update_db_to_1_8_2.sql and click Open, then click Go to create the new tables.

Hope this helps.
vinyl-junkie is offline   Reply With Quote
Old 07-26-2004, 05:23 PM   #10
Wayne McBryde
Orange Mole
 
Join Date: Oct 2003
Location: NC, USA
Posts: 34
Shazam I have 8 tables now not 7 like befor. Thanks
__________________
Wayne Mcbryde
http://LakeNormansWeb.com
We search all of Lake Norman!
Wayne McBryde is offline   Reply With Quote
Reply


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
bug? upgrade to 1.8.4 zaartix How-to Forum 2 12-12-2004 06:52 AM
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 09:34 PM.


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