Exif data is missing

[silfver]

Since my database crash I've had some troubles with pixelpost. I've fixed most of it now, but still, the exif info isn't showing.

I updated the exif in the addons page and got this message: "Updated exif from 276 images." So I guess that's OK.

But there's no exif showing on the content page. I guess that I am missing a table in the database perhaps? But it's weird that the exif update worked.

I have these tables:
pixelpost_addons
pixelpost_ban
pixelpost_banlist
pixelpost_catassoc
pixelpost_categories
pixelpost_comments
pixelpost_config
pixelpost_ping
pixelpost_pixelpost
pixelpost_stats
pixelpost_tags
pixelpost_version
pixelpost_visitors

Is there any missing? What should I do? You haven't changed the exif-tags, have you? :)

[austriaka]

Have a look into the pixelpost_pixelpost table, there should be a table field called "exif_info". See if the images have some crowdy information in there.
Could it be that you made an update of PP from 1.5 to 1.6 when fixing the database crash?
Try to run the install.php again, this should create the missing tables for you and leave the content untouched (but better make a database backup before).

I suppose you used the correct EXIF tags in the image template?

KArin

[silfver]

Have a look into the pixelpost_pixelpost table, there should be a table field called "exif_info". See if the images have some crowdy information in there.
Could it be that you made an update of PP from 1.5 to 1.6 when fixing the database crash?
Try to run the install.php again, this should create the missing tables for you and leave the content untouched (but better make a database backup before).

I suppose you used the correct EXIF tags in the image template?

KArinYes, there was a lot of info in that table. And I've tried to run the installation again, but it just says: Warning: Cannot modify header information - headers already sent by (output started at /includes/create_tables.php:6) in/admin/install.php on line 17I use these tags: <li><LANG_CAPTURE_DATE></li>
<li><LANG_CAMERA_MODEL></li>
<li><LANG_EXPOSURE_TIME></li>
<li><LANG_APERTURE></li>
<li><LANG_FOCAL_LENGTH></li>
<li><LANG_ISO></li>

[Dennis]

Install won't help. Install will only run if the versionnumber in the database is lower then the version of the files.

Are you familiar with PHPMyAdmin? Could you check in the table pixelpost_pixelpost if there are values in the exif field for each image?

Or send me an image so I can test.

[silfver]

Install won't help. Are you familiar with PHPMyAdmin?Yes. :)

[Dennis]

Ow, I updated my post...

[silfver]

This is what's found under the exif info of my latest image: a:56:{s:13:"VerboseOutput";s:1:"0";s:6:"Errors";s:1:"0";s:9:"ValidJpeg";s:1:"1";s:13:"ValidIPTCData";s:1:"0";s:13:"ValidJFIFData";s:1:"0";s:13:"ValidEXIFData";s:1:"1";s:13:"ValidAPP2Data";s:1:"0";s:12:"ValidCOMData";s:1:"0";s:8:"APP1Size";s:4:"5260";s:6:"Endien";s:5:"Intel";s:11:"IFD0NumTags";s:2:"11";s:8:"MakeIFD0";s:5:"Canon";s:9:"ModelIFD0";s:13:"Canon EOS 20D";s:15:"OrientationIFD0";s:14:"Normal (O deg)";s:15:"xResolutionIFD0";s:2:"72";s:15:"yResolutionIFD0";s:2:"72";s:18:"ResolutionUnitIFD0";s:4:"Inch";s:12:"SoftwareIFD0";s:29:"Adobe Photoshop CS3 Macintosh";s:12:"DateTimeIFD0";s:19:"2007:05:06 11:13:47";s:10:"ArtistIFD0";s:14:"Daniel Silfver";s:18:"TimeZoneOffsetIFD0";s:5:"65538";s:14:"ExifOffsetIFD0";s:3:"248";s:10:"IFD1Offset";s:3:"656";s:13:"SubIFDNumTags";s:2:"24";s:18:"ExposureTimeSubIFD";s:9:"1/250 sec";s:13:"FNumberSubIFD";s:5:"f 3.5";s:21:"ExposureProgramSubIFD";s:7:"Program";s:21:"ISOSpeedRatingsSubIFD";s:3:"100";s:17:"ExifVersionSubIFD";s:12:"version 2.21";s:22:"DateTimeOriginalSubIFD";s:19:"2007:05:06 15:04:06";s:23:"DateTimedigitizedSubIFD";s:19:"2007:05:06 15:04:06";s:23:"ShutterSpeedValueSubIFD";s:9:"1/249 sec";s:19:"ApertureValueSubIFD";s:5:"f 3.5";s:23:"ExposureBiasValueSubIFD";s:4:"0 EV";s:22:"MaxApertureValueSubIFD";s:5:"f 2.8";s:18:"MeteringModeSubIFD";s:13:"Multi-Segment";s:11:"FlashSubIFD";s:8:"No Flash";s:17:"FocalLengthSubIFD";s:6:"200 mm";s:16:"ColorSpaceSubIFD";s:4:"sRGB";s:20:"ExifImageWidthSubIFD";s:10:"800 pixels";s:21:"ExifImageHeightSubIFD";s:10:"466 pixels";s:27:"FocalPlaneXResolutionSubIFD";s:15:"3959.3220338983";s:27:"FocalPlaneYResolutionSubIFD";s:15:"3959.3220338983";s:30:"FocalPlaneResolutionUnitSubIFD";s:4:"Inch";s:20:"CustomerRenderSubIFD";s:1:"0";s:18:"ExposureModeSubIFD";s:1:"0";s:18:"WhiteBalanceSubIFD";s:1:"0";s:22:"SceneCaptureModeSubIFD";s:1:"0";s:11:"IFD1NumTags";s:1:"6";s:15:"CompressionIFD1";s:16:"Jpeg Compression";s:15:"xResolutionIFD1";s:26:"72 dots per ResolutionUnit";s:15:"yResolutionIFD1";s:26:"72 dots per ResolutionUnit";s:18:"ResolutionUnitIFD1";s:4:"Inch";s:16:"JpegIFOffsetIFD1";s:3:"750";s:19:"JpegIFByteCountIFD1";s:4:"4502";s:17:"DataDumpMakerNote";s:0:"";}

[Dennis]

Ok, basically I looked at your page, took the photo with the guy with the sad look and uploaded it to my test install. (not public). Upload all went fine, this is the exif I got:


Camerafabrikant: Canon
Cameramodel: Canon EOS 20D
Belichting: 1/125 sec
Diafragma: f 6.3
Brandpuntsafstand: 100 mm
ISO: 100
Opnamedatum: May 6, 2007 - 10:39
Flitser: Uit


So it seems to be working for me. Could you post the version info, you can find it in the adminpanel under general info.

And you mentioned you had a database crash. Could you provide more specific details about that?

[GeoS]

And I suggest to reupload all files like two other people done today and now they are happy as there are no more any isssue.

[silfver]

Ok, basically I looked at your page, took the photo with the guy with the sad look and uploaded it to my test install. (not public). Upload all went fine, this is the exif I got:


Camerafabrikant: Canon
Cameramodel: Canon EOS 20D
Belichting: 1/125 sec
Diafragma: f 6.3
Brandpuntsafstand: 100 mm
ISO: 100
Opnamedatum: May 6, 2007 - 10:39
Flitser: Uit


So it seems to be working for me. Could you post the version info, you can find it in the adminpanel under general info.

And you mentioned you had a database crash. Could you provide more specific details about that?Weird!

My host had a raid drive crash, so my database was set to zero. But the backup fixed this.

This is what it says under general info: You are running Pixelpost version: 1.6.0 (in the right direction) - April 2007
EXIF Pixelpost is using exifer v1.5 for EXIF-information.And I suggest to reupload all files like two other people done today and now they are happy as there are no more any isssue.I did this just before I posted this thread. :l

[silfver]

I've tried to replace all the files with new fresh ones, but there's still no exif showing.

Please, any suggestions?

[austriaka]

log in as admin
insert ?errors or &errors (depending if there is a get-variable already) to your link in the adress bar on top of your browser.
Try that in admin panel and on image site.
Tell us what you find there.
If you don't find anything use ?errorsall or &errorsall
KArin

[silfver]

