View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0002402 | Composr | core_upgrader | public | 2016-04-13 03:13 | 2016-04-13 07:56 |
| Reporter | Nikki Ward | Assigned To | Chris Graham | ||
| Severity | Major-bug | ||||
| Status | resolved | Resolution | fixed | ||
| Product Version | |||||
| Fixed in Version | |||||
| Summary | 0002402: MySQL Compatibility | ||||
| 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." | ||||
| Tags | No tags attached. | ||||
| Time estimation (hours) | |||||
| Sponsorship open | |||||
|
|
Thanks. 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. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2016-04-13 03:13 | Nikki Ward | New Issue | |
| 2016-04-13 07:56 | Chris Graham | Note Added: 0003566 | |
| 2016-04-13 07:56 | Chris Graham | Status | non-assigned => resolved |
| 2016-04-13 07:56 | Chris Graham | Resolution | open => fixed |
| 2016-04-13 07:56 | Chris Graham | Assigned To | => Chris Graham |
