After updating plugin - PDOException: SQLSTATE[23000]: Integrity constraint violation

This issue is happening on my sites as well. We had the issue crop up last week. This issue completely disables the entire website, erroring out any attempt at new content. There is a similar error that affects comments as well, pretty much rendering the entire website useless :(

I did truncate the tables as suggested above. I run about 30 websites and all of them were having this issue. I truncated their ip_posts tables last week. We are already having occurrence of this issue. I have truncated two tables this morning and will likely just go through and truncate each sites' ip_posts table again so they do not lose functionality.

This is a major major bug. Please let me know what I can provide to you to help with resolving it.

Here is one of our most recent error messages from this morning:

PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '25922-node' for key 'PRIMARY': INSERT INTO {ip_posts} (type, id, ip) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2); Array ( [:db_insert_placeholder_0] => node [:db_insert_placeholder_1] => 25922 [:db_insert_placeholder_2] => 1827252900 ) in ip_posts_insert() (line 162 of /home/heather/public/yourcitymommies.com/public/sites/all/modules/ip/ip.module).

I cleaned out the ip_post tables last week after posting my comment above. We started getting the error again today, so I had to truncate that table again. Is anyone else experiencing this error? It basically stops any new content from being created until the table is cleaned out again.

Thanks
Heather

Blog and comment modules are enabled and working fine in my Drupal 7.34 site,but after 1 month when users are trying to post comments it shows errors:
PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry for key 'PRIMARY': INSERT INTO {ip_posts} (type, id, ip) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2); Array ( [:db_insert_placeholder_0] => comment [:db_insert_placeholder_1] => 3 [:db_insert_placeholder_2] => 1868414682 ) in ip_posts_insert() (line 330 of sites\all\modules\ip\ip.module).
The website encountered an unexpected error. Please try again later.

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'cache_rules' doesn't exist: TRUNCATE {cache_rules} ; Array ( ) in cache_clear_all() (line 167 of \includes\cache.inc).

I am using many ip address related modules like IP,IP_RANGES,IP2COUNTRY to ban access to a Country/single IP-address. Truncating "ip_posts" table will fix the issue?

This error still happens frequently on my network of drupal websites -- I have had to truncate the table twice this week to allow people to be able to add content on our websites.

Is there any resolution for this bug?

Please, could you try with the last 7.x-2.x version? I think that the cron process was involved which is now removed.

I just wanted to come back and report that I am using the 7.x-2.x-beta1 version on my websites and I am still experiencing this issue. The only way to resolve it is to run a truncate command on the ip_posts table. It does stop anyone from posting or commenting until the table is truncated.

Same errors with 7.x-2.x-beta1.

This module doesn't handle node deletion properly because it does not know when nodes are deleted.
Try adding this to ip.module:

----------------------------------------------------------------------------------------
/**
* Implements hook_node_delete()
*/
function ip_node_delete($node) {
db_delete('ip_posts')->condition('id', $node->nid)->execute();
}
----------------------------------------------------------------------------------------

This should prevent the problem from reoccurring.

To stop an existing issue, you can truncate the ip_posts table, or you can just delete any IDs at and above the ID giving the issue:
DELETE FROM ip_posts WHERE id>=1066;

EDIT: Another issue is that the ip_posts table also tracks comments, so when a node is deleted, the comments for that node need to be deleted too. The MySQL way to delete the comment entries in ip_posts is:

DELETE FROM ip_posts WHERE id IN (SELECT cid FROM comments WHERE nid={$node->nid});

I could write the code to do that the Drupal Way, but to be frank I really don't see why I should bother since it's obvious the developer has abandoned this module.