Announcement

#1 2009-11-20 01:36:48

JST
Guest

PHP Errors & Unable to upload photos

The installation completed without issues and I also see tables being created in the database. However, I can't upload any photos using pLoader.

Further investigation shows the following errors in my php log:

Code:

[20-Nov-2009 00:30:22] PHP Warning:  [mysql error 1292] Incorrect date value: '2008:05:18 18:22:32-07:00' for column 'date_creation' at row 1

INSERT INTO piwigo_images
  (file,date_available,tn_ext,name,path,filesize,width,height,md5sum,author,comment,level,date_creation)
  VALUES('20091119163022-e6262385.jpg','2009-11-19 16:30:22','jpg','William_071012_1','./upload/2009/11/19/20091119163022-e6262385.jpg','152','604','600','76b5503dcfd1515462180526730f0a7f',NULL,NULL,'0','2008:05:18 18:22:32-07:00') in C:\inetpub\media.straten.org\include\functions.inc.php on line 918
[20-Nov-2009 00:30:42] PHP Notice:  Undefined index:  0 in C:\inetpub\piwigo\include\category_cats.inc.php on line 245
[20-Nov-2009 00:30:42] PHP Warning:  Cannot modify header information - headers already sent by (output started at C:\inetpub\media.straten.org\include\category_cats.inc.php:245) in C:\inetpub\piwigo\include\page_header.php on line 98
[20-Nov-2009 00:30:42] PHP Notice:  Undefined index:  0 in C:\inetpub\piwigo\include\category_cats.inc.php on line 245
[20-Nov-2009 00:30:42] PHP Warning:  Cannot modify header information - headers already sent by (output started at C:\inetpub\media.straten.org\include\category_cats.inc.php:245) in C:\inetpub\piwigo\include\page_header.php on line 98

I am not an expert with mysql, but I am guessing that the problem might be caused by the incorrect date format in line 1 above.

Any ideas how I can fix that?

Thanks,
Jens

 

#2 2009-11-26 01:24:31

plg
Piwigo Team
Nantes, France, Europe
2002-04-05
13791

Re: PHP Errors & Unable to upload photos

JST,

What is your pLoader version?
Operating System and version?

ron, do you think that depending on the Operating system, pLoader can provide such a specific date format?

JST, I strongly advise you to register on the forum and then subscribe to your topics, this way you will receive email notification on replies :-)

Offline

 

#3 2009-11-26 10:13:40

ron
Former Piwigo Team
2008-09-30
69

Re: PHP Errors & Unable to upload photos

The created date is as read from exif metadata. Until now we did not encounter format problem with it. We have to fix it : [Bugtracker] ticket 1288

Offline

 

Board footer

Powered by FluxBB

github twitter newsletter Donate Piwigo.org © 2002-2024 · Contact