Error after update

Hi @batcop,

Sorry about this issue, but the followings are the same topic.

• error report on latest update
• Error on updating Versión 3.0.10

Please try deactivate once and activate again. You’ll see the same error message during these process. But the issue should be fixed.

I confirmed that the latest version 3.0.10.1 can solve this issue in my environment. But I’m afraid you may still have the issue with it because of the difference of database software types, e.g. MySQL and MariaDB.

So if 3.0.10.1 or deactivate/activate could not resolve your issue, please let me know about your server environment, especially the name and version of database software.

Thanks.

mariadb from plesk and centos as far as i know

Hi @batcop,

One of my users reported that MariaDB failed to initialize the database even when clean installing with the previous version.

I tried to fix it in the latest version 3.0.10.1. So once I would close this topic. But if you still have the issue with version 3.0.10.1, please let me know.

Thank you for your kind cooperation.

I am still having problems with version 3.0.10.1. I have followed the above instructions and nothing works. Fortunately I have a backup of my site with an older version of IP Geo Block that still works.

Hi @7thangel,

Sorry for your problem.

I made a test version which add the fallback process if the database fails to be updated. It’s based on 3.0.10.1.

I’d like to ask you to test class-ip-geo-block-logs.php in gist (download zip from here).

Thanks in advance!

This is my situation as well.

I am still having problems with version 3.0.10.1. I have followed the above instructions and nothing works

.

The error message went away but now the settings page is just a blank white page and nothing like deactivating/reactivating seems to make any difference.

Hi @mark-housel,

The typical cause of a blank white page might be that some PHP errors might happen in your site.

In another thread, you reported that you encountered a blank page with 3.0.10.

Then how did you update IPGB to 3.0.10.1? I guess you deleted “/wp-content/plugins/ip-geo-block/” folder using FTP or some file manager, right?

If so, other issues could be happened depending on your settings of IPGB due to the bad deactivating/uninstalling process.

Anyway, we should investigate what type of errors happens in your site.

So I’d like to ask you to follow the steps:

1. Enable WP_DEBUG in your wp-config.php using a proper editor.

/**
 * For developers: WordPress debugging mode.
 *
 ...(omitted)
 * @link https://codex.www.ads-software.com/Debugging_in_WordPress
 */
define('WP_DEBUG', true);

2. Add the following code just after define('WP_DEBUG', true).

define( 'WP_DEBUG_LOG', true );      // save to wp-content/debug.log
define( 'WP_DEBUG_DISPLAY', false ); // do not display on browser
@ini_set( 'display_errors', 0 );     // do not display on browser

3. Visit the page where you can see a blank page. And see “/wp-content/debug.log” with a text editor and let me know what type of errors happened.

You can find how to debug WordPress in the following documents:

• Debugging in WordPress
• WP DEBUG

I’d appreciate to cooperate to solve your issue.
Thank you, Mark.

@tokkonopapa I tried your test version, but that didn’t work either. I appreciate your help but I don’t have any more time to devote to trying to get this working. It’s a shame because I really liked this plugin. I’m sorry, but I’m going to have to try some other plugins.

I wish you all the best and hope you get this sorted out soon.

Hi @7thangel,

I’m very sorry I could not provide you a stable service.

I’m sorry, but I’m going to have to try some other plugins.

Of course, that’s your choice. So never mind. I’ll do may best so that you can come back to this plugin!

Thank you for your relationship until now.

Dear @mark-housel,

I found a possibility of your blank page if the version of your PHP is 5.3 and under.

If so, I’d appreciate to try following:

1. Deactivate the plugin.
2. Download zip file from here and unzip it.
3. Upload “ip-geo-block” folder in unzipped file into your “/wp-content/plugins/”. Overwriting should be OK.
4. Activate the plugin again.

Sorry for my bothering you.
Thanks.
4.

thanks

The typical cause of a blank white page might be that some PHP errors might happen in your site.

In another thread, you reported that you encountered a blank page with 3.0.10.

Then how did you update IPGB to 3.0.10.1? I guess you deleted “/wp-content/plugins/ip-geo-block/” folder using FTP or some file manager, right?

If so, other issues could be happened depending on your settings of IPGB due to the bad deactivating/uninstalling process.

No, I just saw that there was an update and checked bot box to update all plugins?

If so, I’d appreciate to try following:

1. Deactivate the plugin.
2. Download zip file from here and unzip it.

3. Upload “ip-geo-block” folder in unzipped file into your “/wp-content/plugins/”. Overwriting should be OK.
4. Activate the plugin again.

The zip file won’t open and in fact it crashes Windoze explorer even if I try to save the file and then open it?
Is there another file format?

I found a possibility of your blank page if the version of your PHP is 5.3 and under.

Current: PHP 7.0
System Default: PHP 7.0

debug-log contents after reactivating the plugin and trying to look at the settings page.

text/x-log debug.log ( ASCII text, with very long lines )

[05-Apr-2018 21:08:39 UTC] WordPress database error Incorrect table name ” for query SELECT blog_id FROM ORDER BY blog_id ASC made by require_once(‘wp-admin/admin.php’), require(‘wp-admin/menu.php’), require_once(‘wp-admin/includes/menu.php’), do_action(‘admin_menu’), WP_Hook->do_action, WP_Hook->apply_filters, IP_Geo_Block_Admin->setup_admin_page, IP_Geo_Block_Admin->register_settings_tab, IP_Geo_Block_Admin_Tab::tab_setup

@tokkonopapa It’s all good, tokkonopapa : )
If I can’t find a suitable replacement, I’ll restore my site from an older backup and run with a previous version of IP Geo Block. Yeah, the plugin will be out of date, but is that really a problem?

I wish you all the best.