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

[John Wilson]

I am not the dev. but from what I understand version 2.3.7 is it for mysql.
I looked at migrating to mysql before updating to 3.0, because I already
have a mysql cluster, but shelved plans due to 3.0 not working with mysql.
I never had any issues with Freeside 2.3, and for my use, I didn't really
gain anything from the 3.0 upgrade (as far as new features or functions).
BUT, there is something to be said for running currently supported code. I
have a feeling help/support for 2.3.x will become harder and harder to get
as time goes on. I just had to bite the bullet and run a separate postgres
server and hope either I or someone else can come up with the funds to
support some mysql code work in the near future.


On Tue, Mar 18, 2014 at 7:54 AM, Chandrakant Solanki <
solanki.chandrakant at gmail.com> wrote:

> 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
>>
>>
>
> _______________________________________________
> 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/18c271ae/attachment.html>