Fosters Posted June 8, 2018 Posted June 8, 2018 https://invisioncommunity.com/files/file/9017-gdpr-compliance/ Roadmap: Include Support for all our other released apps and plugins, so that they can register their database tables and columns where IP Addresses are logged
Michael Grote Posted June 9, 2018 Posted June 9, 2018 Is there anything to configure related to this tool?
derpunker Posted June 9, 2018 Posted June 9, 2018 Hello, First of all, I would like to say thank you for this plugin ?? I reviewed it and I think that there are still two tables left, where the IP addresses are not deleted. core_members_known_ip_addresses -> there is a association between IP address and member_id core_members -> there is the "joined" IP address saved It would be nice if the plugin would clean up these tables too. Fosters 1
Fosters Posted June 10, 2018 Author Posted June 10, 2018 11 hours ago, Michael Grote said: Is there anything to configure related to this tool? No, there are no settings yet, this application uses the default IP address prune setting from IPS . Quote This will remove IP addresses from user posted content after the specified number of days 8 hours ago, derpunker said: Hello, First of all, I would like to say thank you for this plugin ?? I reviewed it and I think that there are still two tables left, where the IP addresses are not deleted. core_members_known_ip_addresses -> there is a association between IP address and member_id core_members -> there is the "joined" IP address saved It would be nice if the plugin would clean up these tables too. Thanks. A new version was uploaded to the Marketplace addressing this 2 issues:) derpunker 1
derpunker Posted June 10, 2018 Posted June 10, 2018 (edited) I think there is a little problem. When running the task, i got this error: The database column for timestamp in the table core_members_known_ip_addresses is named "last_seen". I have changed the column name temporary in the filesystem and after the change I got this error: Cleaning this table seems not to be so easy. The column "ip_address" is marked as ip_address "UNIQUE" und a lot of empty strings are not unique ? What do you think about removing the whole database row instead of cleaning only the ip_address field? I new version would be nice. All other tables are cleaned as expected. Edited June 10, 2018 by derpunker
Fosters Posted June 10, 2018 Author Posted June 10, 2018 Sorry for this quick and dirty, untested weekend release:( Back to the drawing board:)
derpunker Posted June 11, 2018 Posted June 11, 2018 10 hours ago, Michael Grote said: same problem here ? A new version is released.
Michael Grote Posted June 20, 2018 Posted June 20, 2018 (edited) Hi, I installed version 1.0.5. one week ago. The ACP setting (Remove IP addresses after) is set to 90 days. When looking at the IP addresses belonging to a member (via ACP -> Member -> <selecting a member> -> View all IP Addresses) there are still a lot of members with IP addresses older than the 90 days threshold (even back to 1999). Edited June 20, 2018 by Michael Grote
Fosters Posted February 23, 2019 Author Posted February 23, 2019 A new version was released. Changehistory Quote IPS 4.4.0 compatibility release
derpunker Posted March 9, 2019 Posted March 9, 2019 Thx for the IPS4.4 release 🙂 I found some files where the '\' is missing in the file header. if ( !\defined( '\IPS\SUITE_UNIQUE_KEY' ) ) { header( ( isset( $_SERVER['SERVER_PROTOCOL'] ) ? $_SERVER['SERVER_PROTOCOL'] : 'HTTP/1.0' ) . ' 403 Forbidden' ); exit; }
derpunker Posted March 19, 2019 Posted March 19, 2019 (edited) I found a new bug: ==> the task is not running! The database column is named "last_seen". The column id was changed in the last updated (1.1.0), which seems to be a mistake. Edited March 19, 2019 by derpunker
jamesluck01 Posted March 25, 2019 Posted March 25, 2019 On 6/8/2018 at 11:01 AM, Fosters said: https://invisioncommunity.com/files/file/9017-gdpr-compliance/ Roadmap: Include Support for all our other released apps and plugins, so that they can register their database tables and columns where IP Addresses are logged I purchased this and I am now being told I need to re-purchase it. I have a paypal receipt / transaction but no access to download the file. @Fosters
Michael Grote Posted July 17, 2019 Posted July 17, 2019 Hi, after the upgrade to IPS 4.4.4 with the actual GDPR CompliIance the tasks fails with Exception: IPS\Db\Exception Object ( [query] => DELETE FROM `ibf_core_members_known_ip_addresses` WHERE time<=1555573982 [binds] => Array ( ) [message:protected] => Unknown column 'time' in 'where clause' [string:Exception:private] => [code:protected] => 1054 [file:protected] => /var/customers/webs/mgfvlw/test/system/Db/Db.php [line:protected] => 631 [trace:Exception:private] => Array ( [0] => Array ( [file] => /var/customers/webs/mgfvlw/test/system/Db/Db.php [line] => 1280 [function] => preparedQuery [class] => IPS\_Db [type] => -> [args] => Array ( [0] => /*IPS\gdprannoyance\tasks\_pruneOtherIpAddresses::execute:255*/ DELETE FROM `ibf_core_members_known_ip_addresses` WHERE time<=1555573982 [1] => Array ( ) ) ) [1] => Array ( [file] => /var/customers/webs/mgfvlw/test/applications/gdprannoyance/tasks/pruneOtherIpAddresses.php [line] => 86 [function] => delete [class] => IPS\_Db [type] => -> [args] => Array ( [0] => core_members_known_ip_addresses [1] => Array ( [0] => time<=1555573982 ) ) ) [2] => Array ( [file] => /var/customers/webs/mgfvlw/test/system/Task/Task.php [line] => 255 [function] => execute [class] => IPS\gdprannoyance\tasks\_pruneOtherIpAddresses [type] => -> [args] => Array ( ) ) [3] => Array ( [file] => /var/customers/webs/mgfvlw/test/system/Task/Task.php [line] => 224 [function] => run [class] => IPS\_Task [type] => -> [args] => Array ( ) ) [4] => Array ( [file] => /var/customers/webs/mgfvlw/test/applications/core/interface/task/task.php [line] => 62 [function] => runAndLog [class] => IPS\_Task [type] => -> [args] => Array ( ) ) ) [previous:Exception:private] => ) Any ideas? Michael
derpunker Posted July 17, 2019 Posted July 17, 2019 (edited) I think it's the same problem like here On 3/19/2019 at 11:20 PM, derpunker said: I found a new bug: ==> the task is not running! The database column is named "last_seen". The column id was changed in the last updated (1.1.0), which seems to be a mistake. Meanwhile I fixed it by my self, because no patch was provided. Edited July 17, 2019 by derpunker
Michael Grote Posted July 17, 2019 Posted July 17, 2019 @derpunkerthanks for the advice. I fixed it directly in the system source and it's fine now @Fostersplease provide a fixes new version Regards Michael
derpunker Posted June 22, 2020 Posted June 22, 2020 Is there a compatible version for IPS 4.5.x planned?
Fosters Posted June 22, 2020 Author Posted June 22, 2020 51 minutes ago, derpunker said: Is there a compatible version for IPS 4.5.x planned? Of course ! derpunker 1
derpunker Posted June 22, 2020 Posted June 22, 2020 1 minute ago, Fosters said: Of course ! Very good. 👍 Please be so kind and fix this issue here too
derpunker Posted August 25, 2020 Posted August 25, 2020 Is there a roadmap when this IPS 4.5 compatible version will be released?
derpunker Posted September 7, 2020 Posted September 7, 2020 No answer? I'm waiting for a feetback to plan the upgrade of my comminuty suite and this is app is needed before. Thx.
derpunker Posted September 11, 2021 Posted September 11, 2021 @Fosters New version has the same error as the old version. Unfortunately not usable. Please see here: On 3/19/2019 at 11:20 PM, derpunker said: I found a new bug: ==> the task is not running! The database column is named "last_seen". The column id was changed in the last updated (1.1.0), which seems to be a mistake.
Recommended Posts