"The cache directory must be published under the webroot" error when importing database into Concrete 9.2.1

[wilfordbrimley]

Thank you! I have installed 8.5.14 with my theme. After importing my database, I am still receiving a lot of invalid field name exceptions:

Doctrine\DBAL\Exception\InvalidFieldNameException thrown with message "An exception occurred while executing 'select Pages.cID, Pages.pkgID, Pages.siteTreeID, Pages.cPointerID, Pages.cPointerExternalLink, Pages.cIsDraft, Pages.cIsActive, Pages.cIsSystemPage, Pages.cPointerExternalLinkNewWindow, Pages.cFilename, Pages.ptID, Collections.cDateAdded, Pages.cDisplayOrder, Collections.cDateModified, cInheritPermissionsFromCID, cInheritPermissionsFrom, cOverrideTemplatePermissions, cCheckedOutUID, cIsTemplate, uID, cPath, cParentID, cChildren, cCacheFullPageContent, cCacheFullPageContentOverrideLifetime, cCacheFullPageContentLifetimeCustom from Pages inner join Collections on Pages.cID = Collections.cID left join PagePaths on (Pages.cID = PagePaths.cID and PagePaths.ppIsCanonical = 1) where Pages.cID = ?' with params [1]:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'Pages.cIsDraft' in 'field list'"

The only other place I’m seeing a similar error mentioned is here:

Upgrade 8.5.9 to 9.1.2 fails

Hi, I uninstalled all extra extensions to make sure the upgrade runs through. Unfortunately it does not. I tried to replace the /concrete directory and after this failed (and I restored the original filesystem without extensions and DB) I tried the internal upgrading process: Both ways show up kind of the same error message: Sooner or later some column is missing from an SQL statement. Also: The internal process shows up a “bad gateway” error on the server. Refreshing that page does not chan…

And it looks like your suggestion was to do the intermediate update. Any ideas what else I could try?