Error while processing Database Query-- Upgrading from 1.0 to 1.2.1 Error while processing Database Query-- Upgrading from 1.0 to 1.2.1
 

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Main Menu

Error while processing Database Query-- Upgrading from 1.0 to 1.2.1

Started by FionaFoo, May 02, 2004, 06:51:01 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

FionaFoo

When I go to upgrade-1.0-to-1.2.php I get this error:
There was an error while processing a database query.
QuoteWhile executing query "INSERT INTO cpg_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 0mySQL error: Table 'jannah_photolog.CPG_pictures' doesn't exist
File: /home/jannah/public_html/photolog/new/include/functions.inc.php - Line: 105
Upgrading Coppermine 1.0 tables to 1.1
Prefix used for 1.0 tables : CPG_


What does this mean, and what do I do to rectify this problem? Thank you.

Joachim Müller

please use a tool like phpMyAdmin and check what your pictures table is actually named: does the table 'CPG_pictures' exist in your database?

GauGau

FionaFoo

I didn't change anything when I was fresh-installing. Why would it be named otherwise? Was there an error when I installed?

Casper

because maybe you called it something else when you first installed.

Please do as gaugau asked.
It has been a long time now since I did my little bit here, and have done no coding or any other such stuff since. I'm back to being a noob here