• Resolved nailujac

    (@nailujac)


    Hello,

    I have updated to the latest version of the plugin (6.0.6) and the banner cookie looks different. I’ve tried to update the styles, but when I change something in the banner settings, even though I get a message that the changes have been saved, the changes have no effect, and when I reload the settings page, it’s back to the way it was before.

    This happens with the styles and with the text of the banner.

    Can you help me please?`

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

Viewing 10 replies - 1 through 10 (of 10 total)
  • Plugin Contributor Aert Hulsebos

    (@aahulsebos)

    Hi @nailujac,

    Could you check if you have an error in your browser console while saving, and if not share a debug log?

    You can do the latter with the plugin WP Debugging. If I need to explain a bit more, let me know,
    regards Aert

    Plugin Author Rogier Lankhorst

    (@rogierlankhorst)

    Can you try the current version on GitHub:

    https://github.com/Really-Simple-Plugins/complianz-gdpr

    Thread Starter nailujac

    (@nailujac)

    Hello,

    I have updated the plugin version to 6.1.0

    I have checked and there are no errors in the browser console, but when activating the debug mode this record is written in the logs that seems to be the cause of the problem:

    Error Unknown column ‘use_logo’ in ‘field list’ de la base de datos de WordPress para la consulta UPDATE wp_cmplz_cookiebanners SET position = ‘bottom’, banner_version = ’20’, archived = ‘0’, title = ‘bottom-right minimal’, theme = ‘minimal’, checkbox_style = ‘slider’, use_logo = ”, logo_attachment_id = ‘0’, close_button = ‘0’, category_functional = ‘Funcional’, category_prefs = ‘a:2:{s:4:\”text\”;s:0:\”\”;s:4:\”show\”;b:1;}’, category_stats = ‘a:2:{s:4:\”text\”;s:13:\”Estadísticas\”;s:4:\”show\”;i:1;}’, category_all = ‘a:2:{s:4:\”text\”;s:9:\”Marketing\”;s:4:\”show\”;i:1;}’, header = ‘a:2:{s:4:\”text\”;s:42:\”Gestionar el consentimiento de las cookies\”;s:4:\”show\”;i:1;}’, dismiss = ‘a:2:{s:4:\”text\”;s:7:\”Denegar\”;s:4:\”show\”;i:1;}’, revoke = ‘a:2:{s:4:\”text\”;s:24:\”Gestionar consentimiento\”;s:4:\”show\”;i:1;}’, save_preferences = ‘Guardar preferencias’, view_preferences = ‘Preferencias’, accept = ‘Acepto’, message_optin = ‘Utilizamos cookies para optimizar nuestro sitio web y nuestro servicio. Si quieres saber más pincha en nuestra política’, use_categories = ‘view-preferences’, disable_cookiebanner = ‘0’, banner_width = ‘476’, soft_cookiewall = ‘0’, dismiss_on_scroll = ‘0’, dismiss_on_timeout = ‘0’, dismiss_timeout = ’10’, font_size = ‘0’, accept_informational = ‘a:2:{s:4:\”text\”;s:0:\”\”;s:4:\”show\”;b:1;}’, message_optout = ‘Utilizamos cookies para optimizar nuestro sitio web y nuestro servicio.’, use_custom_cookie_css = ‘1’, custom_css = ‘.cc-message{}\r\n /* styles for the message box */\r\n.cc-dismiss{}\r\n /* styles for the dismiss button */\r\n.cc-btn{}\r\n /* styles for buttons */\r\n.cc-allow{} \r\n/* styles for the accept button */\r\n.cc-accept-all{} \r\n/* styles for the accept all button */\r\n.cc-window{} \r\n/* styles for the popup banner */\r\n.cc-window .cc-category{} \r\n/* styles for categories*/\r\n.cc-window .cc-check{} \r\n/* styles for the checkboxes with categories */\r\n.cc-revoke{} \r\n/* styles for the revoke / settings popup */\r\n.cmplz-slider-checkbox{} \r\n/* styles for the checkboxes */\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 */\r\n#cmplz-document {\r\n max-width : inherit;\r\n}\r\n#cmplz-document h2 {\r\n text-transform: uppercase;\r\n font-size : 18px;\r\n}’, statistics = ‘a:0:{}’, functional_text = ‘a:2:{s:4:\”text\”;s:0:\”\”;s:4:\”show\”;i:1;}’, preferences_text = ‘a:2:{s:4:\”text\”;s:0:\”\”;s:4:\”show\”;b:1;}’, statistics_text = ‘a:2:{s:4:\”text\”;s:0:\”\”;s:4:\”show\”;i:1;}’, statistics_text_anonymous = ‘a:2:{s:4:\”text\”;s:0:\”\”;s:4:\”show\”;b:1;}’, marketing_text = ‘a:2:{s:4:\”text\”;s:0:\”\”;s:4:\”show\”;i:1;}’, colorpalette_background = ‘a:2:{s:5:\”color\”;s:7:\”#ffffff\”;s:6:\”border\”;s:7:\”#f9f9f9\”;}’, colorpalette_text = ‘a:2:{s:5:\”color\”;s:7:\”#777777\”;s:9:\”hyperlink\”;s:7:\”#79b38a\”;}’, colorpalette_toggles = ‘a:3:{s:10:\”background\”;s:7:\”#79b38a\”;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:1;s:5:\”right\”;i:1;s:6:\”bottom\”;i:1;s:4:\”left\”;i:1;}’, colorpalette_button_accept = ‘a:3:{s:10:\”background\”;s:7:\”#79b38a\”;s:6:\”border\”;s:7:\”#79b38a\”;s:4:\”text\”;s:7:\”#ffffff\”;}’, colorpalette_button_deny = ‘a:3:{s:10:\”background\”;s:7:\”#ffffff\”;s:6:\”border\”;s:7:\”#ffffff\”;s:4:\”text\”;s:7:\”#79b38a\”;}’, colorpalette_button_settings = ‘a:3:{s:10:\”background\”;s:7:\”#ffffff\”;s:6:\”border\”;s:7:\”#79b38a\”;s:4:\”text\”;s:7:\”#79b38a\”;}’, buttons_border_radius = ‘a:5:{s:3:\”top\”;i:2;s:5:\”right\”;i:2;s:6:\”bottom\”;i:2;s:4:\”left\”;i:2;s:4:\”type\”;s:2:\”px\”;}’, animation = ‘slide’, use_box_shadow = ‘0’, header_footer_shadow = ‘0’, hide_preview = ‘0’, disable_width_correction = ‘0’, legal_documents = ‘0’ WHERE ID = 1 realizada por require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘plugins_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, cmplz_cookiebanner_form_submit, CMPLZ_COOKIEBANNER->process_form, CMPLZ_COOKIEBANNER->save`

    • This reply was modified 2 years, 9 months ago by nailujac.
    Plugin Author Rogier Lankhorst

    (@rogierlankhorst)

    It looks like your database didn’t run the upgrade. Can you add

    define('SCRIPT_DEBUG', true);

    to your wp-config.php?

    This will force the database upgrade on each pageload.

    Please check the error log that results. It will tell us in more detail about the issue.

    Thread Starter nailujac

    (@nailujac)

    Hello,

    This is the records in error log:

    `Error en la base de datos de WordPress: [Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs]
    ALTER TABLE wp_cmplz_cookiebanners ADD COLUMN use_logo text NOT NULL

    Error en la base de datos de WordPress: [Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs]
    ALTER TABLE wp_cmplz_cookiebanners ADD COLUMN logo_attachment_id text NOT NULL

    Error en la base de datos de WordPress: [Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs]
    ALTER TABLE wp_cmplz_cookiebanners ADD COLUMN close_button text NOT NULL

    Error en la base de datos de WordPress: [Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs]
    ALTER TABLE wp_cmplz_cookiebanners ADD COLUMN functional_text text NOT NULL

    Error en la base de datos de WordPress: [Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs]
    ALTER TABLE wp_cmplz_cookiebanners ADD COLUMN statistics_text text NOT NULL

    Error en la base de datos de WordPress: [Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs]
    ALTER TABLE wp_cmplz_cookiebanners ADD COLUMN statistics_text_anonymous text NOT NULL

    Error en la base de datos de WordPress: [Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs]
    ALTER TABLE wp_cmplz_cookiebanners ADD COLUMN preferences_text text NOT NULL

    Error en la base de datos de WordPress: [Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs]
    ALTER TABLE wp_cmplz_cookiebanners ADD COLUMN marketing_text text NOT NULL

    Error en la base de datos de WordPress: [Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs]
    ALTER TABLE wp_cmplz_cookiebanners ADD COLUMN font_size text NOT NULL

    Error en la base de datos de WordPress: [Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs]
    ALTER TABLE wp_cmplz_cookiebanners ADD COLUMN header_footer_shadow int(11) NOT NULL

    Error en la base de datos de WordPress: [Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs]
    ALTER TABLE wp_cmplz_cookiebanners ADD COLUMN disable_width_correction int(11) NOT NULL

    Error en la base de datos de WordPress: [Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs]
    ALTER TABLE wp_cmplz_cookiebanners ADD COLUMN legal_documents int(11) NOT NULL

    Warning: Cannot modify header information – headers already sent by (output started at /usr/home/ecombarrio.es/web/wp-includes/wp-db.php:1612) in /usr/home/ecombarrio.es/web/wp-includes/functions.php on line 6821 Warning: Cannot modify header information – headers already sent by (output started at /usr/home/ecombarrio.es/web/wp-includes/wp-db.php:1612) in /usr/home/ecombarrio.es/web/wp-admin/includes/misc.php on line 1310 Warning: Cannot modify header information – headers already sent by (output started at /usr/home/ecombarrio.es/web/wp-includes/wp-db.php:1612) in /usr/home/ecombarrio.es/web/wp-admin/admin-header.php on line 9`

    Thank you!

    Plugin Author Rogier Lankhorst

    (@rogierlankhorst)

    @nailujac
    It looks like you still have some old varchar columns, probably caused by skipping some updates.

    can you install the latest github version?

    https://github.com/Really-Simple-Plugins/complianz-gdpr/

    This one upgrades all varchar columns to text, which should resolve the issue.

    Thread Starter nailujac

    (@nailujac)

    Ok, thank you very much, I will do that.

    Can you help me a little? I have technical knowledge but I’m new to wordpress. Is it enough to replace the plugin code with the one from GitHub?

    Thanks a lot!

    Plugin Author Rogier Lankhorst

    (@rogierlankhorst)

    You can deactivate the current plugin, then upload the zip file from GitHub (green button, download as zip) as a normal plugin (plugins, add new, upload).

    Thread Starter nailujac

    (@nailujac)

    Cool! Problem solved. just one more question, now i can delete the old plugin, right?

    Thanks a lot!

    Plugin Contributor jarnovos

    (@jarnovos)

    Hi @nailujac,

    Glad to hear that worked for you. Thank you for the confirmation.

    Yes, you can indeed remove the previous version of the plugin.

    I’ll mark the thread as resolved, feel free to reach out if you have further questions about the plugin.

    Kind regards,
    Jarno

Viewing 10 replies - 1 through 10 (of 10 total)
  • The topic ‘New plugin version does not allow customizing the cookie banner’ is closed to new replies.