MySQL error 1146: Table 'my_databasename.versions' doesn't exist

👨‍💻 Development Help
1

fresh installation without modification Suite 7.8.5

My steps:
login as admin (first login)
go to diagnostic tool

i get this error message:

Wed Jun 21 18:27:34 2017 [18184][1][FATAL] Query Failed: DESCRIBE versions: MySQL error 1146: Table ‘my_databasename.versions’ doesn’t exist
Wed Jun 21 18:27:34 2017 [18184][1][FATAL] Query Failed: SHOW INDEX FROM versions: MySQL error 1146: Table ‘my_databasename.versions’ doesn’t exist
Wed Jun 21 18:27:34 2017 [18184][1][FATAL] Query Failed: select * from versions: MySQL error 1146: Table ‘my_databasename.versions’ doesn’t exist

The error message comes with each install
7.8.5 + 7.9.1

thanks for help, Jenna

2

Where is that message, in suitecrm.log or upgradeWizard.log or install.log?

And do you have any actual problem, or just that message in the logs?

Because I’ve been investigating this issue and I’m beginning to think it’s just a message we need to remove, but doesn’t really hurt anything…

Can you confirm this?

3

the mesage is after download the diagnostic zip.file and unzip and then under suitecrm.txt (by 7.8.5 and 7.9.1)

both install works fine, fast and without errors

under google i search for: MySQL error 1146 and found many threads for different crm, cms etc. with this message, but not a clean solution

I think the message is not important, but I’m not sure, i work too short with suite crm for an assessment

4

Yes, as I said I am inclined to believe this is just a message to ignore (I’ll try to get it removed from the code, of course, it’s a false alarm).

By the way, if you can access your server you can grab suitecrm.log directly from the file system, it’s usually easier than going through the diagnostic screen.

You can read up on it here. Anyway, if you are on Windows it might be a little different; and if you are on a shared hosting you might have some limitations to reach php_errors.log.

5

A possible solution would be to try going to Admin->Repair->Quick Repair and Rebuild - this worked for me when I had a similar error (albeit for a different table).

6

Hi

Just to confirm its still happening in 7.10.7

Im a new user and just looking round things and ran the diagnostic check and saw this in the suitecrm.log

Fri Aug 10 08:14:28 2018 [2545][1][FATAL] Query Failed: DESCRIBE versions: MySQL error 1146: Table ‘suitecrm.versions’ doesn’t exist
Fri Aug 10 08:14:28 2018 [2545][1][FATAL] Mysqli_query failed.
Fri Aug 10 08:14:28 2018 [2545][1][FATAL] Query Failed: SHOW INDEX FROM versions: MySQL error 1146: Table ‘suitecrm.versions’ doesn’t exist
Fri Aug 10 08:14:28 2018 [2545][1][FATAL] Mysqli_query failed.
Fri Aug 10 08:14:28 2018 [2545][1][FATAL] Query Failed: select * from versions: MySQL error 1146: Table ‘suitecrm.versions’ doesn’t exist

Thankfully I now know I can ignore it rather than try to figure why Im getting the error.

7

Quick message to inform that I got this false alarm as @PGR say when I do a diagnostics, the versions table seem to not exist !

Last Suitecrm version 7.11.6

1 Like