Getting a Strange error, any ideas:

Ivan Kohler ivan at sisd.com
Sat Feb 27 13:22:51 PST 1999


Change the column type for cust_main.paydate to varchar(10) (using dbimon,
psql or mysql):

    ALTER TABLE cust_main CHANGE paydate paydate varchar(10);

This has been fixed in the CVS tree.  Sorry for the inconvenience.

On Sat, Feb 27, 1999 at 02:50:35AM -0700, Ben Leibig wrote:
> 
> I'm using Redhat Linux 5.2
> Postgresql(that comes with it)
> and I just downloaded all the modules today, so the newest version of all of
> them.
> 
> Perl version is 5.004_04
> 
> I am getting the error:
> 
> Error updating customer information
> 
> Your update did not occur because of the following error:
> 
> ERROR: pg_atoi: error in "1999-11-01": can't parse "-11-01"
> 
> Hit the Back button in your web browser, correct this mistake, and submit
> the form again.
> 
> When I try to add a customer with a credit card date of 11/99 or 11/1999.
> 
> I also tried 11/2000 and 11/00 and got similar errors.
> 

-- 
Ivan Kohler <ivan at sisd.com> - finger for PGP key - <moc.dsis at navi> Relhok Navi
Open-source billing and administration for ISPs - http://www.sisd.com/freeside
20 4,16 * * * saytime # please don't be surprised if you find me dreaming too



More information about the freeside-users mailing list