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

[Chandrakant Solanki]

So MySQL is working with freeside 2.3 version.

or please let me know which version I used to mysql support with freeside


On Fri, Mar 14, 2014 at 9:15 PM, John Wilson <johnwilson1969 at gmail.com>wrote:

> 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
>>
>>
>
> _______________________________________________
> 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/20140318/ebeef4b5/attachment.html>