Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Database Exception – yii\db\Exception
- SQLSTATE[42S22]: Column not found: 1054 Unknown column 'author.lastName' 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`, `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`
- FROM (SELECT `elements`.`id` AS `elementsId`, `elements_sites`.`id` AS `elementsSitesId`, `content`.`id` AS `contentId`, `structureelements`.`structureId`
- FROM `craft_elements` `elements`
- INNER JOIN `craft_entries` `entries` ON `entries`.`id` = `elements`.`id`
- INNER JOIN `craft_elements_sites` `elements_sites` ON `elements_sites`.`elementId` = `elements`.`id`
- INNER JOIN `craft_content` `content` ON (`content`.`elementId` = `elements`.`id`) AND (`content`.`siteId` = `elements_sites`.`siteId`)
- LEFT JOIN `craft_structureelements` `structureelements` ON (`structureelements`.`elementId` = `elements`.`id`) AND (EXISTS (SELECT *
- FROM `craft_structures`
- WHERE (`id` = `structureelements`.`structureId`) AND (`dateDeleted` IS NULL)))
- 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)
- ORDER BY `author`.`lastName`) `subquery`
- INNER JOIN `craft_entries` `entries` ON `entries`.`id` = `subquery`.`elementsId`
- INNER JOIN `craft_elements` `elements` ON `elements`.`id` = `subquery`.`elementsId`
- INNER JOIN `craft_elements_sites` `elements_sites` ON `elements_sites`.`id` = `subquery`.`elementsSitesId`
- INNER JOIN `craft_content` `content` ON `content`.`id` = `subquery`.`contentId`
- LEFT JOIN `craft_structureelements` `structureelements` ON (`structureelements`.`elementId` = `subquery`.`elementsId`) AND (`structureelements`.`structureId` = `subquery`.`structureId`)
- ORDER BY `author`.`lastName`
- Error Info: Array
- (
- [0] => 42S22
- [1] => 1054
- [2] => Unknown column 'author.lastName' in 'order clause'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement