Jump to:
| Project: | Location |
| Version: | 6.x-3.0-rc1 |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed (duplicate) |
Issue Summary
* user warning: Incorrect table definition; there can be only one auto column and it must be defined as a key query: ALTER TABLE location DROP PRIMARY KEY in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\content\includes\database.mysql-common.inc on line 386.
* user warning: Multiple primary key defined query: ALTER TABLE location CHANGE lid `lid` INT unsigned NOT NULL auto_increment, ADD PRIMARY KEY (lid) in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\content\includes\database.mysql-common.inc on line 520.
* user warning: Can't DROP 'location_instance_nid_idx'; check that column/key exists query: ALTER TABLE location_instance DROP INDEX location_instance_nid_idx in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\content\includes\database.mysql-common.inc on line 448.
* user warning: Can't DROP 'location_instance_vid_idx'; check that column/key exists query: ALTER TABLE location_instance DROP INDEX location_instance_vid_idx in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\content\includes\database.mysql-common.inc on line 448.
* user warning: Can't DROP 'location_instance_uid_idx'; check that column/key exists query: ALTER TABLE location_instance DROP INDEX location_instance_uid_idx in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\content\includes\database.mysql-common.inc on line 448.
* user warning: Can't DROP 'location_instance_genid_idx'; check that column/key exists query: ALTER TABLE location_instance DROP INDEX location_instance_genid_idx in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\content\includes\database.mysql-common.inc on line 448.
* user warning: Can't DROP 'location_instance_lid_idx'; check that column/key exists query: ALTER TABLE location_instance DROP INDEX location_instance_lid_idx in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\content\includes\database.mysql-common.inc on line 448.
* user warning: Duplicate key name 'nid' query: ALTER TABLE location_instance ADD INDEX nid (nid) in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\content\includes\database.mysql-common.inc on line 434.
* user warning: Duplicate key name 'vid' query: ALTER TABLE location_instance ADD INDEX vid (vid) in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\content\includes\database.mysql-common.inc on line 434.
* user warning: Duplicate key name 'uid' query: ALTER TABLE location_instance ADD INDEX uid (uid) in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\content\includes\database.mysql-common.inc on line 434.
* user warning: Duplicate key name 'genid' query: ALTER TABLE location_instance ADD INDEX genid (genid) in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\content\includes\database.mysql-common.inc on line 434.
* user warning: Duplicate key name 'lid' query: ALTER TABLE location_instance ADD INDEX lid (lid) in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\content\includes\database.mysql-common.inc on line 434.
* user warning: Can't DROP 'PRIMARY'; check that column/key exists query: ALTER TABLE zipcodes DROP PRIMARY KEY in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\content\includes\database.mysql-common.inc on line 386.# Failed: ALTER TABLE {location} DROP PRIMARY KEY
# Failed: ALTER TABLE {location} CHANGE lid `lid` INT unsigned NOT NULL auto_increment, ADD PRIMARY KEY (lid)
# Failed: ALTER TABLE {location_instance} DROP INDEX {location_instance}_nid_idx
# Failed: ALTER TABLE {location_instance} DROP INDEX {location_instance}_vid_idx
# Failed: ALTER TABLE {location_instance} DROP INDEX {location_instance}_uid_idx
# Failed: ALTER TABLE {location_instance} DROP INDEX {location_instance}_genid_idx
# Failed: ALTER TABLE {location_instance} DROP INDEX {location_instance}_lid_idx
# Failed: ALTER TABLE {location_instance} ADD INDEX nid (nid)
# Failed: ALTER TABLE {location_instance} ADD INDEX vid (vid)
# Failed: ALTER TABLE {location_instance} ADD INDEX uid (uid)
# Failed: ALTER TABLE {location_instance} ADD INDEX genid (genid)
# Failed: ALTER TABLE {location_instance} ADD INDEX lid (lid)
# Failed: ALTER TABLE {zipcodes} DROP PRIMARY KEY
mysql 5.25 CE
Comments
#1
See #317823: [master] Update warnings.
All of those warnings are harmless and expected when performing an upgrade from an earlier 6.x version.
Thanks for the report!