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

[John Wilson]

As far as my understanding (from a mailing list entry from Ivan back
in Nov 2013), MySQL is not supported in version 3 and later. Must use
Postgres.



On Fri, Mar 14, 2014 at 6:00 AM, Chandrakant Solanki <
solanki.chandrakant at gmail.com> wrote:

> 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
>
> _______________________________________________
> freeside-users mailing list
> freeside-users at freeside.biz
> http://freeside.biz/cgi-bin/mailman/listinfo/freeside-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://freeside.biz/pipermail/freeside-users/attachments/20140314/1a32018e/attachment.html>