log in as admin
insert ?errors or &errors (depending if there is a get-variable already) to your link in the adress bar on top of your browser.
Try that in admin panel and on image site.
Tell us what you find there.
If you don't find anything use ?errorsall or &errorsall
KArinI wrote ?errorsall in the admin area, and there was error messages everywhere. This is what it said in the top:
Notice: Undefined index: x in /photoblog/admin/pass_recovery.php on line 7
Notice: Undefined index: x in /photoblog/admin/index.php on line 138
Notice: Undefined index: x in /photoblog/admin/index.php on line 164
Notice: Undefined index: view in /photoblog/includes/functions.php on line 593
Notice: Undefined variable: pinglist in /photoblog/addons/admin_ping.php on line 116
Notice: Undefined variable: cfgrow in /photoblog/addons/admin_akismet_comment.php on line 19
Notice: Undefined variable: cfgrow in /photoblog/addons/admin_akismet_comment.php on line 20
Notice: Undefined index: view in /photoblog/addons/admin_akismet_comment.php on line 298
Notice: Undefined index: view in /photoblog/addons/admin_akismet_comment.php on line 305
Notice: Undefined variable: Exif_Msg in /photoblog/addons/admin_update_exif.php on line 63
Notice: Undefined variable: Exif_Msg in /photoblog/addons/admin_update_exif.php on line 64
Notice: Undefined index: _SESSION in /photoblog/includes/12cropimageinc.php on line 27
Notice: Undefined index: _SESSION in /photoblog/includes/12cropimageinc.php on line 27
Notice: Undefined index: x in /photoblog/includes/12cropimageinc.php on line 42
Notice: Undefined index: view in /photoblog/admin/index.php on line 229
Notice: Undefined index: view in /photoblog/includes/functions.php on line 566
Notice: Undefined index: view in /photoblog/addons/admin_12CropImage.php on line 82
Notice: Undefined index: view in /photoblog/includes/functions.php on line 566 This is what appeared in the image site when I wrote ?errorsall: Notice: Undefined index: showimage in /photoblog/index.php on line 79

Notice: Undefined index: x in /photoblog/index.php on line 104

Notice: Undefined index: HTTP_REFERER in /photoblog/includes/functions.php on line 258

Notice: Undefined index: host in /photoblog/includes/functions.php on line 262

Notice: Undefined index: lang in /photoblog/index.php on line 162

Notice: Undefined index: popup in /photoblog/index.php on line 203

Notice: Undefined index: showimage in /photoblog/index.php on line 342

Warning: getimagesize() [function.getimagesize]: Unable to access thumbnails/thumb_ in /photoblog/index.php on line 444

Warning: getimagesize(thumbnails/thumb_) [function.getimagesize]: failed to open stream: No such file or directory in /photoblog/index.php on line 444

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /photoblog/includes/functions.php on line 282

Warning: getimagesize() [function.getimagesize]: Unable to access thumbnails/thumb_ in /photoblog/index.php on line 473

Warning: getimagesize(thumbnails/thumb_) [function.getimagesize]: failed to open stream: No such file or directory in /photoblog/index.php on line 473

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /photoblog/includes/functions.php on line 282

Warning: getimagesize() [function.getimagesize]: Unable to access thumbnails/thumb_ in /photoblog/index.php on line 501

Warning: getimagesize(thumbnails/thumb_) [function.getimagesize]: failed to open stream: No such file or directory in /photoblog/index.php on line 501

Notice: Undefined index: showimage in /photoblog/index.php on line 698

Notice: Undefined index: popup in /photoblog/index.php on line 704

Notice: Undefined index: curr_month in /photoblog/addons/calendar.php on line 48

Notice: Undefined index: curr_year in /photoblog/addons/calendar.php on line 49

Notice: Undefined variable: curr_day in /photoblog/addons/calendar.php on line 52

Notice: Undefined index: showimage in /photoblog/addons/calendar.php on line 53

Notice: Undefined index: showimage in /photoblog/addons/calendar.php on line 54

Notice: Undefined index: showimage in /photoblog/addons/calendar.php on line 56

Notice: Undefined variable: pinglist in /photoblog/addons/admin_ping.php on line 116

Notice: Undefined index: view in /photoblog/addons/admin_akismet_comment.php on line 298

Notice: Undefined index: view in /photoblog/addons/admin_akismet_comment.php on line 305

Notice: Undefined variable: Exif_Msg in /photoblog/addons/admin_update_exif.php on line 63

Notice: Undefined variable: Exif_Msg in /photoblog/addons/admin_update_exif.php on line 64 Is this really bad? :confused: :rolleyes:

[Dennis]

No, these are merely notices. Nothing to worry about.

[silfver]

No, these are merely notices. Nothing to worry about.Hm, okay. Any more ideas?

