Table 'exampledb.mantis_api_token_table' doesn't exist

Get help from other users here.

Moderators: Developer, Contributor

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

Table 'exampledb.mantis_api_token_table' doesn't exist

Post 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?
atrol
Site Admin
Posts: 8366
Joined: 26 Mar 2008, 21:37
Location: Germany

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

Post by atrol »

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: 14 Jun 2019, 06:39

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

Post by kumarswamys »

Version is 2.13.0. It was upgraded from version 1.2.
atrol
Site Admin
Posts: 8366
Joined: 26 Mar 2008, 21:37
Location: Germany

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

Post 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.
Please use Search before posting and read the Manual
kumarswamys
Posts: 3
Joined: 14 Jun 2019, 06:39

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

Post by kumarswamys »

Is there any way we can fix this?
atrol
Site Admin
Posts: 8366
Joined: 26 Mar 2008, 21:37
Location: Germany

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

Post by atrol »

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