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

Edit report at https://bugs.php.net/bug.php?id=77138&edit=1 ID: 77138 User updated by: zach at zrhoffman dot net Reported by: zach at zrhoffman dot net Summary: Errors creating db schema for web/master Status: Assigned Type: Bug Package: Website problem Operating System: Irrelevant PHP Version: Irrelevant Block user comment: N Private report: N New Comment: Thanks Peter! Previous Comments: ------------------------------------------------------------------------ [2018-11-25 07:25:34] petk@php.net Thank you for the patches. I've opened a request for the mirror here https://bugs.php.net/bug.php?id=77196 since it would be really useful to have it one day. ------------------------------------------------------------------------ [2018-11-11 07:50:17] zach at zrhoffman dot net I did not see a php/web-master repo on GitHub, so I will submit patches here. These 2 patches fix issues importing the db schema for MySQL versions up through 5.7. • Fixed in 95f045c1ff: 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 • Fixed in 95f045c1ff: ERROR 1426 (42000) at line 31: Too big precision 14 specified for 'updated'. Maximum is 6 • Fixed in b07abd2dcb: ERROR 1067 (42000) at line 5: Invalid default value for 'created' ------------------------------------------------------------------------ [2018-11-11 07:31:49] zach at zrhoffman dot net 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 this bug report at https://bugs.php.net/bug.php?id=77138&edit=1