500 errors and empty web context after update - Unknown column modContentType.icon in field list #15504
Description
Bug report
Summary
I upgraded an existing installation to the latest 3.x, but the web context is not visible in the tree. Pages are also not rendering in the browser (from any context).
I'm not sure if this is related, but I'm seeing various 500 errors in console:
Manager:
XHRPOSThttp://ff-next.loc/connectors/index.php?action=Resource/GetNodes&id=web_0&type=MODX\Revolution\modContext
[HTTP/1.1 500 Internal Server Error 25ms]
POST
http://ff-next.loc/connectors/index.php?action=Resource/GetNodes&id=web_0&type=MODX\Revolution\modContext
Status500
Internal Server Error
VersionHTTP/1.1
Transferred1.22 KB (0 B size)
Referrer Policystrict-origin-when-cross-origin
Cache-Control
no-store, no-cache, must-revalidate
Connection
keep-alive
Content-Type
text/html; charset=UTF-8
Date
Sat, 06 Mar 2021 08:13:25 GMT
Expires
Thu, 19 Nov 1981 08:52:00 GMT
Pragma
no-cache
Server
nginx/1.14.0 (Ubuntu)
Set-Cookie
PHPSESSID=va9sb5c7i0o29jg8iiadodiifj; path=/; HttpOnly
Transfer-Encoding
chunked
Accept
*/*
Accept-Encoding
gzip, deflate
Accept-Language
en-US,en;q=0.5
Cache-Control
no-cache
Connection
keep-alive
Content-Length
170
Content-Type
application/x-www-form-urlencoded; charset=UTF-8
Cookie
modx_setup_language=en; PHPSESSID=va9sb5c7i0o29jg8iiadodiifj
DNT
1
Host
ff-next.loc
modAuth
modx60432654416228.87415006_16043267bceaeb8.93816976
Origin
http://ff-next.loc
Pragma
no-cache
Referer
http://ff-next.loc/manager/?a=resource/update&id=1
User-Agent
Mozilla/5.0 (X11; Linux x86_64; rv:87.0) Gecko/20100101 Firefox/87.0
X-Requested-With
XMLHttpRequest
XHRPOSThttp://ff-next.loc/assets/components/contentblocks/connector.php
[HTTP/1.1 500 Internal Server Error 14ms]
POST
http://ff-next.loc/assets/components/contentblocks/connector.php
Status500
Internal Server Error
VersionHTTP/1.1
Transferred1.24 KB (0 B size)
Referrer Policystrict-origin-when-cross-origin
Cache-Control
no-store, no-cache, must-revalidate
Connection
keep-alive
Content-Type
text/html; charset=UTF-8
Date
Sat, 06 Mar 2021 08:13:25 GMT
Expires
Thu, 19 Nov 1981 08:52:00 GMT
Pragma
no-cache
Server
nginx/1.14.0 (Ubuntu)
Set-Cookie
PHPSESSID=va9sb5c7i0o29jg8iiadodiifj; path=/; HttpOnly
Transfer-Encoding
chunked
Accept
application/json, text/javascript, */*; q=0.01
Accept-Encoding
gzip, deflate
Accept-Language
en-US,en;q=0.5
Cache-Control
no-cache
Connection
keep-alive
Content-Length
189
Content-Type
application/x-www-form-urlencoded; charset=UTF-8
Cookie
modx_setup_language=en; PHPSESSID=va9sb5c7i0o29jg8iiadodiifj
DNT
1
Host
ff-next.loc
modAuth
modx60432654416228.87415006_16043267bceaeb8.93816976
Origin
http://ff-next.loc
Pragma
no-cache
Referer
http://ff-next.loc/manager/?a=resource/update&id=1
User-Agent
Mozilla/5.0 (X11; Linux x86_64; rv:87.0) Gecko/20100101 Firefox/87.0
X-Requested-With
XMLHttpRequest
Front-end:
GEThttp://ff-next.loc/
[HTTP/1.1 500 Internal Server Error 3566ms]
GET
scheme
http
host
ff-next.loc
filename
/
Address
127.0.0.1:80
Status500
Internal Server Error
VersionHTTP/1.1
Transferred339 B (0 B size)
Cache-Control
no-store, no-cache, must-revalidate
Connection
keep-alive
Content-Type
text/html; charset=UTF-8
Date
Sat, 06 Mar 2021 08:09:06 GMT
Expires
Thu, 19 Nov 1981 08:52:00 GMT
Pragma
no-cache
Server
nginx/1.14.0 (Ubuntu)
Transfer-Encoding
chunked
X-Powered-By
MODX Revolution
Accept
text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,*/*;q=0.8
Accept-Encoding
gzip, deflate
Accept-Language
en-US,en;q=0.5
Cache-Control
no-cache
Connection
keep-alive
Cookie
modx_setup_language=en; PHPSESSID=va9sb5c7i0o29jg8iiadodiifj
DNT
1
Host
ff-next.loc
Pragma
no-cache
Upgrade-Insecure-Requests
1
User-Agent
Mozilla/5.0 (X11; Linux x86_64; rv:87.0) Gecko/20100101 Firefox/87.0
Step to reproduce
I only tried updating this one site, but I'll update another to see if it has similar issues. Can't really tell what's going on. Installation didn't produce a lot of errors:
[2021-03-06 06:08:47] (ERROR @ /home/hugo/Localhost/dev/ff-next/core/vendor/xpdo/xpdo/src/xPDO/Om/xPDOObject.php : 227) Error 42S22 executing statement:
Array
(
[0] => 42S22
[1] => 1054
[2] => Unknown column 'modContentType.icon' in 'field list'
)
[2021-03-06 06:08:47] (FATAL) The requested resource has no valid content type specified.
[2021-03-06 06:09:00] (ERROR @ /home/hugo/Localhost/dev/ff-next/core/vendor/xpdo/xpdo/src/xPDO/Om/xPDOObject.php : 227) Error 42S22 executing statement:
Array
(
[0] => 42S22
[1] => 1054
[2] => Unknown column 'modDashboard.customizable' in 'field list'
)
And there's nothing in the Nginx logs.
Observed behavior
No resources listed under web context. Resources are accessible and editable when manually referencing them by ID. Other contexts do show their resources correctly.
No output on front-end from any context.
Expected behavior
Web context should show resources in tree and render them in browser.
Related issue(s)/PR(s)
None that I'm aware of.
Environment
MODX 3.x (build from March 5), PHP 7.3, Nginx, MariaDB 10.2, Firefox Dev