Database error
-
Hi Matthias,
thank you for this great plugin.
We have some error about database query.Paymill ver: 1.6.9
WP_debug: true (env test)Error:
-WordPress database error: [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 ‘wp_paymill_clients’ at line 1]
SHOW TABLES LIKE wp_paymill_clients
-WordPress database error: [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 ” at line 1]
ALTER TABLE wp_paymill_clients ADD
-WordPress database error: [Duplicate key name ‘wp_member_id’]
ALTER TABLE wp_paymill_clients ADD UNIQUE KEY wp_member_id (paymill_client_id,wp_member_id)
-WordPress database error: [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 ” at line 1]
ALTER TABLE wp_paymill_transactions ADD
-WordPress database error: [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 ‘intervalinterval
longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL’ at line 1]
ALTER TABLE wp_paymill_cache_offers CHANGE COLUMN intervalinterval
longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL
-WordPress database error: [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 ” at line 1]
ALTER TABLE wp_paymill_cache_offers ADD
-WordPress database error: [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 ” at line 1]
ALTER TABLE wp_paymill_subscriptions ADDThank you
David
- The topic ‘Database error’ is closed to new replies.