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

[Jason Hall]

The mysql code doesn't work on v3 on firstly because it's poor handling of
CASE statements (basically converts each clause to a join, and quickly hits
its join limit).

Switching to PG is worth it. And the development branches have a lot in
store for the future.

If you *really* want mysql, you would need to do some pretty heinous
rewrites of the Event code.


On Tue, Mar 18, 2014 at 7:54 AM, John Wilson <johnwilson1969 at gmail.com>wrote:

> 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
>>
>>
>
> _______________________________________________
> freeside-users mailing list
> freeside-users at freeside.biz
> http://freeside.biz/cgi-bin/mailman/listinfo/freeside-users
>
>


-- 
Jayce^

Preparing Deseret - UtahPreppers
ΜΟΛΩΝ ΛΑΒΕ
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://freeside.biz/pipermail/freeside-users/attachments/20140318/6b8fc5bf/attachment-0001.html>