Keep html tags in Consent Banner > Texts > Cookie message

Hello @antoiub and anybody from Complianz,

even after update of Complianz to version 7.3.0 (at different domain) the problem persist. I found in PHP error.log the source of problem. The banner is not updated at all because there is invalid SQL query:

WordPress database error Unknown column ‘manage_consent_options’ in ‘field list’ for query UPDATE wp_cmplz_cookiebanners SET title = ‘bottom-right view-preferences’, position = ‘center’, banner_version = ’22’, checkbox_style = ‘slider’, use_logo = ‘custom’, logo_attachment_id = ‘15380’, close_button = ‘0’, category_functional = ‘Funkciniai slaptukai’, category_prefs = ‘a:2:{s:4:\”text\”;s:11:\”Preferences\”;s:4:\”show\”;i:1;}’, category_stats = ‘a:2:{s:4:\”text\”;s:22:\”Statistiniai slaptukai\”;s:4:\”show\”;i:0;}’, category_all = ‘a:2:{s:4:\”text\”;s:20:\”Rinkodaros slaptukai\”;s:4:\”show\”;i:1;}’, header = ‘a:2:{s:4:\”text\”;s:30:\”Valdyk sutikimą su slaptukais\”;s:4:\”show\”;i:1;}’, dismiss = ‘a:2:{s:4:\”text\”;s:7:\”Atmesti\”;s:4:\”show\”;i:0;}’, revoke = ‘Slaptukų nustatymas’, manage_consent_options = ‘hover-hide-mobile’, save_preferences = ‘Išsaugoti nustatymai’, view_preferences = ‘Slapukų nustatymai’, accept = ‘Patvirtinti’, message_optin = ‘
Norėdami užtikrinti geriausias paslaugas, naudojamės tokiomis technologijomis kaip slaptukai, siekiant išsaugoti ir/arba gauti prieigą prie informacijos apie įrenginį.
Sutikus naudotis tomis technologijomis, galėsime apdoroti tokius duomenis, kaip tos Interneto svetainės peržiūros elgesį arba unikalus ID. Nesutikus arba sutikimą panaikinus, tai gali nenaudingai įtakoti kai kurias funkcijas ir savybes.
‘, use_categories = ‘view-preferences’, disable_cookiebanner = ”, banner_width = ‘526’, soft_cookiewall = ‘1’, dismiss_on_scroll = ‘0’, dismiss_on_timeout = ‘0’, dismiss_timeout = ’10’, font_size = ’14’, accept_informational = ‘a:2:{s:4:\”text\”;s:6:\”Accept\”;s:4:\”show\”;i:1;}’, message_optout = ‘To provide the best experiences, we use technologies like cookies to store and/or access device information. Consenting to these technologies will allow us to process data such as browsing behavior or unique IDs on this site. Not consenting or withdrawing consent, may adversely affect certain features and functions.’, use_custom_cookie_css = ‘0’, custom_css = ‘.cmplz-message{}\r\n /* styles for the message box /\r\n.cmplz-deny{}\r\n / styles for the dismiss button /\r\n.cmplz-btn{}\r\n / styles for buttons /\r\n.cmplz-accept{} \r\n/ styles for the accept button /\r\n.cmplz-cookiebanner{} \r\n/ styles for the popup banner /\r\n.cmplz-cookiebanner .cmplz-category{} \r\n/ styles for categories/\r\n.cmplz-manage-consent{} \r\n/ styles for the settings popup /\r\n.cmplz-soft-cookiewall{} \r\n/ styles for the soft cookie wall /\r\n\r\n/ styles for the AMP notice /\r\n#cmplz-consent-ui, #cmplz-post-consent-ui {} \r\n/ styles for entire banner /\r\n#cmplz-consent-ui .cmplz-consent-message {} \r\n/ styles for the message area /\r\n#cmplz-consent-ui button, #cmplz-post-consent-ui button {} \r\n/ styles for the buttons */’, statistics = ‘a:0:{}’, functional_text = ‘a:2:{s:4:\”text\”;s:260:\”Techninis duomenų saugojimas arba prieiga prie jų būtina pagrįstam tikslui leisti naudotis konkrečia paslauga, kurios aiškiai prašo abonentas arba vartotojas arba išskirtinai siekiant pravesti komunikacijos transmisiją per elektroninio ryšio tinklą.\”;s:4:\”show\”;i:1;}’, preferences_text = ‘a:2:{s:4:\”text\”;s:144:\”The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.\”;s:4:\”show\”;i:1;}’, statistics_text = ‘a:2:{s:4:\”text\”;s:82:\”The technical storage or access that is used exclusively for statistical purposes.\”;s:4:\”show\”;i:1;}’, statistics_text_anonymous = ‘a:2:{s:4:\”text\”;s:88:\”Techninis saugojimas arba prieiga, kuria naudojamasi išskirtinai statistiniai tikslais.\”;s:4:\”show\”;i:1;}’, marketing_text = ‘a:2:{s:4:\”text\”;s:243:\”Techninis duomenų saugojimas arba prieiga prie jų būtina vartotojų profiliams sukurti, siekiant siųsti reklamas arba stebėti vartotoją duotojoje Interneto svetainėje arba keliose Interneto svetainėse su panašiais rinkodaros tikslais.\”;s:4:\”show\”;i:1;}’, colorpalette_background = ‘a:2:{s:5:\”color\”;s:7:\”#ffffff\”;s:6:\”border\”;s:7:\”#f2f2f2\”;}’, colorpalette_text = ‘a:2:{s:5:\”color\”;s:7:\”#222222\”;s:9:\”hyperlink\”;s:7:\”#004071\”;}’, colorpalette_toggles = ‘a:3:{s:10:\”background\”;s:7:\”#008800\”;s:6:\”bullet\”;s:7:\”#ffffff\”;s:8:\”inactive\”;s:7:\”#F56E28\”;}’, colorpalette_border_radius = ‘a:5:{s:3:\”top\”;i:12;s:5:\”right\”;i:12;s:6:\”bottom\”;i:12;s:4:\”left\”;i:12;s:4:\”type\”;s:2:\”px\”;}’, border_width = ‘a:4:{s:3:\”top\”;i:0;s:5:\”right\”;i:0;s:6:\”bottom\”;i:0;s:4:\”left\”;i:0;}’, colorpalette_button_accept = ‘a:3:{s:10:\”background\”;s:7:\”#1E73BE\”;s:6:\”border\”;s:7:\”#1E73BE\”;s:4:\”text\”;s:7:\”#ffffff\”;}’, colorpalette_button_deny = ‘a:3:{s:10:\”background\”;s:7:\”#f9f9f9\”;s:6:\”border\”;s:7:\”#f2f2f2\”;s:4:\”text\”;s:7:\”#444444\”;}’, colorpalette_button_settings = ‘a:3:{s:10:\”background\”;s:7:\”#1e73be\”;s:6:\”border\”;s:7:\”#1e73be\”;s:4:\”text\”;s:7:\”#ffffff\”;}’, buttons_border_radius = ‘a:5:{s:3:\”top\”;i:1;s:5:\”right\”;i:1;s:6:\”bottom\”;i:1;s:4:\”left\”;i:1;s:4:\”type\”;s:2:\”px\”;}’, animation = ‘none’, use_box_shadow = ‘1’, header_footer_shadow = ‘0’, hide_preview = ‘0’, disable_width_correction = ‘0’, legal_documents = ‘0’ WHERE ID = 1 made by require(‘wp-blog-header.php’), wp, WP->main, WP->parse_request, do_action_ref_array(‘parse_request’), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, cmplz_do_action, apply_filters(‘cmplz_do_action’), WP_Hook->apply_filters, cmplz_banner_data, CMPLZ_COOKIEBANNER->save

HotFix for Comlianz users: To get over this poor database design you may try to: increase row size limit or change table type to MyISAM (https://dev.mysql.com/doc/refman/8.4/en/column-count-limit.html#row-size-limits )

Correct fix should be done by Complianz:

The problem is, that Complianz has a terrible design of table wp_cmplz_cookiebanners, which has only 1 row, but over 50 columns, where most of them has column type “text”. Probably the intention of using “text” columns was to prevent the MySQL error “The maximum row size” caused by too many too long varchar columns. Probably someone from Complianz read that column types TEXT and BLOB do not count into row size limit. But even this try didn’t solve the problem because every TEXT/BLOB column in fact countributes 9 to 12 bytes toward the row size (see https://dev.mysql.com/doc/refman/8.4/en/column-count-limit.html#row-size-limits )

I used InnoDB table type as default, which has lower row size limit than MyISAM table type. And absolutly inefficient Complianz database design reached the limit.

All those TEXT type columns containing text or array of texts should be merged into one/couple columns of type TEXT which would contain an array or JSON with all the texts definitions…

Complianz should hire DB specialist, who will fix the design amateurism persisting for many years. It’s surprising that Silver partner of Google may have such a poor data design for so many years.

If someone would finaly decide to pay attention to database design, I’m sending a comment to every single column as defined in …/complianz-gdpr-premium-7.5.4.1/cookiebanner/class-cookiebanner.php (made when I compared my existing DB table with the definition in source code of the plugin):

    $sql        = "CREATE TABLE $table_name (
         ID int(11) NOT NULL AUTO_INCREMENT,        #OK
         title text NOT NULL,                        #OK, 4th column at llentab_cz_2018
         banner_version int(11) NOT NULL,            #OK
         default int(11) NOT NULL,                #OK
        position text NOT NULL,                    #...OK... same, but terrible DB design! Should be ENUM column or VARCHAR with limited length
        checkbox_style text NOT NULL,                #...OK... same, but terrible DB design! Should be ENUM column or VARCHAR with limited length
        use_logo text NOT NULL,                    #...OK... same, but terrible DB design! Should be ENUM column or VARCHAR with limited length
        logo_attachment_id text NOT NULL,            #...OK... same, but terrible DB design! Should be INT
        close_button text NOT NULL,               #...OK... same, but terrible DB design! Should be Boolean
        revoke text NOT NULL,                        #OK
        manage_consent_options text NOT NULL,
        header text NOT NULL,                        #OK
        dismiss text NOT NULL,                    #OK
        save_preferences text NOT NULL,            #...OK... same, but terrible DB design! Should be VARCHAR with limited length
        view_preferences text NOT NULL,            #...OK... same, but terrible DB design! Should be VARCHAR with limited length
        category_functional text NOT NULL,        #...OK... same, but terrible DB design! Should be VARCHAR with limited length
        category_all text NOT NULL,                #OK
        category_stats text NOT NULL,                #OK
        category_prefs text NOT NULL,                #OK
        accept text NOT NULL,                        #...OK... same, but terrible DB design! Should be VARCHAR with limited length
        message_optin text NOT NULL,                #OK
        use_categories text NOT NULL,                #...OK... same, but terrible DB design! Should be ENUM column or VARCHAR with limited length
        disable_cookiebanner int(11) NOT NULL,    #OK (should be Boolean)
        banner_width int(11) NOT NULL,            #OK (should be small int)
        soft_cookiewall int(11) NOT NULL,            #OK (should be Boolean)
        dismiss_on_scroll int(11) NOT NULL,        #OK (should be small int)
        dismiss_on_timeout int(11) NOT NULL,        #OK (should be Boolean)
        dismiss_timeout text NOT NULL,            #...OK... same, but terrible DB design! Should be INT
        accept_informational text NOT NULL,        #OK
        message_optout text NOT NULL,                #OK
        use_custom_cookie_css text NOT NULL,        #OK (should be Boolean)
        custom_css text NOT NULL,                    #OK
        statistics text NOT NULL,                    #OK...
        functional_text text NOT NULL,            #OK
        statistics_text text NOT NULL,            #OK
        statistics_text_anonymous text NOT NULL,    #OK
        preferences_text text NOT NULL,            #OK
        marketing_text text NOT NULL,                #OK
        colorpalette_background text NOT NULL,    #OK
        colorpalette_text text NOT NULL,            #OK
        colorpalette_toggles text NOT NULL,        #OK
        colorpalette_border_radius text NOT NULL,    #OK
        border_width text NOT NULL,                #OK...
        font_size text NOT NULL,                    #...OK... same, but should be small INT or VARCHAR with limited length
        colorpalette_button_accept text NOT NULL,    #OK
        colorpalette_button_deny text NOT NULL,    #OK
        colorpalette_button_settings text NOT NULL,#OK
        buttons_border_radius text NOT NULL,        #OK
        animation text NOT NULL,                    #...OK... same, but terrible DB design! Should be ENUM column or VARCHAR with limited length
        use_box_shadow int(11) NOT NULL,            #OK (should be Boolean)
        header_footer_shadow int(11) NOT NULL,    #OK (should be Boolean)
        hide_preview int(11) NOT NULL,            #OK (should be Boolean)
        disable_width_correction int(11) NOT NULL,#OK (should be Boolean)
        legal_documents int(11) NOT NULL,            #OK (should be Boolean)
          PRIMARY KEY  (ID)
        ) $charset_collate;";