I don't get it. The exif-info is available in phpMyAdmin, under the table pixelpost_pixelpost. So the problem must be when pixelpost is priting the info on the image page. Right?

I really want this to work. :l I used the same files and installed it on my localhost without any problems.

[austriaka]

And are you sure you have the exactly same files in your local installation and online? FTP programs sometimes don't overwrite files if the date of the file to overwrite is newer than the overwriting one.
Please use only "errors" in the URL, do you see nothing there? (Addon page, admin images list, images front page)

I am afraid you must learn a little bit PHP to find the point where it is not working. Or find somebody you give your FTP data and let him experiment

KArin

[austriaka]

It is definitely not fault of your images. I just took one from your blog and published it in my blog
http://blog.uhlig.at/index.php?showimage=598
Exif is working ok.

Hm.
When did you download the Pixelpost files? There have been a few updates in exif things, perhaps ypu did miss them?
Download a fresh install and replace the functions_exif.php

KArin

[silfver]

/photoblog/admin/index.php?view=images&errors: No errors.

/photoblog/admin/index.php?view=addons&errors: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /mnt/home/_s/silfver/www.silfvercreations.com/photoblog/addons/paged_archive.php on line 610 /photoblog/?errors:
Warning: getimagesize() [function.getimagesize]: Unable to access thumbnails/thumb_ in /photoblog/index.php on line 444

Warning: getimagesize(thumbnails/thumb_) [function.getimagesize]: failed to open stream: No such file or directory in /photoblog/index.php on line 444

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /photoblog/includes/functions.php on line 282

Warning: getimagesize() [function.getimagesize]: Unable to access thumbnails/thumb_ in /photoblog/index.php on line 473

Warning: getimagesize(thumbnails/thumb_) [function.getimagesize]: failed to open stream: No such file or directory in /photoblog/index.php on line 473

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /photoblog/includes/functions.php on line 282

Warning: getimagesize() [function.getimagesize]: Unable to access thumbnails/thumb_ in /photoblog/index.php on line 501

Warning: getimagesize(thumbnails/thumb_) [function.getimagesize]: failed to open stream: No such file or directory in /photoblog/index.php on line 501I'm gonna try install pixelpost on another location, see if it works better.

[silfver]

It is definitely not fault of your images. I just took one from your blog and published it in my blog
http://blog.uhlig.at/index.php?showimage=598
Exif is working ok.

Hm.
When did you download the Pixelpost files? There have been a few updates in exif things, perhaps ypu did miss them?
Download a fresh install and replace the functions_exif.php

KArinNo change.

[silfver]

I made a fresh installation, in a nother location, but on the same database, and it worked. So it seems that something is wrong with my tables on the database.

I just don't want to loose all comments and images. What tables should I backup if I want to make a fresh installation again?

[Dennis]

You said you used the same database. So two different installs using the same database. Fresh install seems to work, old install not.

This points to the old install being faulty. Otherwise, if it was the database then the new install would also experience the same difficulties as the old install.

[silfver]

You said you used the same database. So two different installs using the same database. Fresh install seems to work, old install not.

This points to the old install being faulty. Otherwise, if it was the database then the new install would also experience the same difficulties as the old install.Yeah, I know. But I just can't drop the old database tables and install pixelpost again. I must have the old comments and all the images and so on.

So if I import this after a fresh install, the error might come again. So I don't know what to do. :(

[Dennis]

I still don't get you. You mention you use the same database, accessed by different script. Did you change the prefix? Or are the tables also the same.

[silfver]

I still don't get you. You mention you use the same database, accessed by different script. Did you change the prefix? Or are the tables also the same.Yes, i changed the prefix.

[Dennis]

In that case, yes, it is probably the database setup. Copying the info from the old to the new tables won't be that hard, but you have to do it by hand.

Another way is to use PHPMyAdmin and save the database structure to a file. Perhaps I can figure out what is the difference between the two setups.

[silfver]

Hm. I exported the structure for the two tables in the database, the working one, and the nonworking one. The nonworking one has 177 rows of data. The working one has 133 rows. That's really weird.

But maybe you guys changed the database structure to the 1.6 version?

However. I'm gonna see if I can see any difference in the two files I've got.

[Dennis]

number of rows doesn't mean much. If you have an addon in the non-working version before that created a table it could be the cause of the additional rows.

Check the structure in the tables for the working one against the non-working one.