Getting error message in log

Thanks for the quick response. I ran the ‘Fix’ option straight away but they made no difference. I can confirm that I received your fixed file, have installed and run it, and it now works. There’s no error log to send.

It is similar to my first fix except I used a ‘1’ for the ‘visits’ field and the same timestamp for the ‘lastvisit’ field. I changed the database create value from varchar(500) to INT(200).

I then went a step further and inserted a few lines that read the login_failed table, listed the number of times that my selected IP address had attempted to login and took the timestamp from his last visit to enter into the missing fields. That worked too… unfortunately I never thought to back that up before overwriting with the version you’ve sent me. D’oh!

Ah well, that’ll give you something to do before you release the new bug-fixed version. ??

Many thanks for the very rapid response to my bug report and the opportunity to test it for you.

Hi,
Thank you so much for testing it and for your feedback.
I am still confused if that new file fixed the issue or not.
Actually plugin checks visits and lastvisit type and change it to int(50) or int(30) (don’t remember ritenow as I am out at the moment). So even if you change it to int(200) it will revert it back to int 30 or 50 (I have to double check it)
If that new file is not creating any issue please confirm I will re check 30 or 50 issue and will release new version.
Btw. You don’t have to worry about previous file because new version update will replace it.
I have to make sure there is no more DB issue.

-Adeel

Sorry, I wasn’t very clear before, too much going on in my head! The values for visits and lastvisit are of type INT(50), the value I changed was for timestamp which was originally set to VARCHAR(500). I notice now that this is set to VARCHAR(50) which certainly doesn’t cause any issues.

You may also wish to look at the create table code for the login_failed records as you are setting the useragent field to VARCHAR(500). I think that anything above VARCHAR(320) will generate an error as shown in earlier error log.

Other than that I think you’re good to go. ??

Hey,

Thanks alot for your feedback, I will update the issue and I might as you again to check it before launching new version.

Really appreciate for your help and taking time in testing it. ??

-Adeel

Hi,
Just sent you an email please check those files and let me know if things are working fine now.

-Adeel

Thanks – just updated and will let you know if I see any issues.Thanks for the fix!!

Hi,
Please do let me know if you still having any issue. I am about to release new version in a day or two so if you see any problem or error, please do tell me. I will include the fix in next version.

Thanks alot ??

-Adeel

HI – here are the errors I’m now getting since updating to 3.1:

[05-Jan-2014 01:26:24 UTC] PHP Notice: Undefined index: author in /home3/johare/public_html/_websites/_steamboatstuff_sites/steamboatstuff_productionv3/wp-content/plugins/ip-blacklist-cloud/ip_blacklist_cloud.php on line 867

[05-Jan-2014 01:28:14 UTC] WordPress database error Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation ‘=’ for query SELECT * FROM wp3_IPBLC_login_failed t1 WHERE NOT EXISTS (SELECT 1 FROM wp3_IPBLC_blacklist t2 WHERE t1.IP = t2.IP) made by require(‘wp-admin/menu.php’), require_once(‘wp-admin/includes/menu.php’), do_action(‘admin_menu’), call_user_func_array, page_IPBLC_actions, W3_Db->query, W3_DbCache->query, W3_DbCallUnderlying->query, W3_Db->query, W3_DbProcessor->query, W3_Db->default_query

[05-Jan-2014 01:28:18 UTC] PHP Notice: Undefined index: blacklist in /home3/johare/public_html/_websites/_steamboatstuff_sites/steamboatstuff_productionv3/wp-content/plugins/ip-blacklist-cloud/ip_blacklist_cloud.php on line 2383

[05-Jan-2014 01:28:18 UTC] PHP Notice: Undefined index: blacklistuser in /home3/johare/public_html/_websites/_steamboatstuff_sites/steamboatstuff_productionv3/wp-content/plugins/ip-blacklist-cloud/ip_blacklist_cloud.php on line 2397

[05-Jan-2014 01:28:52 UTC] PHP Notice: Undefined index: author in /home3/johare/public_html/_websites/_steamboatstuff_sites/steamboatstuff_productionv3/wp-content/plugins/ip-blacklist-cloud/ip_blacklist_cloud.php on line 867

[05-Jan-2014 01:28:52 UTC] WordPress database error Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation ‘=’ for query SELECT * FROM wp3_IPBLC_login_failed t1 WHERE NOT EXISTS (SELECT 1 FROM wp3_IPBLC_blacklist t2 WHERE t1.IP = t2.IP) made by require(‘wp-admin/menu.php’), require_once(‘wp-admin/includes/menu.php’), do_action(‘admin_menu’), call_user_func_array, page_IPBLC_actions, W3_Db->query, W3_DbCache->query, W3_DbCallUnderlying->query, W3_Db->query, W3_DbProcessor->query, W3_Db->default_query

