When I try to add a new field or delete certain types of fields, this error happens both in version 7 and after upgrade to version 8.2 beta.
request.CRITICAL: Uncaught PHP Exception Exception: “Could not connect to the database. Please refer to suitecrm.log for details (0).” at /var/www/CRM8/public/legacy/include/utils.php line 2080 {“exception”:"[object] (Exception(code: 1): Could not connect to the database. Please refer to suitecrm.log for details (0). at /var/www/CRM8/public/legacy/include/utils.php:2080)"} []
Is there any way to fix this or am I looking at a full reinstall?
After digging through mysql error logs, I found this:
2022-09-20T13:32:04.434767Z 12 [ERROR] [MY-012153] [InnoDB] Trying to access page number 959471926 in space 503, space name suitecrm/accounts_cstm, which is outside the
tablespace bounds. Byte offset 0, len 16384, i/o type read. If you get this error at mysqld startup, please check that your my.cnf matches the ibdata files that you have
in the MySQL server.
SuiteCRM kills the server permanently by trying to access something that doesn’t exist. After this, MySQL keeps restarting and never recovers.
I think this can be closed. I was able to do a database dump and restore on a working backup and it appears that dropping tables no longer kills the database.