SQL error on upgrade

  • Resolved gresakg

    (@gresakg)


    8 years, 6 months ago

    While upgrading to the latest version, I got the following sql error in my error.log:

    Foreign key constraint is incorrectly formed”) for the query CREATE TABLE wp_cfs_membership_presets (
    form_id int(11) NOT NULL,
    allow_use TINYINT(1) NOT NULL DEFAULT 0,
    PRIMARY KEY (form_id),
    FOREIGN KEY fk_membership_presets_forms_id (form_id)
    REFERENCES wp_cfs_forms(id)
    ON DELETE CASCADE
    ) DEFAULT CHARSET=utf8

    Also, the db table cfs_membership_presets is not created.
    Plugin version 1.3.4
    DB version 5.5.5-10.1.29-MariaDB-1

    • This topic was modified 8 years, 6 months ago by gresakg.
Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author supsystic

    (@supsysticcom)

    8 years, 6 months ago

    Hi @gresakg

    Thank you for contacting us about this plugin question.

    cfs_membership_presets – this table exists in order to cooperate with other our plugin Membership. So if you don’t need it now, there is nothing to worry about.

    About sql error, your issue was redirected to our developer and he will try to fix it any time soon. I will inform you about the progress

    Plugin Author supsystic

    (@supsysticcom)

    8 years, 6 months ago

    Hello @gresakg
    We are glad to tell you that we just released new version – just for you, with fix for your database setup, where you will not see this error anymore. As I said before – it didn’t influence for core work of plugin, it just didn’t created one table in database – required for cooperation with our Membership plugin – https://ww.wp.xz.cn/plugins/membership-by-supsystic/ , but it should work for all of our users, right?:) So, fix is released, all you need to do – is update plugin. Thank you for choosing our solutions!

    • This reply was modified 8 years, 6 months ago by supsystic.
    Thread Starter gresakg

    (@gresakg)

    8 years, 6 months ago

    Thank you very much!
    I just did the upgrade and it worked. Your support is really great!
    Thank you for sharing your solutions!

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘SQL error on upgrade’ is closed to new replies.