Table 'exampledb.mantis_api_token_table' doesn't exist

Get help from other users here.

Moderators: Developer, Contributor

Post Reply
kumarswamys
Posts: 3
Joined: Jun 14, 2019 1:39 am

Table 'exampledb.mantis_api_token_table' doesn't exist

Post by kumarswamys » Jun 14, 2019 1:44 am

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?

atrol
Site Admin
Posts: 7659
Joined: Mar 26, 2008 4:37 pm
Location: Germany

Re: Table 'exampledb.mantis_api_token_table' doesn't exist

Post by atrol » Jun 15, 2019 3:41 pm

Which version of Mantis do you use?
Is this a fresh install or an upgrade from older version?
Please use Search before posting and read the Manual

kumarswamys
Posts: 3
Joined: Jun 14, 2019 1:39 am

Re: Table 'exampledb.mantis_api_token_table' doesn't exist

Post by kumarswamys » Jun 17, 2019 3:07 am

Version is 2.13.0. It was upgraded from version 1.2.

atrol
Site Admin
Posts: 7659
Joined: Mar 26, 2008 4:37 pm
Location: Germany

Re: Table 'exampledb.mantis_api_token_table' doesn't exist

Post by atrol » Jun 17, 2019 3:21 am

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.
Please use Search before posting and read the Manual

kumarswamys
Posts: 3
Joined: Jun 14, 2019 1:39 am

Re: Table 'exampledb.mantis_api_token_table' doesn't exist

Post by kumarswamys » Jun 20, 2019 4:46 am

Is there any way we can fix this?

atrol
Site Admin
Posts: 7659
Joined: Mar 26, 2008 4:37 pm
Location: Germany

Re: Table 'exampledb.mantis_api_token_table' doesn't exist

Post by atrol » Jun 20, 2019 5:16 am

What's the result of this database select?

Code: Select all

SELECT value FROM mantis_config_table WHERE config_id = 'database_version';
Please use Search before posting and read the Manual

Post Reply