Title: Database error
Last modified: August 21, 2016

---

# Database error

 *  Resolved [dot4all](https://wordpress.org/support/users/dot4all/)
 * (@dot4all)
 * [11 years, 11 months ago](https://wordpress.org/support/topic/database-error-147/)
 * 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 ‘interval `interval` longtext CHARACTER SET utf8 COLLATE utf8_general_ci
   NOT NULL’ at line 1] ALTER TABLE wp_paymill_cache_offers CHANGE COLUMN interval`
   interval` 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
   ADD
 * Thank you
 * David
 * [https://wordpress.org/plugins/paymill/](https://wordpress.org/plugins/paymill/)

Viewing 1 replies (of 1 total)

 *  Plugin Author [straightvisions GmbH](https://wordpress.org/support/users/matthias-reuter/)
 * (@matthias-reuter)
 * [11 years, 11 months ago](https://wordpress.org/support/topic/database-error-147/#post-5056268)
 * Hi David,
 * that’s unfortunately a bug in dbdelta feature of WordPress. You may want to check
   wether tables are correctly created/updated with comparing SQL from /wp-content/
   plugins/paymill/lib/setup.inc.php within function paymill_install with your database.
 * Kind regards,
 * Matthias

Viewing 1 replies (of 1 total)

The topic ‘Database error’ is closed to new replies.

 * ![](https://ps.w.org/paymill/assets/icon-128x128.png?rev=3119285)
 * [PAYMILL for WordPress](https://wordpress.org/plugins/paymill/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/paymill/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/paymill/)
 * [Active Topics](https://wordpress.org/support/plugin/paymill/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/paymill/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/paymill/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [straightvisions GmbH](https://wordpress.org/support/users/matthias-reuter/)
 * Last activity: [11 years, 11 months ago](https://wordpress.org/support/topic/database-error-147/#post-5056268)
 * Status: resolved