Getting error when any user click on "Join group" button

Sandeep Yadav Posted in Technical Support 7 years ago

Getting following error -
exception 'OssnDatabaseException' with message 'Incorrect integer value: '' for column 'itemguid' at row 1 INSERT INTO ossnnotifications (type, poster_guid, owner_guid, subject_guid, item_guid, time_created) VALUES ('group:joinrequest', '2', '1', '189', '', '1482150997');

Replies
in Sandeep Yadav Replied 7 years ago

From where to change "mysql settings and comment that line"

Indonesian Arsalan Shah Replied 7 years ago

You have to change your mysql settings and comment that line.

in Sandeep Yadav Replied 7 years ago

Should I change this in any OSSN config file or run following sql query in DB

SET GLOBAL sqlmode = "STRICTTRANSTABLES,NOAUTOCREATEUSER,NOENGINESUBSTITUTION";

Indonesian Arsalan Shah Replied 7 years ago

This question has been answered many times, please change your sql settings , comment this line:

sql-mode='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'