There is one bug that just beats me and I would like to know if anyone can replicate this.
The last query which is execute after the plugin is updated (it is updated when you see the popup) is supposed to clean up all extra fields in the privacy policy tab. This query is like:
[code:1]
delete from #__comprofiler_fields, #__comprofiler_field_values
using #__comprofiler_fields, #__comprofiler_field_values, #__comprofiler_tabs
where #__comprofiler_fields.fieldid=#__comprofiler_field_values.fieldid
and #__comprofiler_fields.tabid={a tab id}
and #__comprofiler_fields.name=concat("cb_privacypolicy_",#__comprofiler_tabs.tabid)
and not #__comprofiler_tabs.pluginclass="privacyPolicy"
[/code:1]
The problem is that it does nothing, but if you put your site to debug and copy paste this query from your debug information to phpMyAdmin, it works perfectly. I just cannot figure ouy why and would appreciate if
-someone can replicate this on their server
-someone can tell me what goes wrong here
mikko
