Photo Organizer

This is the bug tracker for Photo Organizer.
Tasklist

FS#343 - Date time incorrect causing failure to commit to db

Attached to Project: Photo Organizer
Opened by Aaron (AJBelayer) - Monday, 07 April 2008, 21:37 GMT
Last edited by Solomon Peachy (pizza) - Sunday, 20 April 2008, 15:27 GMT
Task Type Bug Report
Category Web site
Status Closed
Assigned To No-one
Operating System All
Severity Medium
Priority Normal
Reported Version 2.35
Due in Version Undecided
Due Date Undecided
Percent Complete 100%
Votes 0
Private No

Details

I am seeing this issue both on my site running 2.35a and the stable demo site.

Basically with I am in the calendar and click "add" the dates come up in 1969 (note error from logs below) and when I click "add" I get a "Failed to update database".

Error from my apache logs:
[error] [client 66.7.161.202] PHP Warning: pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR: date/time field value out of range: &quot;2008-4-- 0 :0::0:0&quot;\nHINT: Perhaps you need a different &quot;datestyle&quot; setting. in /var/www/pictures.ajserver.com/html/event.php on line 82, referer: https://pictures.ajserver.com/event.php?action=add&year=2008&month=4&day=7

I am new to PO however I believe this is how you add pictures to the system thus making it quite useless. Also please let me know if this could be a misconfiguration somewhere that I am missing. Both my server and client machine have the proper time and are configured for the proper time zone.

My browser is Firefox 2.0.0.13.

Aaron
This task depends upon

Closed by  Solomon Peachy (pizza)
Sunday, 20 April 2008, 15:27 GMT
Reason for closing:  Works for me
Additional comments about closing:  Given the lack of a "the fix didn't work" I'm considering this closed.
Comment by Solomon Peachy (pizza) - Tuesday, 08 April 2008, 21:44 GMT
Okay, this is a legit bug, but it doesn't affect adding photos. That's done from the folder pages, not the calendar (ie datebook).

You can work around this by clicking on the start/end dates shown, then dismissing the popup calendar.

I've already fixed this in the -devel tree, but I'll see about backporting this in the mean time.
Comment by Solomon Peachy (pizza) - Tuesday, 08 April 2008, 21:49 GMT
Attached is the patch I just committed into SVN. (r 1998)
   fix.diff (0.6 KiB)

Loading...