Peter Undery
Posted in Technical Support 8 years ago
My first post here and I did my best to search for a previous posting of this issue with no success so I apologise if this is discussed elsewhere.
I have installed OSSN V4.2 on Ubuntu Server 16.
After some initial issues with Mod_Rewrite it is installed and works well except that the administrator page will not work Image below. Any assistance appreciated.
Peter Undery
Replied 8 years ago
Hello Arsalan Shah,
Thank you for your assistance. It works now using your first suggestion with the mysql console.
Thank you again,
Regards,
Peter
Arsalan Shah
Replied 8 years ago
Try to disable the onlyfullgroup_by setting by executing the following in your mysql console,
mysql> set global sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
mysql> set session sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
Or edit /etc/mysql/conf.d/mysql.cnf
[mysqld]
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
At last restart mysql service
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)
