Page 1 of 1

MySQL migration from localhost to webhost

Posted: 10 May 2020, 01:32
by amphetamine
windows localhost to webhost (dreamhost)
Checking your MantisBT installation...

Code: Select all

magic_quotes_gpc php.ini directive is disabled	WARN
magic_quotes_runtime php.ini directive is disabled	WARN
Browser Search engine names must be 16 chars or less
Either shorten the "search_title" configuration option to a maximum of 11 characters, or alter the "opensearch_XXX_short" language strings as appropriate to meet the OpenSearch 1.1 specification for the ShortName element.	WARN
after login administrator account,

Code: Select all

APPLICATION ERROR #401

Database query failed. Error received from database was #1146: Table 'mantisbt3.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
JOIN mantis_plugin_Announce_context_table AS c ON c.message_id=m.id
LEFT JOIN mantis_plugin_Announce_dismissed_table as d ON d.context_id=c.id and d.user_id=?
WHERE (d.timestamp IS NULL or d.timestamp < m.timestamp)
AND c.location = ? AND c.project_id = ?
AND c.access <= ? ORDER BY m.timestamp DESC.

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.

Re: MySQL migration from localhost to webhost

Posted: 13 May 2020, 08:33
by amphetamine
https://www.mantisbt.org/bugs/view.php?id=26957

not sure my procedure is correct or not,

localhost mysql, select the database and copy database to "bugtracker3" and export the sql file.
then imported sql file to webhost bugtracker3 database

got the same error message

Re: MySQL migration from localhost to webhost

Posted: 14 May 2020, 05:09
by amphetamine
after change the database table's name, then work

mantis_plugin_Announce_context_table
mantis_plugin_Announce_dismissed_table
mantis_plugin_Announce_message_table

Re: MySQL migration from localhost to webhost

Posted: 14 May 2020, 07:19
by amphetamine
update status,

after closed an issue, got the same issue

Code: Select all

APPLICATION ERROR #401

Database query failed. Error received from database was #1146: Table bugtracker3.mantis_plugin_Holidays_period_table' 
same solution rename the table from mantis_plugin_holidays_period_table to mantis_plugin_Holidays_period_table

Re: MySQL migration from localhost to webhost

Posted: 14 May 2020, 14:01
by dregad