Expression #1 of ORDER BY contains aggregate function and applies to the result of a non-aggregated query laravel
1. set strict to false in config/databtase.php
2. ->select([
'exam_registrations.id',
'exam_registrations.exam_id',
'exam_registrations.user_id',
DB::raw('sum(submissions.marks) as totalMarksGained')
])
->groupBy('exam_registrations.user_id')
->orderBy('totalMarksGained', 'DESC')SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
Also in PHP:
- add 2 days in php
- "data:text/vcard;
- check if key exist in array
- convert a image to base64 data in php and show image
- failed to clear cache. make sure you have the appropriate permissions. laravel
- consloe.loh in php
- check for keys in array
- catch exception in php
- date() function php
- codeigniter redirect
- disable timestamps laravel
- array key exists php after submit
- check array has key data
- "Allowed memory size of 134217728 bytes exhausted (tried to allocate 56627200 bytes)" in wamp
- can we use a header function to redirect the user to another page
- factory seeder
- Warning: sprintf(): Too few arguments in /opt/lampp/htdocs/wordpress/wp-admin/includes/class-bulk-upgrader-skin.php on line 152
- array filter only folder in php
- PHP string mask day-year
- cache clear in larave
- artisan clear cahce
- Allowed memory size of 1610612736 composer install
- check substring in string php
- cache:clear php artisan