A slightly different version of this error is back, and this time it's not browser related.
The whole site was moved on to a new domain name for launch, and it's served with SSL only: all connections are rewritten with an .htaccess file.
This site has 60+ limited manager accounts. And sometimes ( I'm trying to figure out a pattern here, but so far I can't) when some of these clients edit a ressource it will cause a "mysql has too many connections error":
2018-03-12 18:01:13] (ERROR in xPDOConnection::connect @ /home/arda/public_html/core/xpdo/xpdo.class.php : 3116) SQLSTATE[HY000] [1203] User user_modx already has more than 'max_user_connections' active connections
Which then in turn seems to trigger a huge number of XPDO errors:
[2018-03-12 18:01:13] (ERROR @ /home/arda/public_html/core/xpdo/om/xpdoquery.class.php : 653) Could not construct or prepare query because it is invalid or could not connect: SELECT `modExtensionPackage`.`id`, `modExtensionPackage`.`namespace`, `modExtensionPackage`.`name`, `modExtensionPackage`.`path`, `modExtensionPackage`.`table_prefix`, `modExtensionPackage`.`service_class`, `modExtensionPackage`.`service_name`, `modExtensionPackage`.`created_at`, `modExtensionPackage`.`updated_at`, Namespace.path AS namespace_path FROM `modx_extension_packages` AS `modExtensionPackage` JOIN `modx_namespaces` `Namespace` ON `modExtensionPackage`.`namespace` = `Namespace`.`name` ORDER BY namespace ASC
[2018-03-12 18:01:13] (ERROR in xPDOConnection::connect @ /home/arda/public_html/core/xpdo/xpdo.class.php : 3116) SQLSTATE[HY000] [1203] User arda_modx already has more than 'max_user_connections' active connections
[2018-03-12 18:01:13] (ERROR @ /home/arda/public_html/core/xpdo/om/xpdoquery.class.php : 653) Could not construct or prepare query because it is invalid or could not connect: SELECT `modSession`.`id` AS `modSession_id`, `modSession`.`access` AS `modSession_access`, `modSession`.`data` AS `modSession_data` FROM `modx_session` AS `modSession` WHERE `modSession`.`id` = ?
[2018-03-12 18:01:13] (ERROR in xPDOConnection::connect @ /home/arda/public_html/core/xpdo/xpdo.class.php : 3116) SQLSTATE[HY000] [1203] User arda_modx already has more than 'max_user_connections' active connections
[2018-03-12 18:01:13] (ERROR @ /home/arda/public_html/core/xpdo/om/xpdoobject.class.php : 263) Error preparing statement for query: SELECT `modSession`.`id` AS `modSession_id`, `modSession`.`access` AS `modSession_access`, `modSession`.`data` AS `modSession_data` FROM `modx_session` AS `modSession` WHERE `modSession`.`id` = ? -
This has happened to 2 different people today in both Safari and Chrome.
The strange thing is, when I login with these browsers and the same credentials from my computer I don't get the errors. Could this mean it's cache related?
I would immensely appreciate any help, insights, or ideas anybody may have on this as I need to find a real solution as soon as possible.
P.S. @Bruno17 I started learning MIGX DB and experimenting with a custom table version of the site but was not able to get far enough to replace the system before launch (there was a fixed go live date). Do you think using MIGX too heavily is responsible for this? Is there any reason why this would be? If the only way out is to switch to a custom table, then I will put in the work and do that.
