In this blog post, let’s learn about the error message “294 The column column-name must be in the GROUP BY list.” in Hydra and the description of the error.
Error Message
294 The column column-name must be in the GROUP BY list.
Error Details
This INSERT statement does not supply values for all the columns in the table. At least one of the columns that it omits is constrained to be not null. Because the database server would have to insert a null value for every unmentioned column, it cannot perform this insert. Review the statement against the definition of the table. Possibly the definition of the table has been changed.