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

How to Turn Off Ads in uTorrent

 uTorrent is a great app, but the ads on desktop versions can be bothersome. Luckily, you can disable them in the Advanced settings. To remove ads and offers, go to Options > Preferences > Advanced. There, you'll see a list of flags and a filter box. Search for and disable these flags: offers.left_rail_offer_enabled/left_rail_offer gui.show_plus_upsell offers.sponsored_torrent_offer_enabled/sponsored_torrent_offer_enabled bt.enable_pulse gui.show_notorrents_node offers.content_offer_autoexec The names of these flags might vary slightly depending on your app version. Be cautious when making changes if you're unsure about their functions.
Read more

Disable browser caching using a PHP header.

Simple : // set expires header header('Expires: Thu, 1 Jan 1970 00:00:00 GMT'); // set cache-control header header('Cache-Control: no-store, no-cache, must-revalidate, max-age=0'); header('Cache-Control: post-check=0, pre-check=0',false); // set pragma header header('Pragma: no-cache'); --------------------------------------------------------------- Pro : // remove header header_remove('ETag'); header_remove('Pragma'); header_remove('Cache-Control'); header_remove('Last-Modified'); header_remove('Expires'); // set header header('Expires: Thu, 1 Jan 1970 00:00:00 GMT'); header('Cache-Control: no-store, no-cache, must-revalidate, max-age=0'); header('Cache-Control: post-check=0, pre-check=0',false); header('Pragma: no-cache');
Read more