Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: Error while processing Database Query-- Upgrading from 1.0 to 1.2.1  (Read 2505 times)

0 Members and 1 Guest are viewing this topic.

FionaFoo

  • Coppermine newbie
  • Offline Offline
  • Posts: 2

When I go to upgrade-1.0-to-1.2.php I get this error:
There was an error while processing a database query.
Quote
While 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.
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de

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
Logged

FionaFoo

  • Coppermine newbie
  • Offline Offline
  • Posts: 2

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

Casper

  • VIP
  • Coppermine addict
  • ***
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 5231

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

Please do as gaugau asked.
Logged
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
Pages: [1]   Go Up
 

Page created in 0.018 seconds with 19 queries.