WordPress.org

Ready to get started?Download WordPress

Forums

IP Blacklist Cloud
[resolved] IP status not updated (32 posts)

  1. charlievie
    Member
    Posted 1 year ago #

    I installed the latest version (1.5) today and I realized that before the update there was this field IP:Neutral which changed to IP:Blacklisted of IP:Blocked after the IP was blacklisted. IN 1.5 this field doesn't change anymore. The IP stays always Neutral, no matter if it is blacklisted or not.

    Please fix. Thanks.

    Blessings.
    -= Charlie =-

    http://wordpress.org/extend/plugins/ip-blacklist-cloud/

  2. ad33lx
    Member
    Plugin Author

    Posted 1 year ago #

    Hi,

    I have checked it with WP 3.4 and then 3.5 it is working fine charlievie.
    Screenshot: http://ip-finder.me/working_fine.png

    There are two options now, Blacklist IP and Blacklist Username.
    You can also check in IP Blacklist menu how many times visitor or spammer has visited the website after being blocked.

    Are you using any other plugin for IP Blacklist?

  3. ad33lx
    Member
    Plugin Author

    Posted 1 year ago #

    Problem solved?

  4. charlievie
    Member
    Posted 1 year ago #

    Sorry no it isn't. I appreciate your screen shot, but it looks like I still do have the problem.
    I made a short clip, so you can at least visually see what's going on.

    http://youtu.be/QEclSG2bM-0

    Towards the end of the clip I show the IP Blacklist and as you can see, today is 12/21/2012 and the last IP added to that list was 12/17/2012. That was the day before I upgraded to the new version.

    Let me know if I can assist you with any more information.

    Blessings
    -= Charlie =-

    PS: I also just updated to V1.6 (that was after the video), but the status is the same, it doesn't add the IP to the IP Blacklist and the IP remains Neutral.

  5. ad33lx
    Member
    Plugin Author

    Posted 1 year ago #

    Hey,

    The problem is... I am not able to view youtube.com it is blocked in our country :/
    Can you mail me video directly at ad33l@live.com ?

    Charlievie, if you add username to blacklist, is it also creating problem? not changing from neutral to blacklist?

    -Are you using default comments page? i.e. edit-comments.php?
    -What about adding IP address manually?
    -Are you using any other IP blocking plugin, if so, can you tell me the name so that I can download it and find out if the coding are conflicting?
    -Using firewall plugin or something? Because they block GET fields from url. Example: http://example.com/wp-admin/edit-comments.php?blacklist=0.0.0.0

    GET field: blacklist

    I need to know these things so that I can find the exact bug in plugin.

    Thank you so much for informing about the problem :)

  6. ad33lx
    Member
    Plugin Author

    Posted 1 year ago #

    Okay finally somehow I am able to view video. Please wait.. Let me find out the bug.

  7. ad33lx
    Member
    Plugin Author

    Posted 1 year ago #

    Hello again :)

    Well, I have modified INSERT query for IP and USERNAME and uploaded the zip file here: http://ip-finder.me/v1.6_charlievie.zip

    Download, unzip and then replace "ip-blacklist-cloud" on FTP under wp-content/plugins/

    Please let me know if it is working now.

    Thanks,
    Adeel

  8. charlievie
    Member
    Posted 1 year ago #

    Adeel,

    I just sent you the video, I didn't see you already provided a fix. I will upload and test it sometime this evening or tomorrow (Sat 12/22/2012).

    God Bless and thanks, I will keep you posted about the outcome of the test.

    -= Charlie =-

  9. ad33lx
    Member
    Plugin Author

    Posted 1 year ago #

    Charlie,

    I have made a fix with $wpdb query and I hope it is working now :)

    Regards,
    Adeel

  10. charlievie
    Member
    Posted 1 year ago #

    Adeel,

    Couldn't make time today to test you changes, but I will have some time tomorrow (Sunday). I will let you know if the fix worked as soon as I tested it.

    Blessings
    -= Charlie =-

  11. ad33lx
    Member
    Plugin Author

    Posted 1 year ago #

    Sir,

    Any updates? :)

    Regards,
    Adeel

  12. charlievie
    Member
    Posted 1 year ago #

    Good morning Adeel,

    My apologies for taking longer than I thought. I just ran a few tests with the new version you provided to me in the this blog. Unfortunately, it doesn't fix the problem at all.

    I tried a view more things and hope they might help you in locating the bug.

    1. I Clicked on the link Blacklist IP on the comments page and it didn't work
    2. I Clicked on the link Blacklist Username and it didn't work either.
    3. Then I tried to add the IP Adress manually and that would work either. No error messages, just the IP Address was not added to the list

    But when I click on IP Detail the IP Address is on your website and it shows that I blocked it, because my website is listed where it says blocked by or something like that.

    Maybe that might help you to narrow it down a little.

    Blessings
    -= Charlie =-

  13. charlievie
    Member
    Posted 1 year ago #

    Adeel,

    I just realized that another plugin stopped working on Dec 21, the same day your plugin stopped working. It's called Piwik. Here is the link to it http://wordpress.org/extend/plugins/wp-piwik/

  14. charlievie
    Member
    Posted 1 year ago #

    Never mind my last post ... I found the reason why Piwik didn't work. I password protected the installation directory. That was my fault.

  15. ad33lx
    Member
    Plugin Author

    Posted 1 year ago #

    Hi,
    I am trying to figure out things for you. you mentioned about installation directory is password protected. Can you please check the IP Blacklist Cloud directory as well?

    The only problem you are facing is "Handling with MySQL". it seems like your WordPress is not allowing to edit anything in Database.

    Please check on your end. :)
    Thanks.

  16. ad33lx
    Member
    Plugin Author

    Posted 1 year ago #

    "But when I click on IP Detail the IP Address is on your website and it shows that I blocked it...."

    Now I am quite sure that my plugin is now restricted to deal with Database. I am using $wpdb queries to connect with SQL.

    I have checked my plugin with other IP blacklisting plugins and it is not conflicting with them.

    Regards,
    Adeel

  17. charlievie
    Member
    Posted 1 year ago #

    Adeel,

    I checked on the directory permissions and they are OK. I tried to see if I can access the DB by changing a page/post and that worked. So the access to the DB is OK, for some reason your plugin doesn't write into the table anymore. I also tried to logon to the DB with the user that is configured in the wp-config.php and that works, too. I even added an IP address with phpMyAdmin without a problem.

    So I don't know exactly in what file you are writing into the DB, but maybe you can take a look at that part.

    All other plugins can access the DB without any problems. Anything I can check on my server that might help you?

    Blessings
    -= Charlie =-

  18. ad33lx
    Member
    Plugin Author

    Posted 1 year ago #

    Hi,

    Thanks for providing more information. Really appreciated :)
    As you mentioned earlier that 1.4 was working fine, can you please download it from here http://ip-finder.me/v1.4.zip and then upload the contents directly via FTP to the plugin directory? But please make sure you delete all files of v1.6. Do not override just upload files separately and then check the plugin if it is working on not.

    Thank you so much for everything. :)

    Regards,
    Adeel

  19. charlievie
    Member
    Posted 1 year ago #

    Adeel,

    I finally had a few moments to go back to v1.4.

    I did as you requested and removed the files from the folder, then copied the files from v1.4 into the plugin folder and tested it and it still doesn't work.

    I think our best shot would be if you would implement a debug option that can be turned on by the user and that writes out a logfile which then can be analyzed. You should focus on the DB access functions and check their return value and log those in that file. I think that's the only way to find the problem. I have not updated any other plugin that day, only yours, so I am not sure what could have caused the problem, but I will try to help you as much as I can.

    God Bless

    -= Charlie =-

  20. ad33lx
    Member
    Plugin Author

    Posted 1 year ago #

    Hello Charlie,

    I asked you about v1.4 is because I need to know if the problem is with plugin or DB and it clearly shows that your WordPress is not allowing this plugin to edit DB

    About debug option, I will surely add this in upcoming version, thank you for the idea :)

    http://ip-finder.me/v1.6_charlievie.zip

    Here is v1.6 but I have added wpdb print_report in two files.
    Upload these files and try to block ip or username from the option page not from comments page.
    i.e. IP Blacklist->Add IP to Blacklist

    If it shows any error, please let me know.

    Thanks alot.

    Regards,
    Adeel

  21. charlievie
    Member
    Posted 1 year ago #

    Adeel,

    I apologize for the delay. Got really busy here in the office. I will download v1.6 right now and see if that works. I let you know about the result.

    Blessings

    -= Charlie =-

  22. charlievie
    Member
    Posted 1 year ago #

    OK Adeel,

    I did as you asked. I installed v1.6 by removing all the files from the IP-Blacklist-Cloude directory and then I copied the v1.6 files into that directory.
    I added an IP address from the option page and I did not get any error messages. Here is what the result page gave me:

    Add IP to Blacklist

    NOTE: After adding any IP to blacklist, please submit comment on IP-FINDER.ME to help others regarding the issue related to that specific IP.

    173.248.130.102 added to blacklist successfully!

    Let me know if you need anything else. I'd really love to get this working again.

    Blessings

    -= Charlie =-

  23. ad33lx
    Member
    Plugin Author

    Posted 1 year ago #

    :(

    I don't know why it is not adding to your database and also not showing any error of wpdb query...

    I have to look into this in more detail.

    Thanks for the details.

    Regards,
    Adeel

  24. ad33lx
    Member
    Plugin Author

    Posted 1 year ago #

    Hi Charlie,

    Sorry for the late reply. I was working on other project and also tried to figure out problem.

    I just came to know "Storage Engine" can create a problem in MySQL.

    In phpmyadmin, please check "wp_IPBLC_blacklist" engine type by selecting "Operations" tab? If it is not MyISAM, please change it to that and let me know if problem is still there.

    I will start working on version 1.7 very soon with new functions.

    Regards,
    Adeel

  25. charlievie
    Member
    Posted 1 year ago #

    Hi Adeel,

    I changed the engine, but same result. I actually added an IP manually with phpmyadmin to see if it would show as blocked in the comments, and that worked. So you can obviously read from the DB, but for some reason can't write.

    Maybe that helps.

    Let me know when you have something else to try. I would really to get this plugin working again.

    Thanks and Blessings.
    -= Charlie =-

  26. charlievie
    Member
    Posted 1 year ago #

    ... oh one more thing ... I realized that you wrote the name of the table like this "wp_IPBLC_blacklist", but in the DB the name is like this "wp_ipblc_blacklist". I know PHP is normally case sensitive, but I'm not sure if that also goes for SQL functions. Might want to check that out.

    Blessings
    -= Charlie =-

  27. ad33lx
    Member
    Plugin Author

    Posted 1 year ago #

    Oh.. that lower case stuff is because of MySQL settings and I dont know how to handle that because it is related to my.ini which is MySQL settings.

    I am sorry but I think I did reply to your message but I didnt :/

    Can you please wait for V1.7? Because the only alternative left is to delete DB tables but before that, you must create a backup and for that I have "Premium Cloud Account" option which I turned off for registration because some people you applied for trial version are facing problems with plugin so I am fixing all the stuff in one go for V1.7.

    Sir, so sorry for inconvenience but I really appreciate about your feedback :)
    Thank you sooo much for your support Mr. Charlie :)

    Regards,
    Adeel

  28. ad33lx
    Member
    Plugin Author

    Posted 1 year ago #

    Hi,

    Version 1.7 has been released please update and check if you are still facing same problem.

    Please update me :)

    Thanks,
    Adeel

  29. charlievie
    Member
    Posted 1 year ago #

    Adeel,

    I am sorry that I have to tell you that the problem is still persisting. I install 1.7, but nothing changed. Not sure what to do from here on.

    Blessings
    -= Charlie =-

  30. ad33lx
    Member
    Plugin Author

    Posted 1 year ago #

    Hi Charlie,

    Oh thats bad! Can you do one last thing? Export file from settings (CSV) and make sure data is in file.
    Disable and detele plugin.
    Delete plugin Database (IP and username)
    download and re-install plugin and activate
    Import that file.

    Let me know after doing this plugin is working or not.

    Regards,
    Adeel

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic