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

Sandeep Yadav Posted in Technical Support 10 years ago

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

Replies
in Sandeep Yadav Replied 10 years ago

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

Indonesian Arsalan Shah Replied 10 years ago

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

in Sandeep Yadav Replied 10 years ago

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

SET GLOBAL sql_mode = "STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION";

Indonesian Arsalan Shah Replied 10 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"