Thank you very much for this information and your attempt to help.
We are running PHP 5.4.16. We are running mysql 5.6.25. We aren't running mysql 5.7.
We have searched online and the only reference we could find to PDO in the x-payments manual suggested we add the following lines to php.ini, which we did:
extension=php_pdo.so
extension=php_pdo_mysql.so
This is the error log message. We are getting a PDO exception, followed by a problem retrieving encryption keys (which we presume is related to the PDO error).
Thank you!
Code:
ERROR [2016-07-06 23:41:33]
User: user@email.com; IP: xx.xx.xx.xxx
Zone: Main
Code: PDO_EXCEPTION (2)
Internal PDO exception; code - "42000", message - "SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'generated DESC' at line 1", 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/Base/Db.php:465 file <- /var/www/html/xpayments/lib/XPay/View/Admin/Base/List.php:59 file <- /var/www/html/xpayments/lib/XPay/View/Admin/EncryptKeys.php:97 file <- /var/www/html/xpayments/lib/XPay/Core/Handler.php:424 file <- /var/www/html/xpayments/lib/XPay/View/Admin/Base/List.php:91 file <- /var/www/html/xpayments/lib/XPay/Core/Handler.php:482 file <- /var/www/html/xpayments/lib/XPay/Core/Dispatcher.php:147 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)
Zone: Model
Code: ENCRYPTION_KEYS_UNABLE_TO_RETRIEVE (847)
Unable to retrieve encryption keys for online store "Online Store"
Affected systems: Model/ShoppingCart.php file (67:assert); View/Admin/Main.php file (754:getEncryptionKeys); Skin/Admin/Main.php file (20:getTopWarnings); Skin/Admin/Home.php file (260:require_once); Core/View.php file (83:include); Core/View.php file (191:getContent); View/Admin.php file (220:process); Core/Dispatcher.php file (156:process); Application.php file (137:dispatch); /var/www/html/xpayments/admin.php file (24:run)