AbuseIPDB Integration module

[marcopolo]

New Release: AbuseIPDB v4.0.6

🚨 What’s New:

v4.0.6: Improved session rate limiting by using a new abuseipdb_actions table to queue IPs for blocking, reducing .htaccess write delays and preventing duplicate log entries.

Download the latest version and check out the full details on [GitHub](https://github.com/CcMarc/AbuseIPDB/releases/tag/v4.0.6)!

[HeathenMagic]

hello there,
Thanks for this module, you recommended. I get the following error log from whos online:-

Table '****_zen.zen_abuseipdb_cache' doesn't exist'

I renamed the four databases and put zen_ in front, that error goes and whos online works. Just wondering, if I did right doing the other three tables the same? Thanks :-)

EDIT I renamed back as it seems to stop the site working, so I turned off abuseipdb for now. On 4.06 version. I think I am not the norm in having zen_ prefix, which I have had this issue before actually.

[marcopolo]

hello there,
Thanks for this module, you recommended. I get the following error log from whos online:-

Table '****_zen.zen_abuseipdb_cache' doesn't exist'

I renamed the four databases and put zen_ in front, that error goes and whos online works. Just wondering, if I did right doing the other three tables the same? Thanks :-)

EDIT I renamed back as it seems to stop the site working, so I turned off abuseipdb for now. On 4.06 version. I think I am not the norm in having zen_ prefix, which I have had this issue before actually.

I've just released v4.0.8, which adds full support for Zen Cart table prefixes via the DB_PREFIX constant. You no longer need to rename any database tables manually — in fact, doing so will cause the module to break.

To fix the issue:

Revert the following database tables back to their original names — or simply delete them. The installer will automatically recreate them during the upgrade:

abuseipdb_cache
abuseipdb_flood
abuseipdb_maintenance
abuseipdb_actions

Download and install the updated v4.0.8 module (available on GitHub - Download v4.0.8).

The module now automatically adapts to your store’s prefix settings, and the “table doesn’t exist” error should be fully resolved.

Let me know if you run into anything else — I appreciate the feedback!

[HeathenMagic]

I've just released v4.0.8, which adds full support for Zen Cart table prefixes via the DB_PREFIX constant. You no longer need to rename any database tables manually — in fact, doing so will cause the module to break.

To fix the issue:

Revert the following database tables back to their original names — or simply delete them. The installer will automatically recreate them during the upgrade:

abuseipdb_cache
abuseipdb_flood
abuseipdb_maintenance
abuseipdb_actions

Download and install the updated v4.0.8 module (available on GitHub - Download v4.0.8).

The module now automatically adapts to your store’s prefix settings, and the “table doesn’t exist” error should be fully resolved.

Let me know if you run into anything else — I appreciate the feedback!

Thanks for the update. I deleted the tables first, uninstalled, then installed 4.0.8 via plugin manager. Unfortunately, I still get a similar error:-

PHP Fatal error: MySQL error 1146: Table '****.zen_abuseipdb_actions' doesn't exist :: SELECT ip FROM zen_abuseipdb_actions ==> (as called by) /zc_plugins/AbuseIPDB/v4.0.8/catalog/includes/classes/observers/abuseipdb_observer.php on line 92 <== in /includes/classes/db/mysql/query_factory.php on line 733.

Maybe it is my setup? The tables are without prefix, I can see 4. They are at top of list as they are alphabetically first. Hope this helps.

[marcopolo]

Thanks for the update. I deleted the tables first, uninstalled, then installed 4.0.8 via plugin manager. Unfortunately, I still get a similar error:-



Maybe it is my setup? The tables are without prefix, I can see 4. They are at top of list as they are alphabetically first. Hope this helps.

I've updated the installer — I had missed a section.
Please re-download the latest ZIP for v4.0.8 — the fix is included now. Let me know if anything else comes up!

[marcopolo]

I've updated the installer — I had missed a section.
Please re-download the latest ZIP for v4.0.8 — the fix is included now. Let me know if anything else comes up!

To fix the issue:

First, uninstall the current AbuseIPDB plugin.

Then re-download the latest ZIP for v4.0.8 — the fix is included now. (I had missed a section)

The new installer will automatically create the correct tables using your database prefix.

You can safely delete the old tables (the ones without the prefix), as they are no longer used if they are still there.

[HeathenMagic]

To fix the issue:

First, uninstall the current AbuseIPDB plugin.

Then re-download the latest ZIP for v4.0.8 — the fix is included now. (I had missed a section)

The new installer will automatically create the correct tables using your database prefix.

You can safely delete the old tables (the ones without the prefix), as they are no longer used if they are still there.

Thats great! I can confirm it is all working perfectly. I have enabled most of the settings that I understand, octet, flood, and session rate limiting. I think the module doesn't automatically block the IP, I refer to whos online and add to the blacklist text file? I have started doing that, and enabled the blacklist execution anyway.