Strange Database-Log-entry Strange Database-Log-entry
 

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]

Main Menu

Strange Database-Log-entry

Started by taucher_0815, June 06, 2010, 06:22:25 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

taucher_0815

Hi @ all!

Link to gallery: Http://www.sk-foto.info

After uploading several files via FTP to a subfolder within the albums folder and batch adding these files into an empty gallery folder I get the following entry in the Database-Log:

Quote06. Juni 2010 um 18:13 - While executing query 'INSERT INTO cpg15x_exif (pid, exifData) VALUES (13093, 'a:10:{s:13:\"VerboseOutput\";i:0;s:6:\"Errors\";i:0;s:9:\"ValidJpeg\";i:1;s:13:\"ValidIPTCData\";i:0;s:13:\"ValidJFIFData\";i:1;s:13:\"ValidEXIFData\";i:0;s:13:\"ValidAPP2Data\";i:0;s:12:\"ValidCOMData\";i:1;s:4:\"JFIF\";a:4:{s:4:\"Size\";i:16;s:4:\"Data\";s:14:\"JFIF\0\0\0\0\0\0\";s:10:\"Identifier\";s:5:\"JFIF\0\";s:13:\"ExtensionCode\";s:2:\"01\";}s:3:\"COM\";a:2:{s:4:\"Size\";i:59;s:4:\"Data\";s:57:\"CREATOR: gd-jpeg v1.0 (using IJG JPEG v62), quality = 60
\";}}')' in include/exif_php.inc.php on line 56 the following error was encountered:
Doppelter Eintrag '13093' für Schlüssel 'PRIMARY'

Last sentece translated to English: "Duplicate entry '13093' for key 'PRIMARY'"

Any Ideas?

Joachim Müller

Is the database-column set to auto-increment?

taucher_0815

Good question...

Thats the first time this appeared with 7500+ pictures...


Joachim Müller

Please review using a third-party tool like phpMyAdmin wether that column is set to auto-increment

taucher_0815

I don't thin an autoincrement is needed as there is only the storage of exif-data...

But as far as i can see there are very strange entries in this table...

Quotea:10:{s:13:"VerboseOutput";i:0;s:6:"Errors";i:0;s:9:"ValidJpeg";i:1;s:13:"ValidIPTCData";i:0;s:13:"ValidJFIFData";i:1;s:13:"ValidEXIFData";i:0;s:13:"ValidAPP2Data";i:0;s:12:"ValidCOMData";i:1;s:4:"JFIF";a:4:{s:4:"Size";i:16;s:4:"Data";s:14:"JFIF������";s:10:"Identifier";s:5:"JFIF�";s:13:"ExtensionCode";s:2:"01";}s:3:"COM";a:2:{s:4:"Size";i:59;s:4:"Data";s:57:"CREATOR: gd-jpeg v1.0 (using IJG JPEG v62), quality = 80
";}}

This occurs for only 638 entries but I have more than 7500 images in the gallery and all of them are with complete exif-datas

Joachim Müller

Looks like an encoding issue to me (non-utf-8).

taucher_0815

Data-field ist set to "latin1_german1_ci".

Should I change that to utf8_unicode or utf8_general?

Is there a way to re-read the exifs out of all the images?

Joachim Müller

I doubt that the error will go away if you change the collation of the database alone, as it's only teh default collation. Existing records won't change when changing the collation of the database table. Please zip the image that acts up as it came out of the camera and attach the zip to your posting here.

taucher_0815

Would like to attache the original image but there is a limit of 2000KB... The zipped image is 5.105.791 Byte...

find it here: http://ebay.sk-foto.info/testimage.zip

Please give me a note if you have DL the image, so i can delete it from there

taucher_0815


Joachim Müller

Using Ubuntu Linux 10.04 with Gnome and Gvenview I get "strange" chars in some places of your meta data (see attached screenshot). Please leave the file available, I'd like to check from a Windows-driven machine later.

taucher_0815

I am using PhotoMechanic on a MAC to ingest the IPTC-Data during DL of all images.
The language will be: MAC Romas as Unicode (see screenshot)

taucher_0815


Αndré

Off-topic:

Quote from: Joachim Müller on June 07, 2010, 09:39:29 AM
I doubt that the error will go away if you change the collation of the database alone, as it's only teh default collation. Existing records won't change when changing the collation of the database table.
The collation only affects the sort ordering (read), not how the database stores (write) the data! More information here (German only).

Joachim Müller

Quote from: taucher_0815 on June 07, 2010, 10:04:48 AM
The language will be: MAC Romas as Unicode (see screenshot)
This is probably where the issue lies in (just guessing here though).

taucher_0815

Strange is also that all the IPTC-Data is read OK as you can see on all images in the gallery.

EXIF-Data is not touched at all...

The exif-Table consists only of 600+x entries and not of 7.500+.

Is there a way to re-read all exifs out of the images that exist in the gallery?

Αndré

Afaik the exif data is only read if there is no database record. If you need to refresh exif infos, just delete the appropriate entries in the exif table.

taucher_0815



taucher_0815

strange, but from where does the description come? I did not enter that for several 100 images ;)