database error: [Table ‘wp_cleantalk_sfw’ already exists]

  • Resolved Thomas Kurz

    (@thomas-kurz)


    2 years ago

    My site’s home page (https://unbreakableumbrella.com/), at its top displays the following text:

    WordPress database error: [Table ‘wp_cleantalk_sfw’ already exists]
    ALTER TABLE wp_cleantalk_sfw_temp RENAME wp_cleantalk_sfw;

    At https://unbreakableumbrella.com/wp-admin/options-general.php?page=cleantalk is the following:

    Debug:
    Constants:
    CLEANTALK_AJAX_USE_BUFFER NOT_DEFINED
    CLEANTALK_AJAX_USE_FOOTER_HEADER NOT_DEFINED
    CLEANTALK_ACCESS_KEY NOT_DEFINED
    CLEANTALK_CHECK_COMMENTS_NUMBER NOT_DEFINED
    CLEANTALK_CHECK_MESSAGES_NUMBER NOT_DEFINED
    CLEANTALK_PLUGIN_DIR ‘/usr/home/ntoi/public_html/unbreakableumbrella.com/wp-content/plugins/cleantalk-spam-protect/’
    WP_ALLOW_MULTISITE NOT_DEFINED

    ArrayObject Object
    (
    [storage:ArrayObject:private] => Array
    (
    [12:21:36_ACTION__FUNCTION_] => Array
    (
    [0] => Failed.

    Query: ALTER TABLE wp_cleantalk_sfw ADD COLUMN source TINYINT(1) NULL DEFAULT NULL AFTER status;
    Error: Duplicate column name ‘source’
    [1] => Failed.

    Query: ALTER TABLE wp_cleantalk_sfw_logs ADD COLUMN source TINYINT(1) NULL DEFAULT NULL AFTER ua_name, ADD COLUMN network VARCHAR(20) NULL DEFAULT NULL AFTER source, ADD COLUMN first_url VARCHAR(100) NULL DEFAULT NULL AFTER network, ADD COLUMN last_url VARCHAR(100) NULL DEFAULT NULL AFTER first_url;
    Error: Duplicate column name ‘source’

    )

    )

    )

    The page I need help with: [log in to see the link]

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Support SergeM

    (@serge00)

    Hello, @thomas-kurz.

    Please, re-install the CleanTalk Anti-Spam Plugin with the Complete Deactivation option:
    ? WordPress Admin Page —> Settings —> Anti-Spam by CleanTalk —> Advanced settings —> set the option “Complete Deactivation” to “On” —> Save Changes;
    ? WordPress Admin Page —> Plugins —> Installed plugins —> Anti-Spam by CleanTalk —> Deactivate and Delete.

    Then install it anew:
    https://cleantalk.org/help/install-wordpress

    It will solve the issue. Did it help?

    Thread Starter Thomas Kurz

    (@thomas-kurz)

    Hello Serge,

    Yes, it did help. Thank you!

    Thread Starter Thomas Kurz

    (@thomas-kurz)

    Hello Serge,

    Yes, it did help. Thank you!

    Plugin Support SergeM

    (@serge00)

    You are welcome! Glad that worked for you, Thomas.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘database error: [Table ‘wp_cleantalk_sfw’ already exists]’ is closed to new replies.