Database error in upgradeing 7.11.5 -> 7.11.6

💬 General Discussion
1

Upgrading goes wrong in the last step with an database errer:

Sat Jun 29 10:10:42 2019 [2658][-none-][FATAL] Mysqli_query failed.
Sat Jun 29 10:10:42 2019 [2658][-none-][FATAL] Query Failed: SELECT id, name, symbol, conversion_rate FROM currencies WHERE status = ‘Active’ and deleted = 0: MySQL error 1146: Table ‘d02ee3c3.currencies’ doesn’t exist
Sat Jun 29 10:10:42 2019 [2658][-none-][FATAL] Mysqli_query failed.
Sat Jun 29 10:10:42 2019 [2658][-none-][FATAL] Query Failed: SELECT * FROM fields_meta_data WHERE custom_module=‘Users’ AND deleted = 0: MySQL error 1146: Table ‘d02ee3c3.fields_meta_data’ doesn’t exist
Sat Jun 29 10:10:42 2019 [2658][-none-][FATAL] Mysqli_query failed.
Sat Jun 29 10:10:42 2019 [2658][-none-][FATAL] Query Failed: SELECT * FROM fields_meta_data WHERE custom_module=‘Employees’ AND deleted = 0: MySQL error 1146: Table ‘d02ee3c3.fields_meta_data’ doesn’t exist
Sat Jun 29 10:10:42 2019 [2658][-none-][FATAL] Mysqli_query failed.
Sat Jun 29 10:10:42 2019 [2658][-none-][FATAL] Query Failed: SELECT * FROM fields_meta_data WHERE custom_module=‘UserPreferences’ AND deleted = 0: MySQL error 1146: Table ‘d02ee3c3.fields_meta_data’ doesn’t exist
Sat Jun 29 10:10:42 2019 [2658][-none-][FATAL] Mysqli_query failed.
Sat Jun 29 10:10:42 2019 [2658][-none-][FATAL] Query Failed: SELECT * FROM fields_meta_data WHERE custom_module=‘Administration’ AND deleted = 0: MySQL error 1146: Table ‘d02ee3c3.fields_meta_data’ doesn’t exist
Sat Jun 29 10:10:42 2019 [2658][-none-][FATAL] Mysqli_query failed.
Sat Jun 29 10:10:42 2019 [2658][-none-][FATAL] Unable to retrieve system settings Query Failed: SELECT category, name, value FROM config: MySQL error 1146: Table ‘d02ee3c3.config’ doesn’t exist

Any idea what to do?

2

This error related to MYISAM key limit at users modules.

If anything stuck you can comment out that portion but I am trying to fix core issue.

if urgent go to modules/Users/vardefs.php , find idx and comment out other fields than ID.

      array(
            'name' => 'idx_user_name',
            'type' => 'index',
            'fields' => array(
           //    'user_name',
           //     'is_group',
          //      'status',
           //     'last_name',
           //     'first_name',
                'id'
            )
        ),

This is not a permanent fix. I am trying a better and upgrade safe approch, will keep postedon this thread.

1 Like