[freeside-users] Failing to create database on FreeBSD 1.7 install

[Gerard J. Cerchio]

Gerard J. Cerchio wrote:
> Hi All,
>
> I am trying to just build a new freeside. When I get to create the 
> database I get:
>
> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
> "cust_pay_refund_pkey" for table "cust_pay_refund"
> DBIx::DBSchema::Table->unique method is deprecated; see ->indices at 
> /usr/local/lib/perl5/site_perl/5.8.8/FS/Record.pm line 727
> Can't call method "singles" on an undefined value at 
> /usr/local/lib/perl5/site_perl/5.8.8/FS/Record.pm line 727.
>
> Any suggestions?
>
> Gerard
> _______________________________________________
> freeside-users mailing list
> freeside-users at sisd.com
> http://420.am/cgi-bin/mailman/listinfo/freeside-users
>
>
>   
I tried mysql and have sql syntax errors too:

DBD::mysql::db do failed: You have an error in your SQL syntax; check 
the manual that corresponds to your MySQL server version for the right 
syntax to use near 'NULL  ,
  setup_date int NULL  ,
  renewal_interval int NULL  ,
  expiration_dat' at line 12 [for Statement "CREATE TABLE h_svc_domain (
  historynum INTEGER NOT NULL  AUTO_INCREMENT,
  history_date int NULL  ,
  history_user varchar(80) NOT NULL  ,
  history_action varchar(80) NOT NULL  ,
  svcnum int NOT NULL  ,
  domain varchar(80) NOT NULL  ,
  suffix varchar(80) NULL  ,
  catchall int NULL  ,
  parent_svcnum int NULL  ,
  registrarnum int NULL  ,
  registrarkey varchar NULL  ,
  setup_date int NULL  ,
  renewal_interval int NULL  ,
  expiration_date int NULL  ,
  PRIMARY KEY (historynum)
)
"] at /usr/local/bin/freeside-setup line 101.
CREATE error: You have an error in your SQL syntax; check the manual 
that corresponds to your MySQL server version for the right syntax to 
use near 'NULL  ,
  setup_date int NULL  ,
  renewal_interval int NULL  ,
  expiration_dat' at line 12
doing statement: CREATE TABLE h_svc_domain (
  historynum INTEGER NOT NULL  AUTO_INCREMENT,
  history_date int NULL  ,
  history_user varchar(80) NOT NULL  ,
  history_action varchar(80) NOT NULL  ,
  svcnum int NOT NULL  ,
  domain varchar(80) NOT NULL  ,
  suffix varchar(80) NULL  ,
  catchall int NULL  ,
  parent_svcnum int NULL  ,
  registrarnum int NULL  ,
  registrarkey varchar NULL  ,
  setup_date int NULL  ,
  renewal_interval int NULL  ,
  expiration_date int NULL  ,
  PRIMARY KEY (historynum)
)