New Upgrade

CrazyCanuck · 07-17-2004, 06:52 AM

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?

vinyl-junkie · 07-17-2004, 07:07 AM

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.

ibrown · 07-17-2004, 07:56 AM

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.

Charter · 07-17-2004, 08:11 AM

>> Aha! That is not in the installation instructions!

http://www.phpdig.net/navigation.php?action=doc#toc6

vinyl-junkie · 07-17-2004, 08:29 AM

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.

ibrown · 07-17-2004, 08:30 AM

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.

vinyl-junkie · 07-17-2004, 08:32 AM

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.

Wayne McBryde · 07-26-2004, 06:01 PM

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

vinyl-junkie · 07-26-2004, 06:16 PM

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.

Wayne McBryde · 07-26-2004, 06:23 PM

Shazam I have 8 tables now not 7 like befor. Thanks

07-17-2004, 06: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?

07-17-2004, 08:11 AM	#4
Charter Head Mole 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.

07-26-2004, 06: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!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Upgrade and Update	histrenact	How-to Forum	2	06-01-2007 04:53 AM
upgrade a 1.8.3 database to 1.8.6	renehaentjens	How-to Forum	6	01-06-2005 06:22 PM
bug? upgrade to 1.8.4	zaartix	How-to Forum	2	12-12-2004 07:52 AM
Upgrade	xiodaos	Script Installation	1	07-19-2004 02:01 PM
vB Upgrade	Charter	Feedback & News	1	09-06-2003 01:20 PM

07-17-2004, 07: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.

07-17-2004, 08: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.

07-26-2004, 06:01 PM	#8
Wayne McBryde Orange Mole Join Date: Oct 2003 Location: NC, USA Posts: 34	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

07-26-2004, 06: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.