Cannot generate search index
Open
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
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- 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