coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 upgrading => Topic started by: mardyhardy on November 08, 2006, 10:50:39 AM

Title: Error in update script? 1.4.0 -> 1.4.10
Post by: mardyhardy on November 08, 2006, 10:50:39 AM
I receive the following error:
While executing query "INSERT INTO cpg140_pictures (approved, pid, aid, caption, filepath, filename, filesize, pwidth, pheight, hits, mtime, ctime) SELECT 'yes' as approved, p.pid, aid, msg_body AS caption, filepath, filename, filesize, pwidth, pheight, hits, mtime, UNIX_TIMESTAMP(ctime)FROM CPG_pictures AS p LEFT JOIN CPG_comments AS c ON p.caption = c.msg_id " on 0

mySQL error: Table 'tovodb.CPG_pictures' doesn't exist


The table should be cpg140_pictures
Title: Re: Error in update script? 1.4.0 -> 1.4.10
Post by: Nibbler on November 08, 2006, 01:22:04 PM
Why are you running upgrade-1.0-to-1.2.php ?
Title: Re: Error in update script? 1.4.0 -> 1.4.10
Post by: mardyhardy on November 08, 2006, 11:48:07 PM
No I didn't. Downloaded the 1.4.10 files and tried to run update.php
After some other weird screens, I ended up with this error
Title: Re: Error in update script? 1.4.0 -> 1.4.10
Post by: Nibbler on November 09, 2006, 01:05:27 AM
The only place in Coppermine that code appears is in the file upgrade-1.0-to-1.2.php. I would suggest downloading a fresh version of the package and re uploading to your web server if you are sure you are not running that file.