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: Read EXIF data causes Critical error  (Read 4133 times)

0 Members and 1 Guest are viewing this topic.

tassu

  • Coppermine novice
  • *
  • Country: fi
  • Offline Offline
  • Posts: 27
    • When the light paints
Read EXIF data causes Critical error
« on: September 29, 2012, 01:00:48 am »

When Read EXIF data from JPEG files is on got a this error when clicking thumbnail:

Critical error
There was an error while processing a database query.

Debug: While executing query 'SELECT exifData FROM cpg14x_exif WHERE pid = 775' in include/exif_php.inc.php on line 39

mySQL error: Unknown column 'pid' in 'where clause'

Just updated from 1.4.27 to 1.5.20, and all seems to be all right without this problem.

When I turn off exif read, gallery works ok.
Logged

tassu

  • Coppermine novice
  • *
  • Country: fi
  • Offline Offline
  • Posts: 27
    • When the light paints
Re: Read EXIF data causes Critical error
« Reply #1 on: September 30, 2012, 05:50:14 pm »

I got lot of errors that seems come from same source (cpg14x_exif )? What going on, is my update ok? File Checker says that files are up to date.
Logged

tassu

  • Coppermine novice
  • *
  • Country: fi
  • Offline Offline
  • Posts: 27
    • When the light paints
Re: Read EXIF data causes Critical error
« Reply #2 on: October 01, 2012, 07:25:23 pm »

And Debug contains this row below error:

File: /home/xxxxxxxx/public_html/gallery/include/functions.inc.php - Line: 270
Logged

Jeff Bailey

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 1322
  • Fishing relaxes me.
    • Bailey Family Co.
Re: Read EXIF data causes Critical error
« Reply #3 on: October 01, 2012, 09:05:14 pm »

Please post a link.
http://forum.coppermine-gallery.net/index.php/topic,55415.msg270616.html#msg270616

Have you followed all the steps outlined here:
http://documentation.coppermine-gallery.net/en/upgrading.htm#upgrade_14

Run version check and see if your files transfered correctly.
Logged
Thinking is the hardest work there is, which is probably the reason why so few engage in it. - Henry Ford

tassu

  • Coppermine novice
  • *
  • Country: fi
  • Offline Offline
  • Posts: 27
    • When the light paints
Re: Read EXIF data causes Critical error
« Reply #4 on: October 02, 2012, 04:49:51 pm »

Link:
http://www.photorgasm.com/gallery/

Version check show no errors.

Site working now because of Read Exif is off. When I put it on all image pages ends error. Thumbnail and other pages show ok.

Not debugged errors (these errors occur when read exif data off):
When I try read photo exif data -> Error
Try delete photo -> Error
And many other
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Read EXIF data causes Critical error
« Reply #5 on: October 02, 2012, 05:16:57 pm »

Visit update.php in your browser while logged in as admin.
Logged

tassu

  • Coppermine novice
  • *
  • Country: fi
  • Offline Offline
  • Posts: 27
    • When the light paints
Re: Read EXIF data causes Critical error
« Reply #6 on: October 02, 2012, 08:18:57 pm »

Done. All are "Already Done" state
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Read EXIF data causes Critical error
« Reply #7 on: October 04, 2012, 12:21:16 pm »

Please run http://www.photorgasm.com/gallery/update.php?debug to get some more details about the update process. Search for
Quote
exif CHANGE `filename` `pid` int(11) NOT NULL
and post the message which is displayed directly below that line.
Logged

tassu

  • Coppermine novice
  • *
  • Country: fi
  • Offline Offline
  • Posts: 27
    • When the light paints
Re: Read EXIF data causes Critical error
« Reply #8 on: October 04, 2012, 01:40:45 pm »

Debug output: Rows Affected: 0. MySQL said: Warning (1366) Incorrect integer value: 'albums/activity/2008/yukigassen2008/_MG_5916.jpg' for column 'pid' at row 1 MySQL said: Warning (1366) Incorrect integer value: 'albums/uploads/snow_desert.jpg' for column 'pid' at row 2 MySQL said: Error (1062) Duplicate entry '0' for key 'filename' ALTER TABLE cpg14x_exif DROP INDEX `filename`, ADD PRIMARY KEY ( `pid` )
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Read EXIF data causes Critical error
« Reply #9 on: October 04, 2012, 02:20:21 pm »

So there's still data in that table. What's displayed one line above?
Quote
TRUNCATE TABLE cpg14x_exif
Logged

tassu

  • Coppermine novice
  • *
  • Country: fi
  • Offline Offline
  • Posts: 27
    • When the light paints
Re: Read EXIF data causes Critical error
« Reply #10 on: October 04, 2012, 06:18:24 pm »

Debug output:
Rows Affected: 0.
TRUNCATE TABLE cpg14x_exif
Logged

tassu

  • Coppermine novice
  • *
  • Country: fi
  • Offline Offline
  • Posts: 27
    • When the light paints
Re: Read EXIF data causes Critical error
« Reply #11 on: October 04, 2012, 06:47:36 pm »

Ok. There were a problem with DB privileges. I Changed them. Now working! Hope ;)
Logged
Pages: [1]   Go Up
 

Page created in 0.024 seconds with 20 queries.