Using OSSN 4.0 with SQL Strict mode
Hi guys
i've today finally manage to set up OSSN 4.0 on my production server
it runs on SQL strict mode ( STRICT_ALL_TABLES in my.cnf)
id did not work after base install
what i manage to edit in the code db to make it work was
- editing ossn_object db structure of title field by adding a default NULL value
- editing classes/OssnDatabase.php file by adding, in the insert function, the line
$values = str_replace("'',", "NULL,",$values);
between $values= ... line and $query= ... line
@ Saberi bin Pendi
See http://www.tocker.ca/2014/01/14/making-strict-sql_mode-the-default.html
and refer to the MySQL manual for more information.
Is your server configured like that? If not, and if you're not getting any database errors with Ossn you can ignore this thread. Otherwise please provide your error log and the my.cnf file.
Can you give me screenshot / pictures for example?
One small edit
you also need to add "NULL" default to the item_guid of the ossn_notifications table
Good thank
Good solution,
Due to the many requests in the past for additonal features and components we have decided to develope a premium version. Features like Hashtags, Videos, Polls, Events, Stories, Link Preview, etc included in it.
$199 (Life Time)
Learn More