From feuerrot, 5 Years ago, written in Plain Text.
Embed
  1. [FAIL]  Database: incorrect column (sensors/sensor_id)
  2. [FAIL]  Database: incorrect column (sensors_to_state_indexes/sensor_id)
  3. [FAIL]  Database: incorrect column (sensors_to_state_indexes/state_index_id)
  4. [FAIL]  Database: missing index (sensors_to_state_indexes/state_index_id)
  5. [FAIL]  Database: extra index (sensors_to_state_indexes/sensors_to_state_indexes_ibfk_1)
  6. [FAIL]  Database: extra constraint (sensors_to_state_indexes/sensors_to_state_indexes_ibfk_10)
  7. [FAIL]  Database: extra constraint (sensors_to_state_indexes/sensors_to_state_indexes_ibfk_6)
  8. [FAIL]  Database: extra constraint (sensors_to_state_indexes/sensors_to_state_indexes_ibfk_7)
  9. [FAIL]  Database: extra constraint (sensors_to_state_indexes/sensors_to_state_indexes_ibfk_8)
  10. [FAIL]  Database: extra constraint (sensors_to_state_indexes/sensors_to_state_indexes_ibfk_9)
  11. [FAIL]  Database: incorrect column (state_indexes/state_index_id)
  12. [FAIL]  We have detected that your database schema may be wrong, please report the following to us on Discord (https://t.libren.ms/discord) or the community site (https://t.libren.ms/5gscd):
  13.         [FIX]:
  14.         Run the following SQL statements to fix.
  15.         SQL Statements:
  16.          ALTER TABLE `sensors` CHANGE `sensor_id` `sensor_id` int(10) unsigned NOT NULL auto_increment;
  17.          ALTER TABLE `sensors_to_state_indexes` CHANGE `sensor_id` `sensor_id` int(10) unsigned NOT NULL ;
  18.          ALTER TABLE `sensors_to_state_indexes` CHANGE `state_index_id` `state_index_id` int(10) unsigned NOT NULL ;
  19.          ALTER TABLE `sensors_to_state_indexes` DROP INDEX `sensors_to_state_indexes_ibfk_1`;
  20.          ALTER TABLE `sensors_to_state_indexes` ADD INDEX `state_index_id` (`state_index_id`);
  21.          ALTER TABLE `sensors_to_state_indexes` DROP FOREIGN KEY `sensors_to_state_indexes_ibfk_10`;
  22.          ALTER TABLE `sensors_to_state_indexes` DROP FOREIGN KEY `sensors_to_state_indexes_ibfk_6`;
  23.          ALTER TABLE `sensors_to_state_indexes` DROP FOREIGN KEY `sensors_to_state_indexes_ibfk_7`;
  24.          ALTER TABLE `sensors_to_state_indexes` DROP FOREIGN KEY `sensors_to_state_indexes_ibfk_8`;
  25.          ALTER TABLE `sensors_to_state_indexes` DROP FOREIGN KEY `sensors_to_state_indexes_ibfk_9`;
  26.          ALTER TABLE `state_indexes` CHANGE `state_index_id` `state_index_id` int(10) unsigned NOT NULL auto_increment;