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|
|Priority||normal||Severity||minor||Reproducibility||have not tried|
|Status||closed||Resolution||no change required|
|Summary||0026957: MySQL migration, APPLICATION ERROR #401|
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.
try to fresh install Mantisbt on dreamhost, everything is okay.
|Tags||No tags attached.|
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)
after change the database table's name, then work
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