isunbejo / sams2

Automatically exported from code.google.com/p/sams2
GNU General Public License v2.0
1 stars 0 forks source link

MySQL error adding sams_db.sql squid_db.sql #591

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
mysql -u root -p < /usr/share/sams/mysql/sams_db.sql
Enter password: 
ERROR 1064 (42000) at line 7: 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 'TYPE=MyISAM' at line 1

mysql -u root -p < /usr/share/sams/mysql/squid_db.sql
Enter password: 
ERROR 1064 (42000) at line 13: 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 'TYPE=MyISAM' at line 12

What version of the product are you using? On what operating system?
sams_1.0.5_i386.deb  
Ubuntu 12.04

Please provide any additional information below.
mysql-server 5.5.20-0ubuntu3

Original issue reported on code.google.com by AwareC...@gmail.com on 13 Mar 2012 at 9:46

GoogleCodeExporter commented 9 years ago
All sql and txt files placed in /usr/share/sams/mysql must be processed:
substitute TYPE=MyISAM with ENGINE=MyISAM

for mysql-server v.5+

Original comment by AwareC...@gmail.com on 13 Mar 2012 at 10:17