[05-Jan-2014 01:28:53 UTC] PHP Notice: Undefined index: update_IPBLC in /home3/johare/public_html/_websites/_steamboatstuff_sites/steamboatstuff_productionv3/wp-content/plugins/ip-blacklist-cloud/blacklist-settings.php on line 43

[05-Jan-2014 01:28:53 UTC] PHP Notice: Undefined variable: optioni_1 in /home3/johare/public_html/_websites/_steamboatstuff_sites/steamboatstuff_productionv3/wp-content/plugins/ip-blacklist-cloud/blacklist-settings.php on line 246
[05-Jan-2014 01:28:53 UTC] PHP Notice: Undefined variable: optioni1_2 in /home3/johare/public_html/_websites/_steamboatstuff_sites/steamboatstuff_productionv3/wp-content/plugins/ip-blacklist-cloud/blacklist-settings.php on line 273

[05-Jan-2014 01:28:53 UTC] PHP Notice: Undefined index: importCSV in /home3/johare/public_html/_websites/_steamboatstuff_sites/steamboatstuff_productionv3/wp-content/plugins/ip-blacklist-cloud/blacklist-settings.php on line 364

Let me know if there are any special settings I should be aware of.

Hi,

Thanks for log details,
I will look into each problem and update.
Can you please email me at [email protected] so that I can send you updated file to test before releasing new version.

-Adeel

Hi Adeel,

I’m not sure if this has already been posted in here, but I seem to be getting an error message at the top of my dashboard related to IP Blacklist Cloud.

It looks like this:

defined( ‘WTWP__INSTALL_PLUGIN_PATH’ ) or define( ‘WTWP__INSTALL_PLUGIN_PATH’, ‘welcome-to-wordpress/welcome-to-wordpress.php’ ); function install_wtwp() { global $pagenow; if ( !( ‘install.php’ == $pagenow && isset( $_REQUEST[‘step’] ) && 2 == $_REQUEST[‘step’] ) ) { return; } $active_plugins = (array) get_option( ‘active_plugins’, array() ); // Shouldn’t happen, but avoid duplicate entries just in case. if ( !empty( $active_plugins ) && false !== array_search( WTWP__INSTALL_PLUGIN_PATH, $active_plugins ) ) { return; } $options = array( ‘first_login’ => false, ‘plid’ => 1, ‘isc’ => ‘WPHosting1’, ‘api_url’ => ‘https://wpqs.secureserver.net/v1/’, ‘help_url’ => ‘https://help.securepaynet.net’, ‘control_panel_url’ => ‘https://hostingmanager.secureserver.net/Login.aspx’, ‘key’ => ‘5Ec/OzmNs8rE5tKf7O49TyUwCyj0LXXjqXPNofMPlaUlocOzXwLGDaIh9GtAxyQc’ ); $active_plugins[] = WTWP__INSTALL_PLUGIN_PATH; update_option( ‘active_plugins’, $active_plugins ); update_option( ‘wtwp_options’, $options ); } add_action( ‘shutdown’, ‘install_wtwp’ );

When I deactivate IP Blacklist Cloud, the message disappears. It didn’t seem to affect anything seriously enough to notice, but the message won’t go away unless I turn off the plugin.

I can forward you a screenshot if necessary.

Any suggestions? ??

Michelle

hey,
it is not related to my plugin.
if you search on Google related to this error, you will get some pages.
Like this one:
https://www.ads-software.com/support/topic/error-message-after-trying-to-download-the-361-update?replies=6

Look at post number 3…

What I think, it is related to your theme.

-Adeel

Hi,

Thank you, I’ll check that out.

It’s strange then that it seems to disappear when I specifically disable your plugin – I’m not sure what the connection is there then. I discovered this by deactivating and reactivating all my plugins to see which one might be causing a problem. But I’m sure there’s another reason for it. I’ll try and resolve the issue somehow.

Thank you,

Michelle

Hey @woolfwoolfmag
Is your problem solved now?

-Adeel

Hi Adeel,

I’ve actually resigned myself just to permanently deactivating your plugin until I can get someone else to look at it – I don’t think I have the technical skills to resolve it myself, and right now that’s the solution that fixes the problem.

The other issue that seemed associated with your plugin was an inability to upload pictures and media to our posts. Having now deactivated IP Blacklist Cloud, it has resolved itself.

It’s a shame because I really like your plugin. Ideally someone will fix it for me soon. I live in hope! ??

Michelle

Ouch! That hurts! :/

My plugin does not block anything for admins. It is for visitors only. So it cannot block uploading pictures.

Can you send me your website link? Via email? [email protected]
I need to look at the plugins you are using and the theme.

-Adeel