Bug #77138 [NEW]: Errors creating db schema for web/master

From: zach at zrhoffman dot net Operating system: Irrelevant PHP version: Irrelevant Package: Website problem Bug Type: Bug Bug description:Errors creating db schema for web/master Description: ------------ In web/master, there are 4 SQL files to create the db schema for the "phpmasterdb" database. The import works successfully in MySQL 4 but not MySQL 5. Test script: --------------- for sql in *.sql; do echo "$sql"; mysql -udocker -pdocker -hdb docker <"$sql"; done; Expected result: ---------------- Expect successful database import Actual result: -------------- In MySQL 5.5 and up, you get the following errors when trying to import the SQL: zrhoffman: [0]$ for sql in *.sql; do echo "$sql"; mysql -udocker -pdocker -hdb docker <"$sql"; done; event.sql ERROR 1064 (42000) at line 5: 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 21 mirrors.sql ERROR 1064 (42000) at line 5: 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 29 note.sql ERROR 1064 (42000) at line 16: 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 PACK_KEYS=1' at line 14 users.sql ERROR 1064 (42000) at line 25: 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 27 -- Edit bug report at https://bugs.php.net/bug.php?id=77138&edit=1 -- Try a snapshot (PHP 5.4): https://bugs.php.net/fix.php?id=77138&r=trysnapshot54 Try a snapshot (PHP 5.5): https://bugs.php.net/fix.php?id=77138&r=trysnapshot55 Try a snapshot (trunk): https://bugs.php.net/fix.php?id=77138&r=trysnapshottrunk Fixed in SVN: https://bugs.php.net/fix.php?id=77138&r=fixed Fixed in release: https://bugs.php.net/fix.php?id=77138&r=alreadyfixed Need backtrace: https://bugs.php.net/fix.php?id=77138&r=needtrace Need Reproduce Script: https://bugs.php.net/fix.php?id=77138&r=needscript Try newer version: https://bugs.php.net/fix.php?id=77138&r=oldversion Not developer issue: https://bugs.php.net/fix.php?id=77138&r=support Expected behavior: https://bugs.php.net/fix.php?id=77138&r=notwrong Not enough info: https://bugs.php.net/fix.php?id=77138&r=notenoughinfo Submitted twice: https://bugs.php.net/fix.php?id=77138&r=submittedtwice register_globals: https://bugs.php.net/fix.php?id=77138&r=globals PHP 4 support discontinued: https://bugs.php.net/fix.php?id=77138&r=php4 Daylight Savings: https://bugs.php.net/fix.php?id=77138&r=dst IIS Stability: https://bugs.php.net/fix.php?id=77138&r=isapi Install GNU Sed: https://bugs.php.net/fix.php?id=77138&r=gnused Floating point limitations: https://bugs.php.net/fix.php?id=77138&r=float No Zend Extensions: https://bugs.php.net/fix.php?id=77138&r=nozend MySQL Configuration Error: https://bugs.php.net/fix.php?id=77138&r=mysqlcfg