search

jbuski / erlandplugins

Automatically exported from code.google.com/p/erlandplugins
0 stars 0 forks source link

Upgrade to MySQL 5.5 breaks SQL scripts due to syntax change #131

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago 
Which plugin is the bug/enhancement related to ?
Custom Browse / Custom Scan

What version of SlimServer/SqueezeCeneter are you using? On what operating
system?
Logitech Media Server Version: 7.7.6 - 1418369353 @ Sat Dec 13 02:04:05 UTC 2014
Hostname: cardinalfang
Server HTTP Port Number: 9000
Operating system: Debian - EN - utf8
Platform Architecture: x86_64-linux
Perl Version: 5.18.2 - x86_64-linux-gnu-thread-multi
Database Version: MySQL 5.5.40-0ubuntu0.14.04.1
Total Players Recognized: 1

Could you describe the problem or enhancment ?

Creating/Modifying MySQL tables fails with an error because the syntax for 
"Type=InnoDB" changed to "Engine=InnoDB"in MySQL 5.5. Manually creating tables 
does not seem to resolve the issue
See: 
http://stackoverflow.com/questions/16408334/how-do-i-fix-error-in-your-sql-synta
x-check-the-manual-for-the-right-synta

What steps will reproduce the problem?
1. Upgrade MySQL to 5.5
2.
3.

Original issue reported on code.google.com by vanraaij...@gmail.com on 14 Jan 2015 at 10:14