Support > cpg1.5 miscellaneous
Strange Database-Log-entry
taucher_0815:
Hi @ all!
Link to gallery: http://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:
--- Quote ---06. 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'
--- End quote ---
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...
--- Quote ---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������";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
";}}
--- End quote ---
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
Navigation
[0] Message Index
[#] Next page
Go to full version