• Hi!

    I get the following error in a regular basis:
    [03-Nov-2016 14:46:59 UTC] WordPress-Datenbank-Fehler Duplicate entry ‘0’ for key ‘PRIMARY’ für Abfrage INSERT INTO wp_pike_firewall_single_ip (ip) VALUES [many values] von do_action(‘wp_ajax_pike_firewall_ajax’), call_user_func_array, ajax_scan, pike_firewall_table_update_check, pike_firewall_fill_table

Viewing 14 replies - 1 through 14 (of 14 total)
  • Plugin Author hqpeak

    (@hqpeak)

    Hi could you tell me the version of the plugin you use? Try deactivate / activate to check if issue fixes, if not then if you use the latest version I’ll guide you haw to fix the issue.

    Thread Starter Sabine Jakubinek

    (@sjakubinek)

    Thanks for your reply.

    I can’t tell you which of the four WordPress sites are having this error. But I was updating all of them yesterday, including your plugin, WordPress itself and other plugins. As in all blogs your plugin was configured with logging on and deleting all entries wasn’t possible (CSRF detected error), I deactivated and after it reactivated all of them. Also I reconfigured them. After this I found the above error appearing from time to time.

    Plugin Author hqpeak

    (@hqpeak)

    maybe ipv6 request ?

    Plugin Author hqpeak

    (@hqpeak)

    No matter, I’ll push update right now for situations like this one, but probably is ipv6 and we doesn’t support that type of ip addresses yet ??

    Plugin Author hqpeak

    (@hqpeak)

    Updated, try the new update + you have extra features there as white listing ??

    Thread Starter Sabine Jakubinek

    (@sjakubinek)

    Sorry for the late answer.
    We have at least 4 sites on our server which are using your plugin and still we’re encountering this error. In none of the access logs we were able to find an IPv6 request. :/

    Plugin Author hqpeak

    (@hqpeak)

    We have found the issue. It is our design issue e.g. multiple updates of the sources at the same time. We will push update regarding this asap e.g. today.

    Thanks!

    Plugin Author hqpeak

    (@hqpeak)

    Check version 1.3.3 It is fixed and thx for reporting!

    Thread Starter Sabine Jakubinek

    (@sjakubinek)

    Sorry to say, but it’s getting worse. The function ajax_scan() in pikefirewall.php is called when someone gets into the plugin page. Which is AFAIK ok. But pls have a look at line 1744 where a file_put_contents took its place. We don’t have any directory like this. So we get an error: “[28-Nov-2016 10:43:40 UTC] PHP Warning: file_put_contents(/var/www/html/b-press/wp-content/plugins/pike-firewall/time_pre.txt): failed to open stream: No such file or directory in […]”
    As the mentioned problem wasn’t fixed and it’s getting worse we’re going to delete your plugin out of our blogs.

    Plugin Author hqpeak

    (@hqpeak)

    probably something else is causing problem, no such code in the plugin ??

    Thread Starter Sabine Jakubinek

    (@sjakubinek)

    Strange that I’ve found it in your code and could also mention the line. I do PHP for over 16 years for a living. I know what I’m talking about. Ofc it’s not in your code anymore. It was 4 weeks and propably many versions ago. Nice try ??

    Thread Starter Sabine Jakubinek

    (@sjakubinek)

    Check this and line 1744. Still visible for everyone that I wasn’t talking nonsense.

    Plugin Author hqpeak

    (@hqpeak)

    Thanks a lot, haven’t check the repo just local version… However sorry and many thx.
    This is my side project and I don’t put too many resources in it, so it happens…
    Will recheck everything today and put fixed version.

    Plugin Author hqpeak

    (@hqpeak)

Viewing 14 replies - 1 through 14 (of 14 total)
  • The topic ‘PHP error log’ is closed to new replies.