Page 1 of 1
Table 'exampledb.mantis_api_token_table' doesn't exist
Posted: 14 Jun 2019, 06:44
by kumarswamys
I'm trying to get API token in Account page but there is an error.
Database query failed. Error received from database was #1146: Table 'exampledb.mantis_api_token_table' doesn't exist for the query: SELECT * FROM mantis_api_token_table WHERE user_id=? ORDER BY date_used DESC, date_created ASC.
What could be the issue?
Re: Table 'exampledb.mantis_api_token_table' doesn't exist
Posted: 15 Jun 2019, 20:41
by atrol
Which version of Mantis do you use?
Is this a fresh install or an upgrade from older version?
Re: Table 'exampledb.mantis_api_token_table' doesn't exist
Posted: 17 Jun 2019, 08:07
by kumarswamys
Version is 2.13.0. It was upgraded from version 1.2.
Re: Table 'exampledb.mantis_api_token_table' doesn't exist
Posted: 17 Jun 2019, 08:21
by atrol
There is hardly anything more to say than what the error message is telling.
The database mantis_api_token_table does not exist.
This table should have been generated when running the upgrade script.
It seems you did not run the upgrade script, or you got errors when running the script, but ignored the errors.
Re: Table 'exampledb.mantis_api_token_table' doesn't exist
Posted: 20 Jun 2019, 09:46
by kumarswamys
Is there any way we can fix this?
Re: Table 'exampledb.mantis_api_token_table' doesn't exist
Posted: 20 Jun 2019, 10:16
by atrol
What's the result of this database select?
Code: Select all
SELECT value FROM mantis_config_table WHERE config_id = 'database_version';