Menu
SuiteCRM dedicated support by SalesAgility
Welcome, Guest
Username: Password: Remember me

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

MySQL error 1146: Table 'my_databasename.versions' doesn't exist 1 year 4 months ago #49392

  • Jenna
  • Jenna's Avatar
  • Offline
  • New Member
  • Posts: 10
  • Thank you received: 1
  • Karma: 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
The administrator has disabled public write access.

MySQL error 1146: Table 'my_databasename.versions' doesn't exist 1 year 4 months ago #49403

  • pgr
  • pgr's Avatar
  • Offline
  • Administrator
  • Posts: 7883
  • Thank you received: 1221
  • Karma: 286
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?

My SuiteCRM In-depth blog.
Thank you for always stating your SuiteCRM version, checking your logs, reading the Docs, and searching before you ask!
The administrator has disabled public write access.

MySQL error 1146: Table 'my_databasename.versions' doesn't exist 1 year 3 months ago #49600

  • Jenna
  • Jenna's Avatar
  • Offline
  • New Member
  • Posts: 10
  • Thank you received: 1
  • Karma: 1
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
The administrator has disabled public write access.

MySQL error 1146: Table 'my_databasename.versions' doesn't exist 1 year 3 months ago #49602

  • pgr
  • pgr's Avatar
  • Offline
  • Administrator
  • Posts: 7883
  • Thank you received: 1221
  • Karma: 286
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.

My SuiteCRM In-depth blog.
Thank you for always stating your SuiteCRM version, checking your logs, reading the Docs, and searching before you ask!
The administrator has disabled public write access.

MySQL error 1146: Table 'my_databasename.versions' doesn't exist 1 year 4 weeks ago #53787

  • jamesdronecomplier
  • jamesdronecomplier's Avatar
  • Offline
  • New Member
  • Posts: 11
  • Thank you received: 2
  • Karma: 0
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).
The administrator has disabled public write access.

MySQL error 1146: Table 'my_databasename.versions' doesn't exist 2 months 1 week ago #70367

  • dynorodney
  • dynorodney's Avatar
  • Offline
  • New Member
  • Posts: 11
  • Karma: 0
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.
The administrator has disabled public write access.
Time to create page: 0.055 seconds
Powered by Kunena Forum