coppermine-gallery.com/forum

Support => Older/other versions => cpg1.2 PHPnuke/Postnuke Support => Topic started by: cookie-monster on June 28, 2005, 02:39:03 AM

Title: Database error after upgrade from 1.1 -> 1.3
Post by: cookie-monster on June 28, 2005, 02:39:03 AM
After reading the instructions i updated my standalone version from 1.1 to 1.3

did the install etc (cant remember wot happened then) but now i keep getting the following error
While executing query "SELECT cid, catname, description FROM cpg_categories WHERE parent = ''  ORDER BY pos" on 0

mySQL error: Unknown column 'catname' in 'field list'


File: modules/coppermine/include/functions.inc.php - Line: 101

Ive tried searching the forums with no luck. I also have a full backup of the old one but im hoping its some stupid mistake that is easily corrected.

If you need anymore info let me know

Thanx in advance
Title: Re: Database error after upgrade from 1.1 -> 1.3
Post by: kegobeer on June 28, 2005, 03:00:15 AM
QuoteFile: modules/coppermine/include/functions.inc.php - Line: 101

Standalone?  Isn't that a nuke location?

Did you follow the upgrade instructions completely for 1.1?

Quote3.2 Upgrading from releases of version 1.1
First, make a backup (dump) of your database.
Backup your include/config.inc.php file, your anycontent.php file and your "albums" directoy.
Unpack the archive
If the file install.php exists in the root directory, delete it.
Upload all of the new files and directories
CHMOD the albums directory and all subfolders once more to 755 or 777 (depending on your server config)
Call the upgrade script http://yousitename/coppermine_dir/update.php
Your upgrade should be complete.

Did you upload all of the Coppermine 1.3.3 files to your site?  Run the update.php script?
Title: Re: Database error after upgrade from 1.1 -> 1.3
Post by: cookie-monster on June 28, 2005, 06:17:40 PM
hmmmm have i downloaded the wrong version of it ?
           In that case which one should i DL

Or have i just misworded it.
Title: Re: Database error after upgrade from 1.1 -> 1.3
Post by: kegobeer on June 28, 2005, 07:09:28 PM
Did you download Coppermine 1.3.3?
Title: Re: Database error after upgrade from 1.1 -> 1.3
Post by: cookie-monster on June 29, 2005, 06:14:39 PM
yes...
Title: Re: Database error after upgrade from 1.1 -> 1.3
Post by: kegobeer on June 29, 2005, 07:03:14 PM
Did you upload all of the files, verify file permissions, and then run update.php?

Post a link to your site.
Title: Re: Database error after upgrade from 1.1 -> 1.3
Post by: cookie-monster on June 29, 2005, 09:28:35 PM
yes

www.simon-whiteside.co.uk (http://www.simon-whiteside.co.uk)
Title: Re: Database error after upgrade from 1.1 -> 1.3
Post by: kegobeer on June 30, 2005, 12:39:14 AM
You are using the nuke port of Coppermine, so I moved your post to the appropriate board.  You can't upgrade using the standalone version, and there is no support for the nuke port.  Read the stickies on this board.
Title: Re: Database error after upgrade from 1.1 -> 1.3
Post by: cookie-monster on June 30, 2005, 08:37:39 PM
Damn. sorry about that...