Hello,

Please let me know the result of following query

```sql
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();`

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

Thank you

Thank you very much it works...