Photo Organizer

  • Status Closed
  • Percent Complete
  • Task Type Bug Report
  • Category Web site
  • Assigned To No-one
  • Operating System All
  • Severity Medium
  • Priority Very Low
  • Reported Version 2.35
  • Due in Version Undecided
  • Due Date Undecided
  • Votes
  • Private
Attached to Project: Photo Organizer
Opened by AJBelayer - 2008-04-07
Last edited by pizza - 2008-04-20

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

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] PHP Warning: pg_query() [<a href=''></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/ on line 82, referer:

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


Closed by  pizza
2008-04-20 15:27
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.
pizza commented on 2008-04-08 21:44

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.

pizza commented on 2008-04-08 21:49

Attached is the patch I just committed into SVN. (r 1998)

   fix.diff (0.6 KiB)


Available keyboard shortcuts


Task Details

Task Editing