Answers.Body: <p>Command <code>./craft migrate/all</code> fixed this issue. </p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-02-27T11:58:12.320Z
Answers.Text: Had the same issue with a different plugin. the migrate/all fixed the issue. Wonderful <3
Answers.UserDisplayName: nitech
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-01-24T06:35:26.617Z
Answers.LastActivityDate: 2020-01-24T06:35:26.617Z
Answers.UserDisplayName: EvgeniaM
Body: <p>I deployed the project from the git repository on hosting. When trying to open the homepage I get the following error:</p>
  
  <pre><code>Database Exception
      SQLSTATE[42S22]: Column not found: 1054 Unknown column 'position' in 'order clause'
  The SQL being executed was: SELECT `elements`.`id`, `elements`.`fieldLayoutId`, `elements`.`uid`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_sites`.`slug`, `elements_sites`.`siteId`, `elements_sites`.`enabled` AS `enabledForSite`, `elements_sites`.`uri`, `categories`.`groupId`, `content`.`id` AS `contentId`, `content`.`title`, `structureelements`.`root`, `structureelements`.`lft`, `structureelements`.`rgt`, `structureelements`.`level`, `structureelements`.`structureId`
  FROM (SELECT `elements`.`id` AS `elementsId`, `elements_sites`.`id` AS `elementsSitesId`, `content`.`id` AS `contentId`, `structureelements`.`structureId`
  FROM `elements` `elements`
  INNER JOIN `categories` `categories` ON `categories`.`id` = `elements`.`id`
  INNER JOIN `elements_sites` `elements_sites` ON `elements_sites`.`elementId` = `elements`.`id`
  INNER JOIN `content` `content` ON (`content`.`elementId` = `elements`.`id`) AND (`content`.`siteId` = `elements_sites`.`siteId`)
  LEFT JOIN `structureelements` `structureelements` ON (`structureelements`.`elementId` = `elements`.`id`) AND (EXISTS (SELECT *
  FROM `structures`
  WHERE (`id` = `structureelements`.`structureId`) AND (`dateDeleted` IS NULL)))
  WHERE (`elements_sites`.`siteId`='1') AND (`elements`.`archived`=FALSE) AND (`elements`.`enabled`=TRUE) AND (`elements`.`dateDeleted` IS NULL) AND (`elements_sites`.`enabled`=TRUE) AND (`structureelements`.`level`='2') AND (`elements`.`draftId` IS NULL) AND (`elements`.`revisionId` IS NULL)
  ORDER BY `position`) `subquery`
  INNER JOIN `categories` `categories` ON `categories`.`id` = `subquery`.`elementsId`
  INNER JOIN `elements` `elements` ON `elements`.`id` = `subquery`.`elementsId`
  INNER JOIN `elements_sites` `elements_sites` ON `elements_sites`.`id` = `subquery`.`elementsSitesId`
  INNER JOIN `content` `content` ON `content`.`id` = `subquery`.`contentId`
  LEFT JOIN `structureelements` `structureelements` ON (`structureelements`.`elementId` = `subquery`.`elementsId`) AND (`structureelements`.`structureId` = `subquery`.`structureId`)
  ORDER BY `position`
  </code></pre>
  
  <p>But the admin page opens without errors.
  And when I run a project on a local machine, there is no such error.
  What can i do to fix this problem?</p>
  
Tags: <craft3><database><error>
Title: Database Exception: Column not found: 1054 Unknown column 'position' in 'order clause'
ThreadText: # Database Exception: Column not found: 1054 Unknown column 'position' in 'order clause'
  
  (Asked by: username_0 on 2020-01-23)
  
  I deployed the project from the git repository on hosting. When trying to open the homepage I get the following error:
  
  ```
  Database Exception
      SQLSTATE[42S22]: Column not found: 1054 Unknown column 'position' in 'order clause'
  The SQL being executed was: SELECT `elements`.`id`, `elements`.`fieldLayoutId`, `elements`.`uid`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_sites`.`slug`, `elements_sites`.`siteId`, `elements_sites`.`enabled` AS `enabledForSite`, `elements_sites`.`uri`, `categories`.`groupId`, `content`.`id` AS `contentId`, `content`.`title`, `structureelements`.`root`, `structureelements`.`lft`, `structureelements`.`rgt`, `structureelements`.`level`, `structureelements`.`structureId`
  FROM (SELECT `elements`.`id` AS `elementsId`, `elements_sites`.`id` AS `elementsSitesId`, `content`.`id` AS `contentId`, `structureelements`.`structureId`
  FROM `elements` `elements`
  INNER JOIN `categories` `categories` ON `categories`.`id` = `elements`.`id`
  INNER JOIN `elements_sites` `elements_sites` ON `elements_sites`.`elementId` = `elements`.`id`
  INNER JOIN `content` `content` ON (`content`.`elementId` = `elements`.`id`) AND (`content`.`siteId` = `elements_sites`.`siteId`)
  LEFT JOIN `structureelements` `structureelements` ON (`structureelements`.`elementId` = `elements`.`id`) AND (EXISTS (SELECT *
  FROM `structures`
  WHERE (`id` = `structureelements`.`structureId`) AND (`dateDeleted` IS NULL)))
  WHERE (`elements_sites`.`siteId`='1') AND (`elements`.`archived`=FALSE) AND (`elements`.`enabled`=TRUE) AND (`elements`.`dateDeleted` IS NULL) AND (`elements_sites`.`enabled`=TRUE) AND (`structureelements`.`level`='2') AND (`elements`.`draftId` IS NULL) AND (`elements`.`revisionId` IS NULL)
  ORDER BY `position`) `subquery`
  INNER JOIN `categories` `categories` ON `categories`.`id` = `subquery`.`elementsId`
  INNER JOIN `elements` `elements` ON `elements`.`id` = `subquery`.`elementsId`
  INNER JOIN `elements_sites` `elements_sites` ON `elements_sites`.`id` = `subquery`.`elementsSitesId`
  INNER JOIN `content` `content` ON `content`.`id` = `subquery`.`contentId`
  LEFT JOIN `structureelements` `structureelements` ON (`structureelements`.`elementId` = `subquery`.`elementsId`) AND (`structureelements`.`structureId` = `subquery`.`structureId`)
  ORDER BY `position`
  
  ```
  
  But the admin page opens without errors.
  And when I run a project on a local machine, there is no such error.
  What can i do to fix this problem?
  
  **Tags:** craft3, database, error
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_0 on 2020-01-24. Score: 2
  
  Command `./craft migrate/all` fixed this issue.
  
  > **Comments:**
  > **username_1**: Had the same issue with a different plugin. the migrate/all fixed the issue. Wonderful <3  
  
  ---
  
  