[freeside] solved [was dbdef-create (error)]

[ivan at 420.am]

On Thu, Oct 23, 2003 at 12:16:55PM +0200, Amr Shaheen wrote:
> Ivan,
> 
> Yes, it is a fix in DBD::Pg and will be included in DBD::Pg 1.30.
> Also you could find complete info in this link
> https://rt.cpan.org/NoAuth/Bug.html?id=3192.

Thanks for your help!

I modifed DBIx::DBSchema to depend on DBD::Pg 1.30 (1.22 on Debian[1])
when using Pg.  I released a new version of DBIx::DBSchema, 0.22, and
dbdef-create now depends on this new version.

[1] Debian fixed this bug in 1.22-2, which is why I couldn't duplicate
the problem and never saw it myself.

-- 
_ivan


> -----Original Message-----
> From: ivan at 420.am [mailto:ivan at 420.am]
> Sent: Wednesday, October 22, 2003 6:17 PM
> To: ivan-freeside at sisd.com
> Subject: Re: [freeside] solved [was dbdef-create (error)]
> 
> 
> Is that a fix for DBD::Pg?  As per my previous message, please
> send your test case and fix to the DBD::Pg maintainer, not to this
> mailing list.
> 
> Once the fix has been accepted into DBD::Pg, please let us know the
> version of DBD::Pg in which it was fixed, and the other conditions that
> trigger the bug (Perl 5.6.x and earlier?  I don't see it under 5.8.x)
> so I can add that to the DBIx::DBSchema prerequisites.
> 
> Thanks.
> 
> -- 
> _ivan
> 
> 
> On Wed, Oct 22, 2003 at 11:15:01AM +0200, Amr Shaheen wrote:
> > Ivan,
> > 
> > I was able to solve this problem by replacing the line which checks
> > the version of Postgres( 7.3.) while  I have installed version 7.3.4.
> > Using the following regular expression, I was able to avoid the error
> > message:
> > 
> > $version = "$1.$2" if ( $version =~ /(\d+)\.(\d+)\.(\d+)/ );
> > 
> > Amr 
> > 
> > 
> > -----Original Message-----
> > From: ivan at 420.am [mailto:ivan at 420.am]
> > Sent: Wednesday, October 08, 2003 12:38 PM
> > To: ivan-freeside at sisd.com
> > Subject: Re: [freeside] dbdef-create (error)
> > 
> > 
> > I can't duplicate your problem, using the same versions of PostgreSQL
> > and DBD::Pg (but Perl 5.8.0, not 5.6.1 or 5.6.0).
> > 
> > The problem appears in the "table_info" subroutine of DBD::Pg - suggest
> > you isolate it to a simple test case illustrating the problem and submit
> > to the DBD::Pg folks.
> > 
> > Good luck.
> > 
> > -- 
> > _ivan
> > 
> > 
> > On Wed, Oct 08, 2003 at 10:50:43AM +0200, Amr Shaheen wrote:
> > > Hi ivan,
> > > 
> > > For the error outlined below , find hereunder the complete info for my installation 
> > > 
> > > Freeside 1.4.1
> > > DBD-Pg-1.22
> > > DBI-1.37
> > > Apache-ASP-2.55
> > > Apache/1.3.28
> > > Debian Sparc (Linux-2.4.20)
> > > postgresql-7.3.4
> > > Perl 5.6.1
> > > 
> > > Amr 
> > > 
> > > > -----Original Message-----
> > > > From: ivan at 420.am [mailto:ivan at 420.am]
> > > > Sent: Wednesday, October 08, 2003 6:44 AM
> > > > To: ivan-freeside at sisd.com
> > > > Subject: Re: [freeside] dbdef-create (error)
> > > > 
> > > > 
> > > > On Tue, Oct 07, 2003 at 04:06:47PM +0200, Amr Shaheen wrote:
> > > > > when I try to run dbdef-create , I've got the following error
> > > > > " Argument "7.3.4" isn't numeric in numeric lt (<) at 
> > > > /usr/local/lib/perl/5.6.1/DBD/Pg.pm line 701 "
> > > > > 
> > > > > Debian Sparc
> > > > > Freeside 1.4.1
> > > > > Postgres 7.3.4
> > > > > Perl 5.6.0
> > > > 
> > > > The path in the error message above indicates you are running Perl
> > > > 5.6.1, not 5.6.0.  Please double check the versions you have 
> > > > posted and
> > > > also provide _ALL_ other requested information including your DBD::Pg
> > > > version, as outlined in the message sent to you when you subscribed.
> > > > 
> > > > -- 
> > > > _ivan
> > > > 
> > 
> > -- 
> > _ivan
> 
> -- 
> _ivan

-- 
_ivan