[freeside-users] DBD::mysql::db do failed: You have an error in your SQL syntax
Sam Tetherow
tetherow at shwisp.net
Wed Mar 19 11:56:50 PDT 2014
Is there a script that will migrate the DB from mysql to PG?
On 03/18/2014 12:14 PM, Jason Hall wrote:
> 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
> <mailto: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
> <mailto: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 <mailto: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
> <mailto: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 <http://example.com>
>
> freeside-setup -dmdusolutions.net <http://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
> <mailto:freeside-users at freeside.biz>
> http://freeside.biz/cgi-bin/mailman/listinfo/freeside-users
>
>
>
> _______________________________________________
> freeside-users mailing list
> freeside-users at freeside.biz
> <mailto:freeside-users at freeside.biz>
> http://freeside.biz/cgi-bin/mailman/listinfo/freeside-users
>
>
>
> _______________________________________________
> freeside-users mailing list
> freeside-users at freeside.biz <mailto:freeside-users at freeside.biz>
> http://freeside.biz/cgi-bin/mailman/listinfo/freeside-users
>
>
>
> _______________________________________________
> freeside-users mailing list
> freeside-users at freeside.biz <mailto:freeside-users at freeside.biz>
> http://freeside.biz/cgi-bin/mailman/listinfo/freeside-users
>
>
>
>
> --
> Jayce^
>
> Preparing Deseret - UtahPreppers
> ????? ????
>
>
> _______________________________________________
> 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/20140319/169dbea8/attachment.html>
More information about the freeside-users
mailing list