Advanced search  

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

Pages: [1]   Go Down

Author Topic: Error while processing Database Query-- Upgrading from 1.0 to 1.2.1  (Read 2511 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.026 seconds with 19 queries.