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).