GDPR compliance alert

Sorry for that. I’ve tested it several times and it always worked for me. Now I’ve taken a closer look at the code and I think I found the problem. I have to test it first. But please deactivate the plugin once and activate it again. Upon activation a new check is done. This one should work correctly and the message should disappear. If my assumption is correct, then only the test at the end of the update process does not work correctly under certain conditions. Please let me know if this solves your problem in the meanwhile.

Hi Peter, thank you for your response. No need to apologise…

Unfortunately deactivating and re-activating the plugin fails to solve the issue. The alert is tenaciously remaining at the top of all the admin screens.

Then, honestly, I am at a loss…

Since you obviously know about MySQL can you please check if all values in column linklog_ip of the linklog table start with a minus sign?

Plus please check the value of swcc_linklog_gdpr_compliant in options table.

Hi Peter

There are a number of records that are blank in respect of the linklog_ip field. This is the same on our production server that is still running the older, pre GDPR compliant, version of the plugin.

The swcc_linklog_gdpr_compliant record in the options table has an option_value of 0 which seems to infer that it’s failed the check, possibly due to the blank fields? If you like I’ll back-up the database, delete the blank records and then see if an de-activate/re-activate clears the notice.

You are right, the 0 indicates that the check failed. Certainly the blank entries are the the reason. Deleting them surely solves the problem.

I have no idea where they come from. If the determination of the IP address fails it should be empty. I’m excluding empty IP addresses before insert. Could you please check if the fields are not empty but contain one or more blanks? Theoretically that should not be possible but if the address only contains blanks it is obvious that my check would fail. If you could confirm that there are blanks in it I would adjust the check to avoid IP addresses containing blanks.

Thank you in advance.

Regards,
Peter

Hi Peter. No spaces, the apparently blank fields are just that, no content, not even a space character. In essence Null.

—
Regards, Chas

Sorry for the delay, I had no time…

Have you deleted the entries in the meantime?

Although I have no idea why those exist – but maybe others have the same problem. So I will exclude Null values from the test. I could provide a new version at short term and would be glad if you’d test it.

Peter

Hi Peter

Thank you for your response. Time is a rare commodity… I suffer from that problam too.

No, I didn’t delete the entries, just changed swcc_linklog_gdpr_compliant value to 1 which removed the alert.

Happy to test a beta of a revised plugin for you. I would need to extract the relevant table from the live site which is still currently non compliant/un-hashed.

—
Regards, Chas

Hi Chas,

because the change is so small, I think there is no need to create a beta version. I’ve manually created empty entries in my testing database to test the changes. Everything worked fine in my tests. So I’ve finished version 4 and uploaded it already. Please test the final version 4 just to be sure…

Thanks,
Peter