Support A2Billing :

provided by Star2Billing S.L.

Support A2Billing :
It is currently Thu Mar 28, 2024 1:52 pm
Hosted Voice Broadcast


All times are UTC




Post new topic Reply to topic  [ 2 posts ] 
Author Message
 Post subject: More Postgres date issues
PostPosted: Fri Feb 29, 2008 10:10 am 
Offline
Moderator
User avatar

Joined: Thu Jun 22, 2006 2:19 pm
Posts: 2890
Location: Devon, UK
Everyone using Postgres should be aware that creating new ratecards (and probably much else) is broken today, the 29th February.
For many records A2B defaults the end/stop date to the start date with the year field incremented. On leap days like today this causes problems for Postgres users as, unlike MySQL, it performs data validation and prevents invalid dates such as '2008-02-31' getting into the database.

The workaround is to set the stop date manually, until this problem is fixed properly in the code. We've got four years until the next occurence.


Top
 Profile  
 
 Post subject:
PostPosted: Fri Feb 29, 2008 2:02 pm 
Offline

Joined: Sun Feb 25, 2007 3:10 am
Posts: 190
Location: Philadelphia, PA
I am having the same problem now. Good to know its a bug with Postgres.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 
Hosted Voice Broadcast


All times are UTC


Who is online

Users browsing this forum: No registered users and 8 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group