Cara mengatasi MySQL Server said : Expression #1 ORDER BY clause is not in GROUP BY clause and contains nonagregrated column … di SLiMS

31225658_10209778563974264_2249389258995400704_n

Halo pernah kah kalian menemui Pesan Error sperti ini

ERROR

MySQL Server said : Expression #1 ORDER BY clause is not in GROUP BY clause and contains nonagregrated column …

Nah kalo menemui error semcam ini , berikut solusinya

buka phpmyadmin terus klik tab sql terus jalankan  query :

SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

 

31381144_10209780429700906_2291668539100102656_n

Alhamdulilah dapat teratasi
31206208_10209780430900936_101842646774841344_nMySQL Server said : Expression #1 ORDER BY clause is not in GROUP BY clause and contains nonagregrated column …

Sumber Solusi : YoukNowlah
Percakapan di Facebook, lihat disini

Bacaan : https://stackoverflow.com/…/disable-only-full-group-by

 

Leave a Reply

Your email address will not be published. Required fields are marked *