Question

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

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.revision_user’ in ‘field list’: SELECT revision.revision_id AS revision_id, revision.langcode AS langcode, revision.revision_user AS revision_user, revision.revision_created AS revision_created, revision.revision_log AS revision_log, base.id AS id, base.type AS type, base.uuid AS uuid, CASE base.revision_id WHEN revision.revision_id THEN 1 ELSE 0 END AS isDefaultRevision FROM {block_content} base INNER JOIN {block_content_revision} revision ON revision.revision_id = base.revision_id; Array (

Subscribe
Share

Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

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.

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