View Single Post
  #1  
Old 06-01-2016, 02:59 PM
 
joestern joestern is offline
 

Senior Member
  
Join Date: Apr 2004
Posts: 185
 

Default Problem getting to X-Payments Dashboard

I get:

"Internal error
The requested action cannot be performed. See logs for details."

and the error in my logs is:

Code:
ERROR [2016-01-06 22:20:49] User: support@example.com; IP: xxx.xxx.xxx.xxx Zone: Main Code: PDO_EXCEPTION (2) Internal PDO exception; code - "42000", message - "SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'xpayments.xpay_payment_transactions.currency' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by", trace - "/var/www/html/xpayments/lib/XPay/Model/Base/Db.php:122 file <- /var/www/html/xpayments/lib/XPay/Model/Base/Db.php:285 file <- /var/www/html/xpayments/lib/XPay/Model/PaymentTransaction.php:784 file <- /var/www/html/xpayments/lib/XPay/View/Admin/Main.php:438 file <- /var/www/html/xpayments/lib/XPay/View/Admin/Main.php:397 file <- /var/www/html/xpayments/lib/XPay/Skin/Admin/Main.php:22 file <- /var/www/html/xpayments/lib/XPay/Skin/Admin/Home.php:260 file <- /var/www/html/xpayments/lib/XPay/Core/View.php:83 file <- /var/www/html/xpayments/lib/XPay/Core/View.php:191 file <- /var/www/html/xpayments/lib/XPay/View/Admin.php:220 file <- /var/www/html/xpayments/lib/XPay/Core/Dispatcher.php:156 file <- /var/www/html/xpayments/lib/XPay/Application.php:137 file <- /var/www/html/xpayments/admin.php:24 file" Affected systems: Application.php file (70:assert); Application.php file (150:throwException); /var/www/html/xpayments/admin.php file (24:run)

This is on a moved X-Cart installation where we installed the new X-Payments from scratch (2.2.1).
__________________
X-Cart version 4.7.12
Reply With Quote