Using OSSN 4.0 with SQL Strict mode

antoine thierry Posted in Technical Support 8 years ago

Hi guys

i've today finally manage to set up OSSN 4.0 on my production server
it runs on SQL strict mode ( STRICTALLTABLES 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

Replies

Michael Zülsdorff Replied 8 years ago

@ 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.

Saberi bin Pendi Replied 8 years ago

Can you give me screenshot / pictures for example?

Antoine thierry Replied 8 years ago

One small edit

you also need to add "NULL" default to the itemguid of the ossnnotifications table

Tunzxywalex Oyewale Replied 8 years ago

Good thank

Arsalan Shah Replied 8 years ago

Good solution,

Premium Version

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