If deny ZZ, cannot access subsites.

Same situation with 1.2.

Hey @tanuki2023,

I tried to reproduce the issue on a multisite without any success.

Can you please record a short video with the issue you are facing or contact us at [email protected] for more details.

Also, FYI, the settings in every subsite are separate and only apply to that subsite. Can you confirm you are doing the blocking on the subsites as well? If you change settings on the main site, it will NOT reflect on the subsites.

Best,
DG

• This reply was modified 1 year, 1 month ago by Darko G..

OK

It may take some time, but I will send you an email.
I’m not good at taking videos, so I’ll probably use still images.

As I wrote in the email, there is only one setting because it is a Network wide setting.

1.2.2
I don’t know if it has been fixed or not, but the error message that appears on the subsite (see image 03 in the email) still does not go away. It started appearing in 1.2.

I apologize if this is redundant reporting.

Hi @tanuki2023,

Can you please deactivate and activate the plugin again? Looks like database issue which should be solved by running the database migration procedure.

Best,
DG

I disabled it as advised and then enabled it.

There was a subsite where the error no longer occurred.

As usual, there are some errors. The error is:
/class-ip-location-block-logs.php (1258) Unknown column ‘city’ in ‘field list’
/class-ip-location-block-logs.php (1332) Unknown column ‘city’ in ‘field list’

Google’s crawler was just coming, but it was sorted to ZZ. (I couldn’t figure out how to upload images on this bulletin board. If you need it, I’ll send it to the same email address.)

wp-content/plugins/ip-location-block/classes/class-ip-location-block-logs.php (1040) Unknown column ‘city’ in ‘field list’
wp-content/plugins/ip-location-block/classes/class-ip-location-block-logs.php (1189) Unknown column ‘city’ in ‘field list’

There are also more errors

Disabled and re-enabled in version 1.2.3

I was able to confirm that the error no longer appeared on some sites.

Google crawlers are being distributed to ZZ, including sites that no longer have errors.

This is the error that I was able to confirm
/ip-location-block/classes/class-ip-location-block-logs.php (1040) Unknown column ‘city’ in ‘field list’
/ip-location-block/classes/class-ip-location-block-logs.php (1189) Unknown column ‘city’ in ‘field list’
/ip-location-block/classes/class-ip-location-block-logs.php (1258) Unknown column ‘city’ in ‘field list’

Hey @tanuki2023,

The error related to the database is because you are missing the new city column in wp_ip_location_block_cache (https://prnt.sc/9arJ85Z3KyNT) and wp_ip_location_block_logs (https://prnt.sc/1cy3Nw3s8xxR) tables.

You have two ways to add the columns:

1. Using GUI. Open phpMyAdmin and navigate to “Structure” tab of each of those tables and add two columns (https://prnt.sc/E1uMtxkfUXDb), then in you need to fill the column definitions (https://prnt.sc/LqWBSAlujZb6).
2. Using SQL. Open phpMyAdmin or MySQL command-line client, select the database and go to SQL tab and run the following code:

ALTER TABLE wp_ip_location_block_cache ADD state VARCHAR(100) DEFAULT NULL AFTER code"
ALTER TABLE wp_ip_location_block_cache ADD city VARCHAR(100) DEFAULT NULL AFTER code"
ALTER TABLE wp_ip_location_block_logs ADD state VARCHAR(100) DEFAULT NULL AFTER code"
ALTER TABLE wp_ip_location_block_logs ADD city VARCHAR(100) DEFAULT NULL AFTER code"

I hope this helps.

Best Regards,
Darko

I no longer have any problems with the error using the method you taught me. thank you.

Unfortunately, problems classified as ZZ are not fixed.