View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0026957 | mantisbt | migration | public | 2020-05-13 02:23 | 2020-06-02 16:56 |
Reporter | amphetamine | Assigned To | dregad | ||
Priority | normal | Severity | minor | Reproducibility | have not tried |
Status | closed | Resolution | no change required | ||
Product Version | 2.24.0 | ||||
Summary | 0026957: MySQL migration, APPLICATION ERROR 0000401 | ||||
Description | windows localhost running MantisBT is very well database name: bugtracker3
Database query failed. Error received from database was 0001146: Table 'bugtracker3.mantis_plugin_Announce_message_table' doesn't exist for the query: SELECT m., c., c.id AS context_id FROM mantis_plugin_Announce_message_table AS m Please use the "Back" button in your web browser to return to the previous page. There you can correct whatever problems were identified in this error or select another action. You can also click an option from the menu bar to go directly to a new section. | ||||
Additional Information | try to fresh install Mantisbt on dreamhost, everything is okay. | ||||
Tags | No tags attached. | ||||
Attached Files | |||||
The fact that Mantis works fine with a fresh install on your webhost, implies that there is something wrong with your DB migration procedure. Are you sure that you are importing to the right database instance, and with the same schema name This is not a bug or feature request for MantisBT (you are asking for help on how to migrate / configure the system on a new server). I am therefore resolving this issue as "no change required". Please use the forums, the mantisbt-help mailing list or IRC to get support on customizing and using MantisBT (see http://www.mantisbt.org/support.php) |
|
https://mantisbt.org/forums/viewtopic.php?p=70014#p70014 after change the database table's name, then work mantis_plugin_Announce_context_table |
|
So this is a problem with MySQL table identifier case. By default, table aliases are case-sensitive on Unix, but not so on Windows or macOS See https://dev.mysql.com/doc/refman/8.0/en/identifier-case-sensitivity.html |
|