Support » Plugin: WP Activity Log » Duplicate log entries

  • Resolved OnePressTech

    (@timhibberd)


    On the latest version 2.6.1 when I sort on IP address I notice that all entries have one or more duplicates. Identical entries with identical timestamps. This is not an inconsistent effect…EVERY entry is duplicated.

    Duplicate Bug Screenshot

Viewing 15 replies - 1 through 15 (of 19 total)
  • Thread Starter OnePressTech

    (@timhibberd)

    NOTE: This is a multi-site installation with the plugin network enabled.

    Moderator Jan Dembowski

    (@jdembowski)

    Forum Moderator and Brute Squad

    *Looks*

    Side note and off topic: This is probably not going to be responded well too and yes, this is a canned reply. This happens a lot.

    We’d like to be given temporary access to do some testing.

    @wpwhitesecurity I’ve deleted your offer to login to your user’s site. I’m am 100% sure you mean well but please never ask for credentials on these forums.

    http://codex.wordpress.org/Forum_Welcome#The_Bad_Stuff

    Now for the why: The internet is a wonderful place full of very nice people and a few very bad ones. I’m sure everyone here is very nice however, by giving some ones keys to your house you are trusting they wont steal anything. Likewise the person who takes the keys is now responsible for the house FOREVER.

    If something was to go wrong, then you the author may well legally become liable for damages, which they would not normally have been as their software is provided without warranty.

    Please be aware that repeatedly asking for credentials will result in us asking you to repeatedly stop before escalating up to the plugins team.

    There are many ways to get information you need and accessing the user’s site is not one of them. That’s going too far.

    You get the idea.

    Volunteer support is not easy. But these forums need to a safe place for all users, experienced or new. Accessing their system that way is a short cut that will get you into real trouble in these forums.

    Thread Starter OnePressTech

    (@timhibberd)

    Cheers Jan…I was going to say no to the request anyway 🙂

    I agree with you. I find too many theme and plug-in authors jump immediately to the “give me credentials” request.

    I’m actually a tech-savvy user so if the author wants to point me at a likely section of the code I can add some extra debugging to try to narrow down the problem area.

    To be honest I would think that locating a duplicate display entry would be reasonably straight forward from a code analysis perspective.

    I guess we’ll find out 🙂

    Plugin Author WPWhiteSecurity

    (@wpwhitesecurity)

    @jdembowski just wanted to point out that I never ask the users to post the credentials here but to contact us via email. We have always done so. It might have been that I forgot to mention the email part this time(which I doubt), but just in case, sorry if I did.

    @onepresstech if I knew from where the problem is originating I would gladly tell you for which part of the code to look for, since it would be way easier for me But unfortunately I do not know. And from my experience it is way more time and resource efficient for us to do some troubleshooting (without affecting the website) and pinpoint the problem than having to ping pong messages with logs, different builds, tests etc. If you prefer to go down that route, I’m more than happy to do so 🙂

    Moderator Jan Dembowski

    (@jdembowski)

    Forum Moderator and Brute Squad

    I may not have been clear and I want to clear this up.

    This is what was written.

    We’d like to be given temporary access to do some testing.

    Please do not make that request in these forums. It’s not that you asked them to post credentials in these forum (you clearly did not do that) it’s that you offered to get temporary access to their site.

    As I’ve explained above there’s lots you can do here. Requesting that access is going too far and not permitted here.

    Plugin Author WPWhiteSecurity

    (@wpwhitesecurity)

    @jdembowski ok got the point now. No problem and thank you for clearing it.

    @onepresstech I’ll prepare a debug build and will send you the URL so you can download it, reproduce the problem and send us the logs.

    Plugin Author WPWhiteSecurity

    (@wpwhitesecurity)

    Hello @onepresstech,

    From the screenshot you’ve sent in this post it seems that the duplicate entries are for failed logins. Can you please confirm if this applies to just alerts with a specific ID or it is happening for every alert generated?

    Looking forward to hearing from you.

    Thread Starter OnePressTech

    (@timhibberd)

    Yes…this effect applies to all entries regardless of type.

    Here are some other oddities I notice:

    1) In the initial screenshot I provided to you I am puzzled why the first IP address that appears when I click “sort by IP” is 31.207.194.33. This is clearly not the lowest IP address if you look at the following IP addresses in the screenshot

    2) I sorted by date and then paged to the location where the 02-22-2017
    6:46.251 AM 31.207.194.33 entry would be and….interesting…it is NOT displayed! See screenshot #2 below:

    So I did a database search on 31.207.194.33 and there were 6 entries in the database…but only 2 instances are displayed when I sort by IP address! So the plugin seems to have some orphaned entries in the database or entries with missing fields so you see some of the entries under one view and other entries under a different view.

    Can you please confirm that you have tried to reproduce this. I am assuming you run your own plug-in on your own company’s website. Do a sort by IP address and a database search on the IP address of the first entry displayed and see if the number of entries tally. I would be surprised if you can’t reproduce this. Cheers. Thanks for your help…it is much appreciated 🙂

    Bug screenshot - sort by date view

    Plugin Author WPWhiteSecurity

    (@wpwhitesecurity)

    Let’s start solving one problem at a time 🙂 At the moment we are looking at the duplicate entry issue. I think we will have something for you within a few hours. Will get back to you shortly.

    Thread Starter OnePressTech

    (@timhibberd)

    I provided the additional information to try to reduce your debugging burden. More info is usually better than less info.

    We have…
    a) The database has more entries for an IP address than are displayed in the IP sorted view
    b) The lead display entry on the IP address sorted view does not appear in the Date sorted view
    c) Duplicated entries in the IP sorted view but not in the date-sorted view

    I would suggest that you consider than these are not “different” problems but just different manifestations of the same logic bug. I could be wrong but it is a reasonable initial assumption. I am puzzled that you cannot reproduce this!

    I will defer to you on next steps you would like to take in solving this…I do appreciate your time investment…thanks in advance…much appreciated 🙂

    Plugin Author WPWhiteSecurity

    (@wpwhitesecurity)

    Hello @onepresstech,

    That is why I recommended looking into these issues one at a time, since most probably the issue you are seeing from the sorting etc is related to the fist issue. So if we solve the first issue the second issue might be solved as well.

    Thank you for all the information. Will get back to you shortly.

    Plugin Author WPWhiteSecurity

    (@wpwhitesecurity)

    Hello @onepresstech,

    Can you please export the tables of our plugin from your WordPress database and send them to us? The tables are:

    wp_wsal_metadata
    wp_wsal_occurrences
    wp_wsal_options

    Please note that these tables contain possible confidential / sensitive information such as usernames, IP addresses etc so you can either send it to us via email or password protect it and send us the password via email on support@wpwhitesecurity.com.

    Looking forward.

    Thread Starter OnePressTech

    (@timhibberd)

    Thanks guys but I don’t send credentials and I don’t send database dumps.

    I’ll obviously have to debug it myself when I get some spare time. Based on the data I sent you I’m pretty sure I can find the bug through code analysis. In the 35 years I have been shipping telecom firmware, software and internet software I have managed to solve every problem reported by my clients with no data, no login, and no client interactions…just the bug reports. Based on the problem manifestation I have recorded here I expect this to be pretty simple to solve through code analysis.

    Don’t think me unappreciative…you have my thanks and respect for providing a great open source plugin. It will just take me less energy to go into your code and find the bug then to follow the debug approach you are taking. No disrespect intended 🙂

    I’ll let you know the outcome when I get the time to solve the bug.

    Cheers

    Plugin Author WPWhiteSecurity

    (@wpwhitesecurity)

    Hello @onepresstech,

    We are asking for this data because we cannot reproduce the issue ourselves, hence we need more information from your end. If we were able to reproduce the issue it would have been much easier. Unfortunately it seems that this problem is specific to your setup, or setups which are similar to yours.

    We asked for the database dump to check if the duplicate entries are actually stored in the database or if the issue is related to the way the plugin is retrieving and showing the records. So can you please check if the duplicate entries are actually in the database or not?

    Looking forward.

    Thread Starter OnePressTech

    (@timhibberd)

    Cheers guys. I didn’t know you could not reproduce this. I asked twice but you never said you tried.

    I’m analysing the view source code. As the data I sent you indicated I doubt this is a duplicate data issue but rather a view issue. If this was a duplicate data issue we would see the duplicates in different views. In fact, as I said, we don’t see the entries in one view that we see in the other view.

    I’ll let you know what I find.

Viewing 15 replies - 1 through 15 (of 19 total)
  • The topic ‘Duplicate log entries’ is closed to new replies.