craftcms / craftcms/cms

Cannot generate search index

Open
#7,311 1 comment 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

bug
Dominant language
PHP
Stars
3.6k
Forks
705
Avg merge
1d 5h
Merged PRs (30d)
134

Description

Tasks with generating serach index fail with such error:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'content.field_radioTest2' in 'field list' The SQL being executed was: SELECT `elements`.`id`, `elements`.`fieldLayoutId`, `elements`.`uid`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_sites`.`id` AS `siteSettingsId`, `elements_sites`.`slug`, `elements_sites`.`siteId`, `elements_sites`.`uri`, `elements_sites`.`enabled` AS `enabledForSite`, `commerce_variants`.`id`, `commerce_variants`.`productId`, `commerce_variants`.`isDefault`, `commerce_variants`.`sku`, `commerce_variants`.`price`, `commerce_variants`.`sortOrder`, `commerce_variants`.`width`, `commerce_variants`.`height`, `commerce_variants`.`length`, `commerce_variants`.`weight`, `commerce_variants`.`stock`, `commerce_variants`.`hasUnlimitedStock`, `commerce_variants`.`minQty`, `commerce_variants`.`maxQty`, `content`.`id` AS `contentId`, `content`.`title`, `content`.`field_customAttributes`, `content`.`field_blogCategoryIntro`, `content`.`field_productShippingTime`, `content`.`field_freeShippingValue`, `content`.`field_birthDate`, `content`.`field_dpdShippingAllowed`, `content`.`field_paymentDpdStatus`, `content`.`field_feedEan`, `content`.`field_feedId`, `content`.`field_feedStock`, `content`.`field_productGroup`, `content`.`field_paymentIdDpd`, `content`.`field_paymentIdprzelewy24`, `content`.`field_categoryLinkText`, `content`.`field_categoryDescriptionFull`, `content`.`field_categoryTextIntro`, `content`.`field_categoryLinkUrl`, `content`.`field_productOrderInCategory`, `content`.`field_commentRating`, `content`.`field_productIntro`, `content`.`field_locationStreetView`, `content`.`field_locationAddress`, `content`.`field_locationAssortmentColumn1`, `content`.`field_locationAssortmentColumn2`, `content`.`field_locationAssortmentColumn3`, `content`.`field_locationAssortmentIntro`, `content`.`field_locationEmail`, `content`.`field_locationFax`, `content`.`field_locationHours`, `content`.`field_locationContactEmail`, `content`.`field_locationContactHeader`, `content`.`field_locationContactIntro`, `content`.`field_locationDescription`, `content`.`field_locationLatitude`, `content`.`field_locationPhone`, `content`.`field_locationLongitude`, `content`.`field_brandIntro`, `content`.`field_mobileNavExpand`, `content`.`field_ceneoCategoryName`, `content`.`field_variantColorText`, `content`.`field_titleBase`, `content`.`field_catalogueNumber`, `content`.`field_aboutCertificatesHeader`, `content`.`field_aboutSellHeader`, `content`.`field_aboutSellText`, `content`.`field_aboutSellIntro`, `content`.`field_aboutHistory1Date`, `content`.`field_aboutHistory1Header`, `content`.`field_aboutHistory1Text`, `content`.`field_aboutHistory2Date`, `content`.`field_aboutHistory2Header`, `content`.`field_aboutHistory2Text`, `content`.`field_aboutHistory3Date`, `content`.`field_aboutHistory3Header`, `content`.`field_aboutHistory3Text`, `content`.`field_aboutHistoryHeader`, `content`.`field_aboutHistoryIntro`, `content`.`field_aboutIntroShort`, `content`.`field_aboutIntroHeader`, `content`.`field_aboutIntroText`, `content`.`field_aboutTeamHeader`, `content`.`field_fileDescription`, `content`.`field_productDescription`, `content`.`field_productAdvice`, `content`.`field_userGender`, `content`.`field_variantSize`, `content`.`field_locationSubtitle`, `content`.`field_oldPrice`, `content`.`field_homeSliderHeader`, `content`.`field_homeDiscoverText`, `content`.`field_homeDiscoverHeader`, `content`.`field_homeSocietyHeader`, `content`.`field_homeSocietyText1`, `content`.`field_homeSocietyText2`, `content`.`field_homeSocietyText3`, `content`.`field_homeSliderText`, `content`.`field_textForm`, `content`.`field_textIntro`, `content`.`field_radioTest2`, `content`.`field_testowyParametrRadio`, `content`.`field_commonContent`, `content`.`field_seoSettings`, `content`.`field_newsEnable`, `content`.`field_newsContent` FROM (SELECT `elements`.`id` AS `elementsId`, `elements_sites`.`id` AS `elementsSitesId`, `content`.`id` AS `contentId` FROM `elements` `elements` INNER JOIN `commerce_variants` `commerce_variants` ON `commerce_variants`.`id` = `elements`.`id` LEFT JOIN `commerce_products` `commerce_products` ON `commerce_variants`.`productId` = `commerce_products`.`id` LEFT JOIN `commerce_producttypes` `commerce_producttypes` ON `commerce_products`.`typeId` = `commerce_producttypes`.`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`) WHERE (`elements_sites`.`siteId`=2) AND (`elements`.`id`=27) AND (`elements`.`archived`=FALSE) AND (`elements`.`dateDeleted` IS NULL) AND (`elements`.`draftId` IS NULL) AND (`elements`.`revisionId` IS NULL) ORDER BY `commerce_variants`.`sortOrder`) `subquery` INNER JOIN `commerce_variants` `commerce_variants` ON `commerce_variants`.`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` ORDER BY `commerce_variants`.`sortOrder`

radioTest2 was field that was removed some time ago. How can i fix it?

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

The issue names no source files or tests; start by reproducing the search-index generation task and inspecting the content schema for the removed radioTest2 field. Done means the search index generates successfully without the missing-column error.

Written by the indexing model from the issue text.

Assessment

Tech stack
php, sql
Domain
backend, databases
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.