#2402 - MySQL Compatibility
| Identifier | #2402 |
|---|---|
| Issue type | Major issue (breaks an entire feature) |
| Title | MySQL Compatibility |
| Status | Completed |
| Handling member | Chris Graham |
| Addon | core_upgrader |
| Description | Database query failed: ALTER IGNORE TABLE gg_msp CHANGE `specific_permission` privilege varchar(80) NOT NULL [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 'IGNORE TABLE gg_msp CHANGE `specific_permission` privilege varchar(80) NOT NULL' at line 1]
Database query failed: ALTER IGNORE TABLE gg_gsp CHANGE `specific_permission` privilege varchar(80) NOT NULL [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 'IGNORE TABLE gg_gsp CHANGE `specific_permission` privilege varchar(80) NOT NULL' at line 1] Database query failed: ALTER IGNORE TABLE gg_pstore_permissions CHANGE `p_specific_permission` p_privilege varchar(80) NOT NULL [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 'IGNORE TABLE gg_pstore_permissions CHANGE `p_specific_permission` p_privilege va' at line 1] Database query failed: ALTER IGNORE TABLE gg_actionlogs CHANGE `the_user` member_id integer NOT NULL [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 'IGNORE TABLE gg_actionlogs CHANGE `the_user` member_id integer NOT NULL' at line 1] Database query failed: ALTER IGNORE TABLE gg_sessions CHANGE `the_user` member_id integer NOT NULL [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 'IGNORE TABLE gg_sessions CHANGE `the_user` member_id integer NOT NULL' at line 1] Database query failed: ALTER IGNORE TABLE gg_sessions CHANGE `the_session` the_session varchar(80) NOT NULL [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 'IGNORE TABLE gg_sessions CHANGE `the_session` the_session varchar(80) NOT NULL' at line 1] Database query failed: ALTER IGNORE TABLE gg_config CHANGE `the_name` c_name varchar(80) NOT NULL [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 'IGNORE TABLE gg_config CHANGE `the_name` c_name varchar(80) NOT NULL' at line 1] Database query failed: ALTER IGNORE TABLE gg_config CHANGE `config_value` c_value longtext NOT NULL [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 'IGNORE TABLE gg_config CHANGE `config_value` c_value longtext NOT NULL' at line 1] http://dev.mysql.com/doc/refman/5.7/en/alter-table.html "As of MySQL 5.7.4, the IGNORE clause for ALTER TABLE is removed and its use produces an error." |
| Steps to reproduce | |
| Funded? | No |
The system will post a comment when this issue is modified (e.g., status changes). To be notified of this, click "Enable comment notifications".
Comments
Looks like MySQL left it out of their compatibility list https://dev.mysql.com/doc/refman/5.7/en/upgrading-from-previous-series.html
Please remove these 3 lines from sources/database_helper.php:
if (substr(get_db_type(), 0, 5) == 'mysql') {
$extra2 = 'IGNORE ';
}
The IGNORE clause should in theory not be needed, but we added it for robustness.