Hello,

Please let me know the result of following query

SELECT @@sql_mode;

If you can check server error logs, please let me know the error details too.

You can enable app logs by changing the log_threshold to 1 in app/config/config.php and then visit the pages again to produce the errors. Lastly check the latest log file in app/logs/ folder.

Thank you

hello any help on my issue

Hello,

Please check mysql.png The mode ONLY_FULL_GROUP_BY is not disabled. Please disable it and test again. Once disabled, it won’t show up in the query result.

If you are on shared hosting then you can disable it on session base by editing the app/core/MY_Controller.php and adding the following line after line 8 parent::__construct();

if ($this->db->dbdriver == 'mysqli') {
    $this->db->query('SET SESSION sql_mode = ""');
}

Thank you

Thank you very much it works…