[Resolved] error: DESCRIBE wp_toolset_maps_address_cache

[Author]

Posts

[hussainS]

Hi i have these errors, when activating Toolset Maps plugin:
1. DESCRIBE wp_toolset_maps_address_cache; --> Unknown Table 'ehejezad_wp.wp_toolset_maps_address_cache' doesn't exist qmdb
2. CREATE TABLE wp_toolset_maps_address_cache ( address_passed varchar(190) NOT NULL, address varchar(255) NOT NULL, point point NOT NULL, PRIMARY KEY (address_passed) ) DEFAULT CHARACTER
SET utf8mb4 COLLATE utf8_general_ci
--> COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'utf8mb4'

and i have wrote these lines to mysql configuration file /etc/my.cnf:
character-set-server = utf8
collation-server = utf8_general_ci

and now when i execute these lines:
SHOW VARIABLES LIKE '%char%';
SHOW VARIABLES LIKE '%collation%';

character_set_client utf8mb4
character_set_connection utf8mb4
character_set_database latin1
character_set_filesystem binary
character_set_results utf8mb4
character_set_server utf8
character_set_system utf8
character_sets_dir /usr/share/mysql/charsets/

collation_connection utf8mb4_unicode_ci
collation_database latin1_swedish_ci
collation_server utf8_general_ci

after that i ran in phpMyAdmin on the wordpress database this DDL command:
CREATE TABLE wp_toolset_maps_address_cache ( address_passed varchar(190) NOT NULL, address varchar(255) NOT NULL, point point NOT NULL, PRIMARY KEY (address_passed) ) DEFAULT CHARACTER
SET utf8mb4 COLLATE utf8_general_ci
but still gives the same error.

even after de-activating the Toolset Maps plugin.
Please help.
Regards.

[Minesh]

Hello. Thank you for contacting the Toolset support.

Such issues are reported before but this issue is actually fixed with Maps 1.8.1 release.

First of all:
Could you please send me debug information that will help us to investigate your issue.
=> https://toolset.com/faq/provide-debug-information-faster-support/

[hussainS]

I did like what is said in the link:
https://toolset.com/faq/provide-debug-information-faster-support/
and there is no debug info, as u can see in the attached picture.

also for ur info, i entered phpMyAdmin, and there is no table called 'wp_toolset_maps_address_cache'.

[Minesh]

This is really strange. Can you please send me wp-admin access details.

*** Please make a FULL BACKUP of your database and website.***
I would also eventually need to request temporary access (WP-Admin and FTP) to your site. Preferably to a test site where the problem has been replicated if possible in order to be of better help and check if some configurations might need to be changed.

I have set the next reply to private which means only you and I have access to it.

[Minesh]

I tried to install and activate the Maps plugin using types installer on your install and it was successfully activated but for somereaons, I see now "Internal Server Error" when I try to access the site.

Do you have any security plugin installed or IP wise restrictions?

[hussainS]

Hi,
I just managed to restore the site, please don't do anything till cPanel Backup Cron job starts.
When it does start, and finish, i will tell, so i can have correct backup of the latest settings.

Regards.

[hussainS]

Hi,
Everything is ready, please try again.
Regards.

[Minesh]

Can you please check now. I can see the debug information now when I deactivated the query monitory plugin on your install.
=> hidden link

I installed and activated the Toolset Maps plugin and I do not see the error your reported on plugins page. However - Toolset's minimum requirement for MySQL server is 5.6. Can you please update MySQL server version on your install.
=> https://toolset.com/toolset-requirements/

[hussainS]

Hi,
Thanks, My Current MySQL is 5.7, i found the plugin that stops astra theme from working, its "Toolset Layouts", see the video for steps on how to get the problem and how to stop it:

hidden link

Hope this will help in fixing the problem soon.
Also, this finding is given to the Astra Theme team.

Sorry, i think this is another error, so i will post it with a new ticket.

Regards.

[Minesh]

Thanks. Thats another issue. If your original issue is resolved. I would encourage you to create a new ticket with your every new question you may have. This will help other users searching on the forum as well as help us to write correct problem resolution summery.

[hussainS]

My issue is resolved now. Thank you!