[Resolved] The Existing Layouts don't show anymore in the backend after the last update

[Author]

Posts

[AtefR7377]

Hi,
After the latest Layouts plugin update, the existing layouts don't show anymore in the backned. they sill work but I can't access them

i tried from 2 browsers using 2 admin users. same problems.

I also chose the layouts language from the WPML dropdown menu, and also chose "All languages". same problem either way

here are how they show:

hidden link

clicking on any tab doesnt show anything.

can you please help?

the debug informaiton, login details are given in my other support ticket here:
https://toolset.com/forums/topic/i-cant-save-values-to-some-custom-fields-after-the-last-update/

thanks

[Beda]

FYI:
https://toolset.com/forums/topic/i-cant-save-values-to-some-custom-fields-after-the-last-update/ should be resolved meanwhile in 3.0.4

Related to the issue you report:

1. There are JS errors on the Layout List:

TypeError: self.model.get('Groups').getActiveAsArray is not a function. (In 'self.model.get('Groups').getActiveAsArray(self.activeGroup)', 'self.model.get('Groups').getActiveAsArray' is undefined)
WebSocket connection to 'url removed' failed: Unexpected response code: 403

2. I cannot replicate this or the issue you describe locally.

I will need to have a copy of this site if the problem persists in this conditions:

==> Please backup the site
1. Test with no plugins but Toolset and a WordPress native Theme like Twenty Seventeen
2. Activate WP Debug to see eventual PHP Errors:
https://codex.wordpress.org/WP_DEBUG

If nothing helps, please at this point grab a copy of the site and send that to me, or if for reasons you cannot perform the steps above, as well, try to grab a copy and send that to me:
https://toolset.com/faq/provide-supporters-copy-site/

[AtefR7377]

Hi Beda,
Thanks for the reply.

1- The only JS error I see in the layout page is related to the Layout plugin. please refer to the attached screenshot. I hovered over the error, and it shows that the line is related to the Layout plugin.
.
2- As I stated in both support tickets, I had deactivated all plugins, still nothing fixed.
.
3- The system was working, then the Layout plugin was upgraded to this new view, which is broken for me. How can this not be an issue with the new update?
.
4- I had provided all login details. can you please use it to grab an image of the website? My website is very big, and Toolset support members prefer to take the image directly using Duplicator, as the image is big (exceeds 1GB),
so can you kindly use the credentials I provided to obtain the required image?

Thank you very much for your help. Much appreciated.

[Beda]

I was not able to replicate this with the exported content of your site instead of a duplicate.
I can see all 8 layouts in the Tab "Unassigned Layouts"

I tried to create a filtered duplicate of your site and then applied the Database to the local install where I already imported the contents of your site - and I can now see all the layouts in the first tab as properly assigned to content types.

I then discovered that the whole issue appears only if you activate WPML.
A whole array of PHP errors appear on the plugins page and layouts screens.
The errors are related to not existing database rows, endlessly repeating.

I am not really sure if this is due to the exported Database or if you see the same error on the layout admin page when you enable WP Debug on the site?
I will escalate this but I need to confirm hat this issue is the same.
I see a error similar to:

WordPress database error: [Table 'wordpres.wp_icl_languages' doesn't exist]
SELECT l.code, l.id, english_name, nt.name AS native_name, major, active, default_locale, encode_url, tag, lt.name AS display_name FROM wp_icl_languages l JOIN wp_icl_languages_translations nt ON ( nt.language_code = l.code AND nt.display_language_code = l.code ) LEFT OUTER JOIN wp_icl_languages_translations lt ON l.code=lt.language_code WHERE ( lt.display_language_code = 'ar' OR (lt.display_language_code = 'en' AND NOT EXISTS ( SELECT * FROM wp_icl_languages_translations ls WHERE ls.language_code = l.code AND ls.display_language_code = 'ar' ) ) ) GROUP BY l.code ORDER BY english_name ASC

(Repeating)

If this is what you see as well, we caught this bug and I reported it.

PS on my local I see as well a JS error, once more another kind of.

I think, it's all related to above PHP error which seems to be a corrupted Database.
I cannot fix this on the fly, I need help from the developer for this.

However I as well would need to confirm that this is the same issue on your site if you enable WP Debug?

==> For now your site should turn to normal if you disable WPML plugin (which is of curse not a valid long term solution)
As soon I have some news from the developers and your confirmation that you see the same issue, we can then proceed with a fix.

==> Locally I was not able to replicate such a issue with WPML on a clean install yet but that may be due to the complexity of the site.

[AtefR7377]

Hi Beda,

I kept checking with my server team. there is a repetitve error for an unknown column called "'t.language_code".
can you please open a secure reply so i can send you the php-error.log?

thanks.

[Beda]

't.language_code' sounds like the WPML table column "language_code":
https://wpml.org/documentation/support/wpml-tables/

Being that somehow borked explains why later I see a similar error in the Layout:
"wp_icl_languages" missing (since it seems your database column and tables are having a unexpected name syntax)

Seems your Database has a corrupted naming, or similar.

I have added the finding to the internal ticket.
Please add the server log in the next private reply.

[Beda]

I had until now a Database without all tables, as I realized.

I installed a Plugin (Adminer) to check the database, and I saw the database tables are there, in your install.
(Phew).
I exported that, and removed the plugin I used again.
I struggled exporting that database, as it kept generating corrupt ZIP files masked as text files.
I finally managed to get them all by creating a GZIP, and then expanding that to my local.

==> I also saw, Memory limit 40M is used, but a memory limit of at least 128MB is required.
https://wpml.org/home/minimum-requirements/
==> As well I noticed you use a Plugin called Post Type Switcher.
That plugin is not compatible with Toolset, it will mess up your setup.
Please do not use it with Toolset Types posts.

Related to the issue, I am now able to replicate this database with all it's tables and rows and columns.
I got NO errors at all.
I have all WPML and Toolset plugins active.
I have 7 layouts, all not assigned to post types

So, I am back to step one where I suspected a compatibility issue with another plugin, and seen above, it seems you deeply some not compatible plugins.

We can offer this:
- an online test site where you can deploy your site (for free) and we will, if the error is replicable, analyses this.

With the current database and WPML/Toolset, the issue seems not replicable (unless you have a corrupt database as I had before)

I fear, this is due to either the server settings, or a conflict with a plugin.

Related to the error and debug logs.

In the error log, there are only warnings about a plugin "onesignal-free-web-push-notifications" and it's "sdk_files/OneSignalSDKWorker.js.php" file.
As well there seems to be errors (related to above) which is due to some media not found.

In the php-error log instead I see the error you mention:
Unknown column 't.language_code' (etc).
I did have the same error locally but that was with the Database that missed the tables:

What I can think of is, that your server is running out of time, or another plugin disturbs the query.

This can happen after an update, we changed the way things are displayed, and it seems the server may now run out of time given the low settings, or, another plugin now shows it's conflict.

I think the best run we have is to create a free test site where you can see this working using your database and our plugins.
Then, we may find what is causing the conflict on your specific site.

[AtefR7377]

Hi Beda,

I am preparing a detailed response, can you please keep the ticket open?
thanks
Atef

[Beda]

Yes.

Please let me know if you need any further help.