I am seeing this error when I try to enter one of my Record Types, but only in our DEV environment. I have not made any changes to this record object except to modify the width of one of the columns in the grid (a very small change). It works just fine in the UAT environment and I even exported the UAT version of the object and imported this back to DEV to make sure they exactly matched, but I still see this error. Is there an issue with the connection with the DB maybe? Thanks for any help.
Discussion posts and replies are publicly visible
Are you able to load the relevant table or view in the DEV database, assuming that this is an entity-backed record?
FYI - Resolved by running the following statement to change the mode of MySQL: SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));