📣 We're Hiring!

Mysqli_query failed error when sending campaign email

Hi there, up until today everything has been working fine, however, I tried to send an email campaign and got the following error (when I sent a test mail on the campaign):

“Database failure. Please refer to suitecrm.log for details.”

I reviewed the log file and found the following lines:

“Mon Apr 12 12:34:55 2021 [3849][1][FATAL] Mysqli_query failed.
Mon Apr 12 12:34:55 2021 [3849][1][FATAL] Query Failed: select * from versions: MySQL error 1146: Table ‘mydatabasename.versions’ doesn’t exist”

Can anyone advise or assist with this?

Just to add, the only changes I’ve made was this morning in the config.php & include/utils.php, where I changed the ‘default_permissions’ to the following:
‘dir_mode’ => 1533,
‘file_mode’ => 493,

Not sure if this could be causing the problem?

Hey,

Are you still having this issue?

I’m not entirely sure if changing the “default_permissions” could cause this

However, if you haven’t already, it would be worth reverting your changes to see if the error vanishes.


Roughly where do you see the “Database Failure. Please refer to suitecrm.log for details” when you try to send?
(ie, a Popup / Top of screen / etc)
Could you send a screenshot of this?


You may also wish to run the Quick Repair and Rebuild, (admin->Repair), to see if this resolves any issues