• Resolved dot4all

    (@dot4all)


    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/

Viewing 1 replies (of 1 total)
  • Plugin Author straightvisions GmbH

    (@matthias-reuter)

    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.