Error in update script? 1.4.0 -> 1.4.10 Error in update script? 1.4.0 -> 1.4.10
 

News:

CPG Release 1.6.27
change DB IP storage fields to accommodate IPv6 addresses
remove use of E_STRICT (PHP 8.4 deprecated)
update README to reflect new website
align code with new .com CPG website
correct deprecation in captcha

Main Menu

Error in update script? 1.4.0 -> 1.4.10

Started by mardyhardy, November 08, 2006, 10:50:39 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

mardyhardy

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

Nibbler

Why are you running upgrade-1.0-to-1.2.php ?

mardyhardy

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

Nibbler

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.