[freeside] Creating db problem

[Edward Shabotinsky]

Thanks Ivan
now i have no problem with DBIx::DBSchema module, i guess freebsd little
diff than a linux :-)
any way i dropped all tables ( to do it's clean ) flushed and ran
this is output
11:49:54(freeside at test)$ >bin/fs-setup freeside

Enter the maximum username length: 15


Freeside tracks the RADIUS attributes User-Name, check attribute Password
and
reply attribute Framed-IP-Address for each user.  You can specify additional
check and reply attributes.  First enter any additional RADIUS check
attributes
you need to track for each user, separated by whitespace.
:


Now enter any additional reply attributes you need to track for each user,
separated by whitespace.
:


Do you wish to enable the tracking of a second, separate shipping/service
address?
: [y/N]:y
DBD::mysql::db do failed: You have an error in your SQL syntax near 'NULL  ,
  freq int NOT NULL  ,
  recur varchar NULL  ,
  setuptax char(1) NULL  ' at line 5 at bin/fs-setup line 173.
CREATE error: You have an error in your SQL syntax near 'NULL  ,
  freq int NOT NULL  ,
  recur varchar NULL  ,
  setuptax char(1) NULL  ' at line 5
doing statement: CREATE TABLE part_pkg (
  pkgpart int NOT NULL  ,
  pkg varchar(80) NOT NULL  ,
  comment varchar(80) NOT NULL  ,
  setup varchar NULL  ,
  freq int NOT NULL  ,
  recur varchar NULL  ,
  setuptax char(1) NULL  ,
  recurtax char(1) NULL  ,
  plan varchar NULL  ,
  plandata varchar NULL  ,
  PRIMARY KEY (pkgpart)
)

i have no error from perl module, but still error in fs-setup file as you
can see
again haf of tables are created and then stop
here is a list for tables:
cust_bill_pay
cust_bill_pkg
cust_main_couty
cust_main_invoice
cust_refund
cust_cvc
part_svc
port
svc_acct
svc_forward
svc_www

these are all empty no data or no info inside.
if i am not mistaked it should put atlist some info in country.
Thanks.

----- Original Message -----
From: "ivan" <ivan at 420.am>
To: <ivan-freeside at sisd.com>
Sent: Tuesday, October 23, 2001 11:19 AM
Subject: Re: [freeside] Creating db problem


> On Tue, Oct 23, 2001 at 10:16:16AM -0500, Edward Shabotinsky wrote:
> > Freebsd 4.4-stable
> > DBIx::DBSchema-0.18
> > should i try to reinstall dbix::dbschema?
>
> Please test DBIx::DBSchema 0.19 from http://www.420.am/dbix-dbschema/ and
> report if it fixes your problem, or if not, the exact error messages
> generated.
>
> >
> > ----- Original Message -----
> > From: "ivan" <ivan at 420.am>
> > To: <ivan-freeside at sisd.com>
> > Sent: Tuesday, October 23, 2001 2:26 AM
> > Subject: Re: [freeside] Creating db problem
> >
> >
> > > What version of Freeside and what version of DBIx::DBSchema?
> > >
> > > On Tue, Oct 23, 2001 at 01:22:24AM -0500, Edward Shabotinsky wrote:
> > > > Hi, all
> > > > running FreeBSD 4.4-stable with mysql 3.23.42 compiled with bdb
support
> > > > any way when running
> > > > fs-setup getting this error message
> > > > .......about 30 of them--->
> > > > -->Use of uninitialized value at
> > > > /usr/local/lib/perl5/site_perl/5.005/DBIx/DBSchema/Column.pm line
251.
> > > > Use of uninitialized value at
> > > > /usr/local/lib/perl5/site_perl/5.005/DBIx/DBSchema/Column.pm line
251.
> > > > Use of uninitialized value at
> > > > /usr/local/lib/perl5/site_perl/5.005/DBIx/DBSchema/Column.pm line
251.
> > > > DBD::mysql::db do failed: You have an error in your SQL syntax near
> > 'NULL,
> > > >   srcsvcintNOT NULL,
> > > >   dstsvcintNOT NULL,
> > > >   dstvarchar(80)NULL,
> > > >   PRIMARY ' at line 2 at bin/fs-setup line 173.
> > > > CREATE error: You have an error in your SQL syntax near 'NULL,
> > > >   srcsvcintNOT NULL,
> > > >   dstsvcintNOT NULL,
> > > >   dstvarchar(80)NULL,
> > > >   PRIMARY ' at line 2
> > > >
> > > > funny part is does creating some of tables. but doesnt go all the
way
> > tru.
> > > > Any idea?
> > > > thanks
> > > >
> > >
> > > --
> > > _ivan
> > >
> >
>
> --
> _ivan
>