[SOLVED] Field 'sort' doesn't have a default value

[gebeer]

Hello,

on a page that is live for over a year now, we get this error when trying to add a new child page to a certain parent:

"Field 'sort' doesn't have a default value"

EDIT: here's the whole error message:

Couldn't find anything related on Google so I post here.

The parent page has set sort for children by created date. 

No errors in eeror or exception log.

When trying to save the new child page, the system also says that the name is already taken. But page under same parent with same name does not exist. Page is created in the background, though.

When manually changing the name of the page (adding "-1" to the name), a new page is saved in the background but the system still says that the name is already taken.

Now I'm clueless of what to do. Any help would be much appreciated.

[BitPoet]

Probably an update of MySQL to 5.6. Disable STRICT_TRANS_TABLE and the message should disappear.

[gebeer]

On 2/14/2017 at 0:36 AM, BitPoet said:

Probably an update of MySQL to 5.6. Disable STRICT_TRANS_TABLE and the message should disappear.

Spot on, thank you. In my case it was

ONLY_FULL_GROUP_BY

  that caused the problem

This helped solving it: