Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Wrong result with GDPR Cookie Compliance 4.1.2 plugin #65

Open
beepsoft opened this issue Jan 12, 2020 · 0 comments
Open

Wrong result with GDPR Cookie Compliance 4.1.2 plugin #65

beepsoft opened this issue Jan 12, 2020 · 0 comments

Comments

@beepsoft
Copy link

Hi,

I have Wordpress 5.3.2 with Better Search Replace 1.3.3 and also this plugin installed:

GDPR Cookie Compliance 4.1.2
https://wordpress.org/plugins/gdpr-cookie-compliance/

It manages a table called wp_gdpr_cc_options, which roughly contains the following values:

INSERT INTO `wp_gdpr_cc_options` (`id`, `option_key`, `option_value`, `site_id`, `extras`) VALUES
(1, 'moove_gdpr_nonce', 's:10:\"9340dc9d83\";', 1, NULL),
(2, '_wp_http_referer', 's:57:\"/wp-admin/?page=moove-gdpr&tab=strictly-necessary-cookies\";', 1, NULL),
(3, 'moove_gdpr_brand_colour', 's:7:\"#0c4da2\";', 1, NULL),
(4, 'moove_gdpr_brand_secondary_colour', 's:7:\"#e5e0e0\";', 1, NULL),
(5, 'moove_gdpr_company_logo', 's:90:\"http://localhost:18001/wp-content/plugins/gdpr-cookie-compliance/dist/images/gdpr-logo.png\";', 1, NULL),
(6, 'moove_gdpr_logo_position', 's:4:\"left\";', 1, NULL),
(7, 'moove_gdpr_button_style', 's:7:\"rounded\";', 1, NULL),
(8, 'moove_gdpr_plugin_font_type', 's:1:\"1\";', 1, NULL),
(9, 'moove_gdpr_plugin_font_family', 's:20:\"\'Nunito\', sans-serif\";', 1, NULL),
(10, 'moove_gdpr_cdn_url', 's:0:\"\";', 1, NULL),
(11, 'moove_gdpr_infobar_visibility', 's:7:\"visible\";', 1, NULL),
(12, 'moove_gdpr_reject_button_enable', 's:1:\"0\";', 1, NULL),
(13, 'moove_gdpr_colour_scheme', 's:1:\"2\";', 1, NULL),
(14, 'moove_gdpr_info_bar_content', 's:259:\"<p>A weboldalon a minőségi felhasználói élmény érdekében sütiket használunk.</p>\n<p>Ismerje meg tájékoztatónkat arról, hogy milyen sütiket használunk, vagy a [setting]beállítások[/setting] résznél ki lehet kapcsolni a használatukat.</p>\n\";', 1, NULL),
(15, 'moove_gdpr_infobar_accept_button_label', 's:7:\"Elfogad\";', 1, NULL),
(16, 'moove_gdpr_infobar_reject_button_label', 's:6:\"Reject\";', 1, NULL),
(17, 'moove_gdpr_infobar_position', 's:6:\"bottom\";', 1, NULL),
(18, 'moove_gdpr_strictly_necessary_cookies_functionality', 'i:1;', 1, NULL),
(19, 'moove_gdpr_strictly_necessary_cookies_tab_title', 's:32:\"Feltétlenül szükséges sütik\";', 1, NULL),
(20, 'moove_gdpr_strict_necessary_cookies_tab_content', 's:137:\"A feltétlenül szükséges sütiket mindenkor engedélyezni kell, hogy elmenthessük a beállításokat a sütik további kezeléséhez.\";', 1, NULL),
(21, 'moove_gdpr_strictly_necessary_cookies_warning', 's:246:\"Amennyiben ez a süti nem kerül engedélyezésre, akkor nem tudjuk elmenteni a kiválasztott beállításokat, ami azt eredményezi, hogy minden egyes látogatás alkalmával ismételten el kell végezni a sütik engedélyezésének műveletét.\";', 1, NULL),
(22, 'moove_gdpr_modal_strictly_secondary_notice', 's:145:\"<p>A feltétlenül szükséges sütiket mindenkor engedélyezni kell, hogy elmenthessük a beállításokat a sütik további kezeléséhez.</p>\n\";', 1, NULL);

When I run Better Search Replace on my database including the wp_gdpr_cc_options table (I replace http://localhost:18001 with https://somedomain.com) this is what I get in the database:

INSERT INTO `wp_gdpr_cc_options` (`id`, `option_key`, `option_value`, `site_id`, `extras`) VALUES
(1, 'moove_gdpr_nonce', 's:1:\"1\";', 1, NULL),
(2, '_wp_http_referer', 's:1:\"1\";', 1, NULL),
(3, 'moove_gdpr_brand_colour', 's:1:\"1\";', 1, NULL),
(4, 'moove_gdpr_brand_secondary_colour', 's:1:\"1\";', 1, NULL),
(5, 'moove_gdpr_company_logo', 's:1:\"1\";', 1, NULL),
(6, 'moove_gdpr_logo_position', 's:1:\"1\";', 1, NULL),
(7, 'moove_gdpr_button_style', 's:1:\"1\";', 1, NULL),
(8, 'moove_gdpr_plugin_font_type', 's:1:\"1\";', 1, NULL),
(9, 'moove_gdpr_plugin_font_family', 's:1:\"1\";', 1, NULL),
(10, 'moove_gdpr_cdn_url', 's:1:\"1\";', 1, NULL),
(11, 'moove_gdpr_infobar_visibility', 's:1:\"1\";', 1, NULL),
(12, 'moove_gdpr_reject_button_enable', 's:1:\"1\";', 1, NULL),
(13, 'moove_gdpr_colour_scheme', 's:1:\"1\";', 1, NULL),
(14, 'moove_gdpr_info_bar_content', 's:1:\"1\";', 1, NULL),
(15, 'moove_gdpr_infobar_accept_button_label', 's:1:\"1\";', 1, NULL),
(16, 'moove_gdpr_infobar_reject_button_label', 's:1:\"1\";', 1, NULL),
(17, 'moove_gdpr_infobar_position', 's:1:\"1\";', 1, NULL),
(18, 'moove_gdpr_strictly_necessary_cookies_functionality', 'i:1;', 1, NULL),
(19, 'moove_gdpr_strictly_necessary_cookies_tab_title', 's:1:\"1\";', 1, NULL),
(20, 'moove_gdpr_strict_necessary_cookies_tab_content', 's:1:\"1\";', 1, NULL),
(21, 'moove_gdpr_strictly_necessary_cookies_warning', 's:1:\"1\";', 1, NULL),
(22, 'moove_gdpr_modal_strictly_secondary_notice', 's:1:\"1\";', 1, NULL);

Somehow all values become 's:1:\"1\";', so practically all GDPR Cookie Compliance settings get lost.

It happens regardless whether I do the replace on the whole database or just on the wp_gdpr_cc_options table.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant