Suitecrm 7.12 mysql8 repair - always same SQL STatements

đź’¬ General Discussion
1

we use mysql 8 with suitecrm 7.12 (regarding compatibility Matrix this should be OK).

But after executing the SQL Statements from Repair Module same statements occure with next “Repair” Call.

We know about the mysql8 Changes about “INT”.

Is there any way to stop the repair module checking this and asking me to run the sql statement in 7.12?

1 Like
2

Are the statements related to Indexes or addition of fields to table?

3

fields.

e.a:

ALTER TABLE acl_actions modify COLUMN aclaccess int(3) NULL ;

INT does not have a length in mysql8

4

are your running the app with mysql 8 in production?