[freeside-users] DBD::mysql::db do failed: You have an error in your SQL syntax

[Chandrakant Solanki]

Hi All,

Freeside: 3.2 (with MySQL DB)

Follow below installation & configuration URL
http://www.freeside.biz/mediawiki/index.php/Freeside:3:Documentation:InstallingOnDebian7
http://www.freeside.biz/mediawiki/index.php/Freeside:2.3:Documentation:Installation#Installation

I have followed all steps one by one ...

But, when I execute below command as freeside user it gives me error.

# freeside-setup -d example.com

freeside-setup -d mdusolutions.net
Loading schema objects
Connecting to database
Creating tables and indices
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 'range decimal NULL  ,
  PRIMARY KEY (sectornum)
)
ENGINE=InnoDB' at line 10 [for Statement "CREATE TABLE tower_sector (
  sectornum INTEGER NOT NULL  AUTO_INCREMENT,
  towernum int NOT NULL  ,
  sectorname varchar(80) NOT NULL  ,
  ip_addr varchar(15) NULL  ,
  height decimal NULL  ,
  freq_mhz int NULL  ,
  direction int NULL  ,
  width int NULL  ,
  range decimal NULL  ,
  PRIMARY KEY (sectornum)
)
ENGINE=InnoDB"] at /usr/local/bin/freeside-setup line 117.
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 'range decimal NULL  ,
  PRIMARY KEY (sectornum)
)
ENGINE=InnoDB' at line 10
doing statement: CREATE TABLE tower_sector (
  sectornum INTEGER NOT NULL  AUTO_INCREMENT,
  towernum int NOT NULL  ,
  sectorname varchar(80) NOT NULL  ,
  ip_addr varchar(15) NULL  ,
  height decimal NULL  ,
  freq_mhz int NULL  ,
  direction int NULL  ,
  width int NULL  ,
  range decimal NULL  ,
  PRIMARY KEY (sectornum)
)
ENGINE=InnoDB at /usr/local/bin/freeside-setup line 117

Any help plz.

--
Chandrakant Solanki
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://freeside.biz/pipermail/freeside-users/attachments/20140314/6aef1d74/attachment.html>