• Resolved kwisatz

    (@kwisatz)


    // check if select captcha type fields exist
    $selectCaptchaType = 'selectCaptchaType';
    $result = $wpdb->query( $wpdb->prepare( "SHOW COLUMNS FROM
    $table_name LIKE %s ", $selectCaptchaType ) ); // db call ok; no-cache ok.
    $queryExecuted = false;
    if ( empty( $result ) ) {
    $alter_query = "ALTER TABLE " . $table_name . "
    ADD COLUMN selectCaptchaType int(1) NOT NULL DEFAULT 0 After gCaptcha_site,
    ADD COLUMN cCaptchaType int(1) NOT NULL DEFAULT 0 After selectCaptchaType,
    ADD COLUMN cCaptcha_secret varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci AFTER selectCaptchaType,
    ADD COLUMN cCaptcha_site varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci AFTER cCaptcha_secret;
    ADD COLUMN cCaptchaStyle varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci AFTER cCaptcha_site;
    ";
    $wpdb->query( $alter_query );
    $queryExecuted = true;
    }

    Notice how there might be a problem here?

    WordPress database error:?[You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ADD COLUMN cCaptchaStyle varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode...' at line 6]
    ALTER TABLE wp_sib_model_forms ADD COLUMN selectCaptchaType int(1) NOT NULL DEFAULT 0 After gCaptcha_site, ADD COLUMN cCaptchaType int(1) NOT NULL DEFAULT 0 After selectCaptchaType, ADD COLUMN cCaptcha_secret varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci AFTER selectCaptchaType, ADD COLUMN cCaptcha_site varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci AFTER cCaptcha_secret; ADD COLUMN cCaptchaStyle varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci AFTER cCaptcha_site;
Viewing 2 replies - 1 through 2 (of 2 total)
  • simbot

    (@simbot)

    Same

    NOTICE: PHP message: 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 'ADD COLUMN cCaptchaStyle varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci' at line 6 for query ALTER TABLE wp_sib_model_forms
    ADD COLUMN selectCaptchaType int(1) NOT NULL DEFAULT 0 After gCaptcha_site,
    ADD COLUMN cCaptchaType int(1) NOT NULL DEFAULT 0 After selectCaptchaType,
    ADD COLUMN cCaptcha_secret varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci AFTER selectCaptchaType,
    ADD COLUMN cCaptcha_site varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci AFTER cCaptcha_secret;
    ADD COLUMN cCaptchaStyle varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci AFTER cCaptcha_site;
    made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), include_once('/plugins/mailin/sendinblue.php'), do_action('sendinblue_init'), WP_Hook->do_action, WP_Hook->apply_filters, sendinblue_init, SIB_Manager->__construct, SIB_Forms::createTable

    Plugin Support alexisbienayme

    (@alexisbienayme)

    Hello,

    A fix for this issue is available in the v3.1.82 version of the plugin. Using that version will fix the issue you are encountering.

    I remain at your disposal for any information.

    Best Regards,

    Alexis

Viewing 2 replies - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.