SuiteCRM 8.5 SQL Errors and Access Authorisation errors

chris001 · 7 January 2024 21:05

That’s right.

You should upgrade your MySQL to 8.0.33 or newer (8.2, etc.). The bug causing this issue was in MySQL 8.0.31, not in SuiteCRM 8.x!

github.com/salesagility/SuiteCRM

Comment by clemente-raposo to Fix salesagility#9788 - Database Failures in Subpanels throughout SuiteCRM (MySQL Error)

salesagility:hotfix-7.13.x ← hbartel:master

@pgorod @pstevens71 @hbartel @chris001 Some more data: Tested with mysql vers…ions 8.0.31, 8.0.34, 8.1.0, 8.2.0. Only 8.0.31 fails. Adding info about the tests below. Feedback is welcome ### Testing with mysql 8.0.31 **docker setup** image from mysql dockerhub ``` mysql8031: image: mysql:8.0.31 container_name: mysql8031 restart: always ports: - "3310:3306" volumes: - ./mysql8031:/var/lib/mysql environment: - MYSQL_ROOT_PASSWORD=<pass> - MYSQL_DATABASE=<db> - MYSQL_USER=<user> - MYSQL_PASSWORD=<pass> ``` **adminer** ![image](https://github.com/salesagility/SuiteCRM/assets/1140849/dcd0a6c8-074f-4c64-b9a5-2ec3da1daee4) **result** ![image](https://github.com/salesagility/SuiteCRM/assets/1140849/4138c301-ce5b-44a6-afd9-5cb499f26062) ### Testing with mysql 8.0.34 image from mysql dockerhub ``` mysql80: image: mysql:8.0 container_name: mysql80 restart: always ports: - "3309:3306" volumes: - ./mysql80:/var/lib/mysql environment: - MYSQL_ROOT_PASSWORD=<pass> - MYSQL_DATABASE=<db> - MYSQL_USER=<user> - MYSQL_PASSWORD=<pass> ``` **adminer** ![image](https://github.com/salesagility/SuiteCRM/assets/1140849/b7312a57-38a7-46b3-a165-476ef6f0dce8) **result** ![image](https://github.com/salesagility/SuiteCRM/assets/1140849/e1742c46-849b-4a0f-aef7-9299d2d28187) ### Testing with mysql 8.1.0 image from mysql dockerhub ``` mysql8: image: mysql:8.1 container_name: mysql8 restart: always ports: - "3308:3306" volumes: - ./mysql8:/var/lib/mysql environment: - MYSQL_ROOT_PASSWORD=<pass> - MYSQL_DATABASE=<db> - MYSQL_USER=<user> - MYSQL_PASSWORD=<pass> ``` **adminer** ![image](https://github.com/salesagility/SuiteCRM/assets/1140849/47636dd5-c1ee-4a18-a5b5-6c04ca43491d) **result** ![image](https://github.com/salesagility/SuiteCRM/assets/1140849/169ff5f0-5c7c-4cc8-a877-b3f4db4d2b89) ### Testing with mysql 8.2.0 image from mysql dockerhub ``` mysql82: image: mysql:8.2 container_name: mysql82 restart: always ports: - "3312:3306" volumes: - ./mysql82:/var/lib/mysql environment: - MYSQL_ROOT_PASSWORD=<pass> - MYSQL_DATABASE=<db> - MYSQL_USER=<user> - MYSQL_PASSWORD=<pass> ``` **adminer** ![image](https://github.com/salesagility/SuiteCRM/assets/1140849/e8a8fa12-deca-4857-b7eb-820d5587465c) **result** ![image](https://github.com/salesagility/SuiteCRM/assets/1140849/a86b7021-4013-4adc-b56d-9a273b2e401d)