[Resolved] Server migrated using SQL export and import doesn't show all Views/Layouts

[Author]

Posts

[josephr-5]

We have our multisite sites hosted on a server which became unstable and desperately needed updates but we were unable to access the WordPress environment due to employee changes. We migrated the database via SQL export and import, and migrated the wp-content folder via SFTP, relinking media files from the server. Certain pages which use Views and Layouts are not displaying any data even though they did prior to the move.

This page hidden link should have a list of faculty and information.

You can see the data displaying at hidden link but it is not properly formatted there.

The upgrade moved us to
WordPress => 5.5.1
PHP => 7.3
Toolset Types => 3.4.1
Toolset Forms => 2.6.1
Toolset Maps => 2.0.3
Toolset Access => 2.8.8
Toolset Layouts => 2.4.2
Toolset Views => 2.6.4.2
Toolset Framework Installer => 3.1.10
Toolset Genesis Integration => 1.9.2

There are no fatal errors in the error log.

The last updates prior to these could well have been 12-24 months ago.

We've tried upgrading using the dashboard and that did not fix things.

Can you give us some idea as to where the problem may lie?

[josephr-5]

I was able to restore the page views by reimporting an earlier copy of the database, so I am able to see the page views now.

I am not seeing a database table row for the Toolset Maps options values with key "wpv_addon_maps_options". In the source code it shows that this option should exist (toolset-maps/includes/toolset-common-functions.php:line 18) but it is not in the database even after deactivating and reactivating the plugin. It was also not on the old server's database. I believe this is at issue because of the admin alert saying " You need an API key to use Toolset Maps. Find more information in our documentation and visit the Toolset Maps settings page to choose an API and enter the key.".

I have entered out Toolset API key in wp-config.php as a constant named "OTGS_INSTALLER_SITE_KEY_TOOLSET".

At hidden link this file:
hidden link

is loading 4 files from URLs with 404 errors due to their bad path:
hidden link
hidden link
hidden link
hidden link

These values being undefined may point to these two files, or identical ones in a different Toolset plugin:
layouts/vendor/toolset/toolset-common/inc/autoloaded/code_snippets/assets/main.js: line 30; 35; 42; 45 - 48
layouts/vendor/toolset/toolset-common/inc/autoloaded/code_snippets/SettingsTab.php: line 239

How should I address this so that the settings page shows its full content and works as intended?

[josephr-5]

I also found a PHP Fatal Error: Uncaught Error: Class 'Twig_Loader_Filesystem' not found in /nas/content/live/laitsitestamu/wp-content/plugins/layouts/classes-auto/wpddl.twig-helper.class.php:65

[josephr-5]

After searching through the file system I realized my version of Layouts wasn't updated like I thought it was via the dashboard so I downloaded it directly, uploaded it via sftp, and the settings page loads fine now.