Guest User

Database Exception

a guest
Nov 25th, 2019
6
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Database Exception – yii\db\Exception
  2. SQLSTATE[42S22]: Column not found: 1054 Unknown column 'author.lastName' in 'order clause'
  3. 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`, `entries`.`sectionId`, `entries`.`typeId`, `entries`.`authorId`, `entries`.`postDate`, `entries`.`expiryDate`, `content`.`id` AS `contentId`, `content`.`title`, `content`.`field_alternateTitle`, `content`.`field_atAGlance`, `content`.`field_authorLastName`, `content`.`field_awards`, `content`.`field_bio`, `content`.`field_body`, `content`.`field_bookLanguages`, `content`.`field_bookQuote`, `content`.`field_bookSummary`, `content`.`field_categoryColor`, `content`.`field_endDate`, `content`.`field_eventCopy`, `content`.`field_eventEndDate`, `content`.`field_eventLocation`, `content`.`field_eventShortDescription`, `content`.`field_eventShortLocation`, `content`.`field_eventStartDate`, `content`.`field_featured`, `content`.`field_firstName`, `content`.`field_formattedTitle`, `content`.`field_heroCopy`, `content`.`field_heroTitle`, `content`.`field_imageCaption`, `content`.`field_imageSize`, `content`.`field_introCopy`, `content`.`field_isFeatured`, `content`.`field_lastName`, `content`.`field_listingCopy`, `content`.`field_listingImagePosition`, `content`.`field_listingPageBackgroundColor`, `content`.`field_liveStreamFlag`, `content`.`field_location`, `content`.`field_middleName`, `content`.`field_pageCount`, `content`.`field_postType`, `content`.`field_pressLink`, `content`.`field_purchaseLink`, `content`.`field_recommendedAges`, `content`.`field_sensitiveContent`, `content`.`field_seoDescription`, `content`.`field_seoTitle`, `content`.`field_startDate`, `content`.`field_subtitle`, `content`.`field_summary`, `content`.`field_tagline`, `content`.`field_uniqueIdentifier`, `content`.`field_updatedContentFlag`, `structureelements`.`root`, `structureelements`.`lft`, `structureelements`.`rgt`, `structureelements`.`level`, `structureelements`.`structureId`
  4. FROM (SELECT `elements`.`id` AS `elementsId`, `elements_sites`.`id` AS `elementsSitesId`, `content`.`id` AS `contentId`, `structureelements`.`structureId`
  5. FROM `craft_elements` `elements`
  6. INNER JOIN `craft_entries` `entries` ON `entries`.`id` = `elements`.`id`
  7. INNER JOIN `craft_elements_sites` `elements_sites` ON `elements_sites`.`elementId` = `elements`.`id`
  8. INNER JOIN `craft_content` `content` ON (`content`.`elementId` = `elements`.`id`) AND (`content`.`siteId` = `elements_sites`.`siteId`)
  9. LEFT JOIN `craft_structureelements` `structureelements` ON (`structureelements`.`elementId` = `elements`.`id`) AND (EXISTS (SELECT *
  10. FROM `craft_structures`
  11. WHERE (`id` = `structureelements`.`structureId`) AND (`dateDeleted` IS NULL)))
  12. WHERE (`entries`.`sectionId`='5') AND (`elements_sites`.`siteId`='1') AND (`elements`.`archived`=FALSE) AND (((`elements`.`enabled`=TRUE) AND (`elements_sites`.`enabled`=TRUE)) AND (`entries`.`postDate` <= '2019-11-25 14:04:43') AND ((`entries`.`expiryDate` IS NULL) OR (`entries`.`expiryDate` > '2019-11-25 14:04:43'))) AND (`elements`.`dateDeleted` IS NULL) AND (`elements_sites`.`enabled`=TRUE) AND (`elements`.`draftId` IS NULL) AND (`elements`.`revisionId` IS NULL)
  13. ORDER BY `author`.`lastName`) `subquery`
  14. INNER JOIN `craft_entries` `entries` ON `entries`.`id` = `subquery`.`elementsId`
  15. INNER JOIN `craft_elements` `elements` ON `elements`.`id` = `subquery`.`elementsId`
  16. INNER JOIN `craft_elements_sites` `elements_sites` ON `elements_sites`.`id` = `subquery`.`elementsSitesId`
  17. INNER JOIN `craft_content` `content` ON `content`.`id` = `subquery`.`contentId`
  18. LEFT JOIN `craft_structureelements` `structureelements` ON (`structureelements`.`elementId` = `subquery`.`elementsId`) AND (`structureelements`.`structureId` = `subquery`.`structureId`)
  19. ORDER BY `author`.`lastName`
  20. Error Info: Array
  21. (
  22.     [0] => 42S22
  23.     [1] => 1054
  24.     [2] => Unknown column 'author.lastName' in 'order clause'
RAW Paste Data