<div dir="ltr">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).<div><br></div><div>Switching to PG is worth it. And the development branches have a lot in store for the future.</div>
<div><br></div><div>If you *really* want mysql, you would need to do some pretty heinous rewrites of the Event code.</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Tue, Mar 18, 2014 at 7:54 AM, John Wilson <span dir="ltr"><<a href="mailto:johnwilson1969@gmail.com" target="_blank">johnwilson1969@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">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. <div>
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.</div>
</div><div class="HOEnZb"><div class="h5"><div class="gmail_extra"><br><br><div class="gmail_quote">On Tue, Mar 18, 2014 at 7:54 AM, Chandrakant Solanki <span dir="ltr"><<a href="mailto:solanki.chandrakant@gmail.com" target="_blank">solanki.chandrakant@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div class="gmail_default" style="font-family:verdana,sans-serif">So MySQL is working with freeside 2.3 version.<br>
<br></div><div class="gmail_default" style="font-family:verdana,sans-serif">or please let me know which version I used to mysql support with freeside<br>
</div></div><div><div><div class="gmail_extra"><br><br><div class="gmail_quote">On Fri, Mar 14, 2014 at 9:15 PM, John Wilson <span dir="ltr"><<a href="mailto:johnwilson1969@gmail.com" target="_blank">johnwilson1969@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><pre style="white-space:pre-wrap">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.</pre>
</div>
<div class="gmail_extra"><br><br><div class="gmail_quote"><div><div>On Fri, Mar 14, 2014 at 6:00 AM, Chandrakant Solanki <span dir="ltr"><<a href="mailto:solanki.chandrakant@gmail.com" target="_blank">solanki.chandrakant@gmail.com</a>></span> wrote:<br>
</div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div><div dir="ltr"><div class="gmail_default"><font><span style="font-family:verdana,sans-serif">Hi All,<br>
<br></span></font></div>
<div class="gmail_default"><font><span style="font-family:verdana,sans-serif">Freeside: 3.2 (with MySQL DB)<br>
<br></span></font></div><div class="gmail_default"><font><span style="font-family:verdana,sans-serif">Follow below installation & configuration URL<br><a href="http://www.freeside.biz/mediawiki/index.php/Freeside:3:Documentation:InstallingOnDebian7" target="_blank">http://www.freeside.biz/mediawiki/index.php/Freeside:3:Documentation:InstallingOnDebian7</a><br>
<a href="http://www.freeside.biz/mediawiki/index.php/Freeside:2.3:Documentation:Installation#Installation" target="_blank">http://www.freeside.biz/mediawiki/index.php/Freeside:2.3:Documentation:Installation#Installation</a><br>
<br></span></font></div>
<div class="gmail_default"><font><span style="font-family:verdana,sans-serif">I have followed all steps one by one ...<br><br></span></font></div><div class="gmail_default"><font><span style="font-family:verdana,sans-serif">But, when I execute below command as freeside user it gives me error.<br>
<br></span></font></div><div class="gmail_default"><font><span style="font-family:verdana,sans-serif"># freeside-setup -d <a href="http://example.com" target="_blank">example.com</a><br></span></font></div><div class="gmail_default">
<pre><font><span style="font-family:verdana,sans-serif">freeside-setup -d <a href="http://mdusolutions.net" target="_blank">mdusolutions.net</a><br>Loading schema objects<br>Connecting to database<br>Creating tables and indices<br>
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 ,<br>
PRIMARY KEY (sectornum)<br>)<br>ENGINE=InnoDB' at line 10 [for Statement "CREATE TABLE tower_sector (<br> sectornum INTEGER NOT NULL AUTO_INCREMENT,<br> towernum int NOT NULL ,<br> sectorname varchar(80) NOT NULL ,<br>
ip_addr varchar(15) NULL ,<br> height decimal NULL ,<br> freq_mhz int NULL ,<br> direction int NULL ,<br> width int NULL ,<br> range decimal NULL ,<br> PRIMARY KEY (sectornum)<br>)<br>ENGINE=InnoDB"] at /usr/local/bin/freeside-setup line 117.<br>
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 ,<br> PRIMARY KEY (sectornum)<br>)<br>ENGINE=InnoDB' at line 10<br>
doing statement: CREATE TABLE tower_sector (<br> sectornum INTEGER NOT NULL AUTO_INCREMENT,<br> towernum int NOT NULL ,<br> sectorname varchar(80) NOT NULL ,<br> ip_addr varchar(15) NULL ,<br> height decimal NULL ,<br>
freq_mhz int NULL ,<br> direction int NULL ,<br> width int NULL ,<br> range decimal NULL ,<br> PRIMARY KEY (sectornum)<br>)<br>ENGINE=InnoDB at /usr/local/bin/freeside-setup line 117<br><br></span></font></pre>
<font><span style="font-family:verdana,sans-serif">Any help plz.<br>
<br><font>--<br></font></span></font></div><div class="gmail_default"><font><span style="font-family:verdana,sans-serif"><font><font>Chandrakant Solanki</font><br></font></span></font></div></div>
<br></div></div>_______________________________________________<br>
freeside-users mailing list<br>
<a href="mailto:freeside-users@freeside.biz" target="_blank">freeside-users@freeside.biz</a><br>
<a href="http://freeside.biz/cgi-bin/mailman/listinfo/freeside-users" target="_blank">http://freeside.biz/cgi-bin/mailman/listinfo/freeside-users</a><br>
<br></blockquote></div><br></div>
<br>_______________________________________________<br>
freeside-users mailing list<br>
<a href="mailto:freeside-users@freeside.biz" target="_blank">freeside-users@freeside.biz</a><br>
<a href="http://freeside.biz/cgi-bin/mailman/listinfo/freeside-users" target="_blank">http://freeside.biz/cgi-bin/mailman/listinfo/freeside-users</a><br>
<br></blockquote></div><br></div>
</div></div><br>_______________________________________________<br>
freeside-users mailing list<br>
<a href="mailto:freeside-users@freeside.biz" target="_blank">freeside-users@freeside.biz</a><br>
<a href="http://freeside.biz/cgi-bin/mailman/listinfo/freeside-users" target="_blank">http://freeside.biz/cgi-bin/mailman/listinfo/freeside-users</a><br>
<br></blockquote></div><br></div>
</div></div><br>_______________________________________________<br>
freeside-users mailing list<br>
<a href="mailto:freeside-users@freeside.biz">freeside-users@freeside.biz</a><br>
<a href="http://freeside.biz/cgi-bin/mailman/listinfo/freeside-users" target="_blank">http://freeside.biz/cgi-bin/mailman/listinfo/freeside-users</a><br>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br>Jayce^<br><br>Preparing Deseret - UtahPreppers<br>ΜΟΛΩΝ ΛΑΒΕ
</div>