Unable to save Cookie banner (DB table cmplz_cookiebanners exceeds limits)

  • Resolved jan.mazanek

    (@janmazanek)


    7 months, 1 week ago

    Hello,

    in Complianz version 7.0.4 I’m not able to save changes in Cookie Banner.

    The PHP error.log show “WordPress database error Unknown column ‘manage_consent_options’ in ‘field list’ for query UPDATE wp_cmplz_cookiebanners …”

    I’ve tried to enforce execution of cmplz_install_cookiebanner_table($force=false) by changing WordPress option ‘cmplz_cbdb_version’ to previous version 7.0.3. After deactivating and reactivating the banner, the ‘cmplz_cbdb_version’ was upgraded to 7.0.4, but the database table cmplz_cookiebanners is still missing the column manage_consent_options.

    IMHO I have reported to you couple weeks ago on different installation, that you have absolutely terrible design of the database table wp_cmplz_cookiebanners

    PLEASE, it is really important to correctly specify column types of this table. Setting all to “TEXT” is not good way. Please, replace these “TEXT” columns with “VARCHAR” with maximal length specified to a reasonable value.

    At this moment, I’m not able to use Complianz without manually improving this table definition.

    • This topic was modified 7 months, 1 week ago by jan.mazanek.
Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support leonardoiub

    (@leonardotamion)

    Hello,

    thanks for your clear message and I’m sorry for this delayed answer.

    I’ve sent all the information you provided to the dev team, in the meantime can you please send me the url of the website in which you’ve installed our plugin?

    Plugin Support leonardoiub

    (@leonardotamion)

    Hello again,

    thanks for your patience.

    You could try enabling SCRIPT_DEBUG in the wp-config file next to WP_DEBUG, and re-visit the Complianz Dashboard to see if this results in the tables being created.

    Furthermore while we will consider improving upon this in a future release, we are also open to input from the open-source WordPress community, and we would be happy to review pull requests with such improvements on the official Complianz GitHub (https://github.com/Really-Simple-Plugins/complianz-gdpr).

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Unable to save Cookie banner (DB table cmplz_cookiebanners exceeds limits)’ is closed to new replies.