error: Fatal error: Uncaught mysqli_sql_exception: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column

Error:

Fatal error: Uncaught mysqli_sql_exception: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column


Solution:

mysqli_query($con, "SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));");

Comments

Post a Comment

Popular posts from this blog

php - get vimeo video id from url

 function getVimeoVideoIdFromUrl($url = '') {     $regs = array();     $id = '';     if (preg_match('%^https?:\/\/(?:www\.|player\.)?vimeo.com\/(?:channels\/(?:\w+\/)?|groups\/([^\/]*)\/videos\/|album\/(\d+)\/video\/|video\/|)(\d+)(?:$|\/|\#?)(?:[?]?.*)$%im', $url, $regs)) {         $id =   $regs[3];     } //    else //    { //        $id = substr($url,10,strlen($url)); //    }     return $id; }
Read more

Hosting a Laravel 11 project on cPanel shared hosting

  Hosting a Laravel 11 project on cPanel shared hosting involves several steps since Laravel is built to work with a virtual host setup (like localhost with public/ as root), but cPanel typically uses public_html/ as the root directory. Here’s a full guide to help you: ✅ Prerequisites Laravel 11 project ready on your local machine. cPanel access (via your hosting provider). PHP version on server must be PHP 8.2+ . Composer installed on server (optional but helpful). MySQL database (if needed) created in cPanel. 📁 Step-by-Step Hosting Guide 1. Structure Your Project for cPanel By default, Laravel uses public/ as the web root. But cPanel uses public_html/ . So you need to move the contents of Laravel's public/ folder into public_html/ , and update paths accordingly. Let’s say your project folder is called laravel11app . Option A: Simple Adjustment (Recommended for shared hosting) Compress your entire Laravel project , excluding the vendor folder (optiona...
Read more