Administrator Page Not Displaying Correctly
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.
Hello Arsalan Shah,
Thank you for your assistance. It works now using your first suggestion with the mysql console.
Thank you again,
Regards,
Peter
Try to disable the only_full_group_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)
Learn More