Question

How can I solve an nginx error with Drupal-8.4.5 multisite

Posted February 26, 2018 1.4k views
UbuntuDrupal

This is the error message:

)
“ at /var/www/html/drupal/core/lib/Drupal/Core/Database/Connection.php line 686” while reading response header from upstream, client: 108.14.88.246, server: , request: “GET /user/1 HTTP/1.1”, upstream: “fastcgi://unix:/var/run/php5-fpm.sock:”, host: “www.miridians.org
2018/02/26 11:29:08 [error] 969#0: *28894 FastCGI sent in stderr: “PHP message: Uncaught PHP Exception Drupal\Core\Database\DatabaseExceptionWrapper: "SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘revision.revisionuser’ in 'field list’: SELECT revision.revisionid AS revisionid, revision.langcode AS langcode, revision.revisionuser AS revisionuser, revision.revisioncreated AS revisioncreated, revision.revisionlog AS revisionlog, base.id AS id, base.type AS type, base.uuid AS uuid, CASE base.revisionid WHEN revision.revisionid THEN 1 ELSE 0 END AS isDefaultRevision
FROM
{block
content} base
INNER JOIN {blockcontentrevision} revision ON revision.revisionid = base.revisionid; Array
(

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
1 answer

Hi @drz,

Looking at the error you’ve provided, this is related to your application’s database and specifically calling an unknown column. Here is the line you want to check

Column not found: 1054 Unknown column ‘revision.revisionuser’ in 'field list

The exact query you are trying to run is

SELECT revision.revisionid AS revisionid, revision.langcode AS langcode, revision.revisionuser AS revisionuser, revision.revisioncreated AS revisioncreated, revision.revisionlog AS revisionlog, base.id AS id, base.type AS type, base.uuid AS uuid, CASE base.revisionid WHEN revision.revisionid THEN 1 ELSE 0 END AS isDefaultRevision
FROM
{blockcontent} base
INNER JOIN {blockcontentrevision} revision ON revision.revisionid = base.revisionid; Array
(

As we can’t know what function you are trying to execute or your database and application structure, we won’t be able to provide more in depth solution that just breaking down your error as I’ve just did.

Regards,
KDSys

Submit an Answer