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: Read EXIF data causes Critical error  (Read 4063 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.031 seconds with 19 queries.