Whmcs Fatal error: Uncaught PDOException: SQLSTATE[42000]

Mysql resetlenince Whmcs de ki aşağıdaki hatanın çözümü

Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column

ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
Çözüm : SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

Sonra : Bu hata çıkarsa sql_mode komple boşalt
 
 MySQL Strict Mode Detected: MySQL strict mode must be disabled to ensure error free operation of WHMCS. Learn more »


 


KENDİME NOTLAR
An error occurred while starting the application.
Centos 7 Plesk 80 ve 443 Nolu Portları Kapanmış
Whmcs Fatal error: Uncaught PDOException: SQLSTATE[42000]
Membership (Üye Yönetimi) ve Rol Management (Rol Yönetimi)
Whmcs Admin login Error
Gmail SMTP Hatası : 5.5.1 Authentication Required. Learn more at
There are some very good open source responsive admin templates based on Bootstrap
net::err_unknown_url_scheme xamarin
The request was aborted: Could not create SSL/TLS secure channel
Wordpress API - XML-RPC.NET
Visual Studio 2015 İndir / Download
ARC Welder
Whmcs Talepler
C Sayfa Yönlendir
SQL SELECT INTO Statement
Sunucu Saatini Geri Almak
Whmcs Pleskde Siteleri Ayrı Ayrı Hesaplar Altında Açması İçin
Sunucu ve Plesk İlk Kurulurken
Plesk Panel/IIS 7.0 da .pfx Uzantılı SSL Sertifikası Yükleme
Reason: Remote SMTP Server Returned: 550 Requested action not taken: mailbox unavailable or not local
YukariCik