By drz
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 (
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
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
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and AI-native businesses
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.