<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">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">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">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">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>