STUCK at SEND TEST EMAIL

💬 General Discussion
1

Hello there im using :
Version 7.11.20
Sugar Version 6.5.25 (Build 344)

I am stuck at the “One Moment Please” popup, can you help me?

I was trying to send myself an email but it stuck there and i am using a Shared Hosting.

I got this on my suitecrm.log

Thu Aug 19 15:37:09 2021 [24346][-none-][FATAL] Mysqli_query failed.
Thu Aug 19 15:37:09 2021 [24346][-none-][FATAL] Retrieving record by id users:1 found Query Failed: SELECT users.* FROM users WHERE users.id = ‘1’ AND users.deleted=0 LIMIT 0,1: MySQL error 2006: MySQL server has gone away

Thank you.

2

Hey there,

Are you still having issues with this?


Wanted to double-check, is this in Admin->Email settings?

The “MySQL Server has gone away” error does indicate that something may be timing out


It may be worth checking the Server Logs, if possible, to see if anything of note appears for this

Or, you could try enabling the logging of Slow Queries in Admin->System Settings:

image
image1198×46 4.59 KB

To see if you can find the query that is causing issue


It might also be worth double-checking that your Email Settings are all correct
If they are invalid, it could be attempting to validate, and failing, repeatedly

3

MySQL server has gone away is a serious database server failure, not an application error, so you should focus on database health more than any other concern.

There can be many causes for this (which might make it hard to troubleshoot):

https://dev.mysql.com/doc/refman/8.0/en/gone-away.html

The advice given above by John about checking server logs is :+1:

1 Like