Thread Details
  • State Verified Answer
  • Replies 5 replies
  • Subscribers 366 subscribers
  • Views 2637 views
  • Users 0 members are here
Forum Actions

MySQL server has gone away

James Kinnersley

Hi. I'm trying to set up a development environment on WAMP. I have a full version of Sugar11, and WAMP is using PHP 7.3.21, MySQL 5.7.31, Apache 2.4.46, Elasticsearch 7.13.2.

This thread helped get past the initial issue but editing the installer :- https://sugarclub.sugarcrm.com/dev-club/f/questions-answers/4765/sugarpro-11-0-0-zip-installer-php-sessions-configuration-error 

Then my own thread got me a but further regarding database failure:- https://sugarclub.sugarcrm.com/dev-club/f/questions-answers/4891/database-failure-creating-local-sugar-with-wamp-and-sugarent-11-0-0-dev-1-zip 

The installation finishes and the database tables are built, however the error now says :-

Your license has been altered since the last time you validated it.
Please go to the '"License Management" in the Admin screen.

Error: Could not connect to the Sugar Server. Please check your Proxy Settings value in the System Settings admin panel. Last attempted connection @ 07/01/2021 02:38pm

Note: To send record assignment notifications, an SMTP server must be configured in Email Settings.

Fatal: Your license key information is required .
Please go to the '"License Management" in the Admin screen to update your license information and restore full functionality.

I noticed "Validate user IP address:" was unchecked in the system settings panel so checked it to match our cloud and hit save...

Warning: mysqli_stmt::execute(): MySQL server has gone away in C:\Users\jk20120\Documents\GitHub\SugarEnt-11.0.0\SugarEnt-Full-11.0.0\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\Mysqli\MysqliStatement.php on line 163

Any help would be greatly appreciated!

Thanks
James

  • 0

    Hi James,

    The error you highlighted in the red color is related to the License validation issue.

    You have to revalidate the License key in the License Management in the Administration. If it is not validating you have to do the Manual Validation. Please go through this link for more information.

    Hope this helps:)

    Thanks and Regards,

    PK,

    https://www.bhea.com

  • 0 in reply to Ramya Katram

    Hi. Thanks.  I included the red text for full context, the "MySQL server has gone away" error that is given when I try to save an update in the system settings admin is the issue I'm more concerned about, unless you're suggesting that going through manual validation will also resolve this SQL error?  

  • +1 in reply to James Kinnersley

    Hi James,

    First, try doing the Manual Validation, the Mysql has gone away error is throwing as a warning, but not an error.

    After doing the license validation, log out from the instance. Clear your browser cache and login back to the instance and check. Make sure your Sugar Instance is having proper ownership and permissions.

    So first let us check by doing this and debug the issue if it still exists.

    Thanks,

    PK,

    https://www.bhea.com

  • 0 in reply to Ramya Katram

    Thanks very much PK, the warning didn't show after the licence validation and I'm looking at a new local version of sugar Smiley