Skip Navigation

[Resolved] WordPress database error: [COLLATION ‘utf8_general_ci’ is not valid for CHARACTE

This thread is resolved. Here is a description of the problem and solution.

Problem:

Solution:
You should try to create a table manually using the following SQL script:

CREATE TABLE IF NOT EXISTS 'wp4d_toolset_maps_address_cache' (
  'address_passed' varchar(190) COLLATE utf8mb4_unicode_ci NOT NULL,
  'address' varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  'point' point NOT NULL,
  PRIMARY KEY ('address_passed')
) DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

Relevant Documentation:

This support ticket is created 5 years, 5 months ago. There's a good chance that you are reading advice that it now obsolete.

This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.

Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.

Sun Mon Tue Wed Thu Fri Sat
- 10:00 – 13:00 10:00 – 13:00 10:00 – 13:00 10:00 – 13:00 10:00 – 13:00 -
- 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 -

Supporter timezone: Asia/Kolkata (GMT+05:30)

This topic contains 4 replies, has 2 voices.

Last updated by varucanA 5 years, 5 months ago.

Assisted by: Minesh.

Author
Posts
#1325145

WordPress database error: [COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'utf8mb4']

CREATE TABLE wp4d_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

Strict Standards: call_user_func_array() expects parameter 1 to be a valid callback, non-static method CustomQueryFields::doQueryParse() should not be called statically in /home/madweb/varooz.madweb.design/wp-includes/class-wp-hook.php on line 286

Strict Standards: call_user_func_array() expects parameter 1 to be a valid callback, non-static method CustomQueryFields::addQueryVars() should not be called statically in /home/madweb/varooz.madweb.design/wp-includes/class-wp-hook.php on line 286

Strict Standards: call_user_func_array() expects parameter 1 to be a valid callback, non-static method CustomQueryFields::doQueryParse() should not be called statically in /home/madweb/varooz.madweb.design/wp-includes/class-wp-hook.php on line 286

Notice: Undefined index: suppress_filters in /home/madweb/varooz.madweb.design/wp-content/plugins/custom-query-fields/custom-query-fields.php on line 102 this is what the debugger says. We need to update PHP version to get the speed up. After PWA please have a look

#1325253
#1325271

Minesh
Supporter

Languages: English (English )

Timezone: Asia/Kolkata (GMT+05:30)

Please send me duplicator copy of your install by following instructions given with the following link:
=> https://toolset.com/faq/provide-supporters-copy-site/

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

#1325801
#1325803

Looks like due to the same Toolset plugins it runs into so many issues while running Duplicator and building the packages out of it.
You are already given access to our website with the relevant credential and I also have installed the Duplicator plugin there already, so please do and take whatever packages you like from there.

#1325981

Minesh
Supporter

Languages: English (English )

Timezone: Asia/Kolkata (GMT+05:30)

Thank you for sharing duplicator package.

I checked closely and I found that the issue is from the plugin "Custom Query Fields" - when I deactivate that plugin I see all those notices that displayed are gone.

I deactivated that plugin "Custom Query Fields" on your test site as well - if you will activate it you will see those notices.
=> hidden link

#1325989

My issue is resolved now. Thank you!