Upgrading to MySQL 5.7 causes editor issue

I just upgraded from MySQL 5.6 to 5.7.

After doing this I’m finding it difficult to switch between the same elements.

For example, if I am editing a header element, and then I click on another header element to edit it’s text, it will edit the text inside the first first header element not the second header element.

To make it work I have to click on a different element type (e.g. an image) before trying to edit the second header.

Any ideas how to fix this?

Hi,

Please check for the following first:

  1. Ensure everything is up to date. The latest version is Pro 2.3.8
    Please follow the best practices when updating your theme and plugins. See https://theme.co/apex/forum/t/setup-updating-your-themes-and-plugins/62 for more details.

  2. If you’re using a caching plugin, clear all caches including browser cache then deactivate your caching plugin and other optimization plugins.

  3. If you’re using a CDN, please clear the CDN’s cache and disable optimization services.

  4. Test for a plugin conflict. You can do this by deactivating all third party plugins, and seeing if the problem remains. If it’s fixed, you’ll know a plugin caused the problem, and you can narrow down which one by reactivating them one at a time.

  5. Temporarily remove custom CSS, Javascript and templates.

  6. Contact your host to increase your allocated memory or do it yourself by adding this code in your wp-config.php

define( 'WP_MEMORY_LIMIT', '512M' );
define( 'WP_MAX_MEMORY_LIMIT', '512M' );

7 Make sure PHP version is 7.2 or greater

Thanks.

Have gone through the list, it’s still happening.

The bug appeared after upgrading to MySQL 5.7 so I’m sure that’s the problem.

Hello @thecashbag,

​To assist you better with this issue, would you mind providing us the url of your site with login credentials so we can take a closer look? This is to ensure that we can provide you with a tailored answer to your situation. Once you have provided us with your URL, we will be happy to assist you with everything.

To do this, you can create a secure note with the following info:
– Link to your site
– WordPress Admin username / password

To know how to create a secure note, please check this out: https://theme.co/apex/forum/t/how-to-get-support/288

Thank you.

Hello, secure note added

Hi,

Thank you for providing your login credentials.

I checked but I can’t seem to replicate the issue.

See Video - https://www.screencast.com/t/ZJjpeIQv6r

Can you provide us a video showing the issue.

Thanks

The bug is appearing in the content editor not the header editor.

Also it only appears when you try and switch between elements by clicking on the element itself inside the “live view panel”, not by switching between elements inside the “editor panel”.

This can be hard to describe so I made a screencast for you here: https://www.screencast.com/t/iZH9QV1zJXi1

Hi @thecashbag,

Wordpress requirement is 5.6 or greater, so it should work since the builder only relies on the resources provided by Wordpress. The one that is directly talking to MySQL server is Wordpress, and it only provides the API that theme and plugins use. Examples,

https://developer.wordpress.org/reference/functions/wp_insert_post/
https://codex.wordpress.org/Function_Reference/update_post_meta
And more…

The theme and plugin have no understanding of what or information of the database is being used, and it doesn’t matter as long as Wordpress database API and function works. All compatibility between database are handled by Wordpress.

Though, it could be possible that your MySQL upgrade is incomplete or without proper configuration/corrupted that even Wordpress is unable to handle. Example, http://blog.lavoie.sl/2014/12/mysql-57-and-wordpress-problem.html

That’s why some hosting provider mostly offers and install bundled of software that is already tested. I recommend staying for MySQL 5.6 for now. As upgrading my MySQL to 5.7 broke my entire system (host environment) too.

And please re-upload your video with MP4 format, it’s not currently playing on my end.

Thanks!

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.