Can't install (PRO) - *** failed to install enupal-stripe: SQLSTATE[42S22]: Column not found: 'content.field_singleLine_cmpAcceptText_ewlhmziw' in 'field list'

[sunscreem]

Description

I'm trying to install the trial version of the PRO plugin into an existing site.

Steps to reproduce

1. Attempt to install

*** failed to install enupal-stripe: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'content.field_singleLine_cmpAcceptText_ewlhmziw' in 'field list'

Additional info

• Craft version: Craft Pro 4.4.15
• PHP version: 8.2.3
• Database driver & version: MySQL 8.0.32
• Plugin version: 5.1.2
• Is SCA and Stripe Checkout enabled?: n/a

[andrelopez]

Hi @sunscreem Could you please recreate the issue and send back to us a zip file of the following folder to [email protected]?
storage/logs

[andrelopez]

Hi @sunscreem I was able to recreate this issue. Please update your plugin to v5.2.0 now your changes will be propagated to your prod envs. Please let me know if you still have issues

[sunscreem]

Hey @andrelopez - I've been away so not had chance to test yet. Will email if I'm still stuck thank you.

[sunscreem]

Hey @andrelopez - I'm still unable to install this:

(Using version 5.2.0)

Let me know if you want me to send you that zip file of the storage folder.

*** installing enupal-stripe
    > create table {{%enupalstripe_forms}} ... done (time: 0.100s)
    > create table {{%enupalstripe_orders}} ... done (time: 0.043s)
    > create table {{%enupalstripe_customers}} ... done (time: 0.035s)
    > create table {{%enupalstripe_addresses}} ... done (time: 0.032s)
    > create table {{%enupalstripe_countries}} ... done (time: 0.028s)
    > create table {{%enupalstripe_orderstatuses}} ... done (time: 0.037s)
    > create table {{%enupalstripe_messages}} ... done (time: 0.026s)
    > create table {{%enupalstripe_subscriptiongrants}} ... done (time: 0.035s)
    > create table {{%enupalstripe_connect}} ... done (time: 0.030s)
    > create table {{%enupalstripe_vendors}} ... done (time: 0.032s)
    > create table {{%enupalstripe_commissions}} ... done (time: 0.033s)
    > create table {{%enupalstripe_products}} ... done (time: 0.034s)
    > create table {{%enupalstripe_prices}} ... done (time: 0.029s)
    > create table {{%enupalstripe_carts}} ... done (time: 0.031s)
    > create index idx_mwxnnultgrpxkcawambhnugpivgfjeyuvgty on {{%enupalstripe_orders}} (formId) ... done (time: 0.043s)
    > create index idx_jaevhbkwinsjetvqeafzswxgmfcklezdduqf on {{%enupalstripe_orders}} (isSubscription) ... done (time: 0.034s)
    > create index idx_cxofctycqtaixshhhqsspfduydgxxpdbfwux on {{%enupalstripe_orders}} (isCart) ... done (time: 0.032s)
    > create index idx_payualjefmggahqyyoqwggbljakyeeithtaw on {{%enupalstripe_orders}} (number) ... done (time: 0.053s)
    > create index idx_lyjzyxlwlwshfkbkdoqqktkzmduonjllkshj on {{%enupalstripe_messages}} (orderId) ... done (time: 0.037s)
    > create index idx_nxhnzrbbxumrmepdxqloafycociocadsdwmu on {{%enupalstripe_addresses}} (countryId) ... done (time: 0.034s)
    > create unique index idx_hydxnyhhatskmnoawnaqzmwuejbewkglktin on {{%enupalstripe_countries}} (name) ... done (time: 0.035s)
    > create unique index idx_bzxpmgcgnzqzapbmhnxkpkfugdagsndurplu on {{%enupalstripe_countries}} (iso) ... done (time: 0.031s)
    > create index idx_ruumjonyygghcurwygyllnczogglumvfdjuo on {{%enupalstripe_orders}} (billingAddressId) ... done (time: 0.029s)
    > create index idx_geucibbqxajpmetkqrsdmrhovxpblyiauwlw on {{%enupalstripe_orders}} (shippingAddressId) ... done (time: 0.032s)
    > create index idx_uyuueruqlrdbjluunsuugwvpnpkqvhmfkbwy on {{%enupalstripe_subscriptiongrants}} (userGroupId) ... done (time: 0.033s)
    > create index idx_wsboaqcdfaxfyqwzysmcpfbotiazjommnuvm on {{%enupalstripe_connect}} (vendorId) ... done (time: 0.024s)
    > create index idx_odzovtiylfaqxgotgizrfjkyknoxwwidzcba on {{%enupalstripe_vendors}} (userId) ... done (time: 0.032s)
    > create index idx_ggazximoedeezpwhusmchhwjjmuspergrwkx on {{%enupalstripe_commissions}} (orderId) ... done (time: 0.033s)
    > create index idx_jbxykgwfaamfhuzedcvgkemjqdvyhhgjnfkq on {{%enupalstripe_commissions}} (productId) ... done (time: 0.030s)
    > create index idx_ffbgujbhirfeffbudiqpkyiimzvqfqyuujtt on {{%enupalstripe_commissions}} (connectId) ... done (time: 0.042s)
    > create index idx_hdqfdoluqhxftgbfatrcionbiqwlsjrmbtqy on {{%enupalstripe_commissions}} (number) ... done (time: 0.032s)
    > create index idx_cdfnypdraichwkorosnawnlkqxeakhoabwyb on {{%enupalstripe_prices}} (productId) ... done (time: 0.024s)
    > create unique index idx_bjxayoeikyawrabzhrhchplumwzdanbnqljs on {{%enupalstripe_products}} (stripeId) ... done (time: 0.024s)
    > create unique index idx_rnwqlfbwexxkimebhxlxnxbluzdzrqnctwdz on {{%enupalstripe_prices}} (stripeId) ... done (time: 0.023s)
    > create unique index idx_tdhebxgxcrvtvfwsjthivknpoexfhvbefwqx on {{%enupalstripe_carts}} (stripeId) ... done (time: 0.027s)
    > create unique index idx_tsdleorvipgdzegahgoodxbqlogfckfyvvjn on {{%enupalstripe_carts}} (number) ... done (time: 0.031s)
    > create index idx_cgycyvebbrtuhgjrfraxascyvctosbjgzpfo on {{%enupalstripe_carts}} (userId) ... done (time: 0.027s)
    > create index idx_mqxjxwsddntwmyaiyxqkxtnqeztczsabnede on {{%enupalstripe_carts}} (cartStatus) ... done (time: 0.029s)
    > add foreign key fk_nrdjvhgtlxseaikaqwwhnvpesamjfzovqoww: {{%enupalstripe_forms}} (id) references {{%elements}} (id) ... done (time: 0.116s)
    > add foreign key fk_ydwccsmihuvjqlccrxokiepgzlpzjpjvxxcd: {{%enupalstripe_orders}} (id) references {{%elements}} (id) ... done (time: 0.110s)
    > add foreign key fk_qxpgeumqdsychejcbfetgotqaybvuedgilqx: {{%enupalstripe_orders}} (formId) references {{%enupalstripe_forms}} (id) ... done (time: 0.145s)
    > add foreign key fk_ktkiwsjzbuioxersooxyekowciyvegefrqhn: {{%enupalstripe_messages}} (orderId) references {{%enupalstripe_orders}} (id) ... done (time: 0.166s)
    > add foreign key fk_bgbvrisbaldypswjvdejkcfnbczfjdtlbvnt: {{%enupalstripe_addresses}} (countryId) references {{%enupalstripe_countries}} (id) ... done (time: 0.211s)
    > add foreign key fk_axadjmetxaxlutnxlwsptaihbrbmdobyrtcb: {{%enupalstripe_orders}} (billingAddressId) references {{%enupalstripe_addresses}} (id) ... done (time: 0.221s)
    > add foreign key fk_pxrjlbzwkmyiyfexmjsypakvujwvfzqiuthd: {{%enupalstripe_orders}} (shippingAddressId) references {{%enupalstripe_addresses}} (id) ... done (time: 0.181s)
    > add foreign key fk_ymxejllwwnfmpkrousebhxmmebqtnxpvdrmp: {{%enupalstripe_subscriptiongrants}} (userGroupId) references {{%usergroups}} (id) ... done (time: 0.080s)
    > add foreign key fk_tyrqdhgzhzaqipqrucaqjbnqkfjjrfyvcnmw: {{%enupalstripe_connect}} (id) references {{%elements}} (id) ... done (time: 0.095s)
    > add foreign key fk_aqksrrwcajlknlvxlzayfbmxwtbpnlfldbdr: {{%enupalstripe_vendors}} (id) references {{%elements}} (id) ... done (time: 0.089s)
    > add foreign key fk_wgdvnvxkfrnqcgqwhmllxtmexcpvijkgtcjw: {{%enupalstripe_commissions}} (id) references {{%elements}} (id) ... done (time: 0.105s)
    > add foreign key fk_tjfexffmtmiwotvtjbypdxkvehsfwcxbngny: {{%enupalstripe_connect}} (vendorId) references {{%enupalstripe_vendors}} (id) ... done (time: 0.079s)
    > add foreign key fk_fzmudhodvhrilcspgnedigfrrcujehxmbfvv: {{%enupalstripe_commissions}} (orderId) references {{%elements}} (id) ... done (time: 0.117s)
    > add foreign key fk_agwzkxhtpykoirzzplqhdnitwrndrkywpdku: {{%enupalstripe_commissions}} (productId) references {{%elements}} (id) ... done (time: 0.103s)
    > add foreign key fk_rxqbfdzprqtsdgdocfahswinlhfvwbppzief: {{%enupalstripe_commissions}} (connectId) references {{%enupalstripe_connect}} (id) ... done (time: 0.107s)
    > add foreign key fk_obmvspomqsmsntulvvslvwgslquinypocyvd: {{%enupalstripe_prices}} (productId) references {{%enupalstripe_products}} (id) ... done (time: 0.088s)
    > add foreign key fk_pgvnwxzbkpmdffceozmyujgzlldvagmlasyz: {{%enupalstripe_carts}} (userId) references {{%users}} (id) ... done (time: 0.098s)
    > add foreign key fk_wryxqeczkxpeiuqbzdkeyrbawonpvwcnpqjr: {{%enupalstripe_orders}} (cartId) references {{%enupalstripe_carts}} (id) ... done (time: 0.127s)
*** failed to install enupal-stripe: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'content.field_singleLine_cmpAcceptText_ewlhmziw' in 'field list'
The SQL being executed was: SELECT `elements`.`id`, `elements`.`canonicalId`, `elements`.`fieldLayoutId`, `elements`.`uid`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateLastMerged`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_sites`.`id` AS `siteSettingsId`, `elements_sites`.`slug`, `elements_sites`.`siteId`, `elements_sites`.`uri`, `elements_sites`.`enabled` AS `enabledForSite`, `globalsets`.`name`, `globalsets`.`handle`, `globalsets`.`sortOrder`, `globalsets`.`uid`, `content`.`id` AS `contentId`, `content`.`field_singleLine_cmpAcceptText_ewlhmziw`, `content`.`field_singleLine_age`, `content`.`field_singleLine_allowEnquiriesWhenStockZero`, `content`.`field_singleLine_alternativePhone_zdmouwqc`, `content`.`field_singleLine_appointmentDate`, `content`.`field_singleLine_appointmentTime`, `content`.`field_singleLine_bestPossibleRate`, `content`.`field_singleLine_bonusFortnightEndDate`, `content`.`field_singleLine_bonusFortnightStartDate`, `content`.`field_singleLine_brandVideo`, `content`.`field_singleLine_breadcrumbsSchema_pebfcvor`, `content`.`field_singleLine_canBeEngraved`, `content`.`field_singleLine_canBeReserved`, `content`.`field_singleLine_cartEmptyMessage`, `content`.`field_singleLine_clearance`, `content`.`field_singleLine_clickAndCollect`, `content`.`field_singleLine_engagementRingsClosureCopy_kqahqydp`, `content`.`field_singleLine_engagementRingsClosureTitle_xgbxmbkq`, `content`.`field_singleLine_comingSoonProduct`, `content`.`field_singleLine_comments`, `content`.`field_singleLine_contactEmail`, `content`.`field_singleLine_contactNumber`, `content`.`field_singleLine_conversionNotes`, `content`.`field_singleLine_conversionValue`, `content`.`field_singleLine_converted`, `content`.`field_singleLine_essentialCookies_belqtlik`, `content`.`field_singleLine_functionalCookies`, `content`.`field_singleLine_performanceCookies_eehbjjfk`, `content`.`field_singleLine_rolexCookies_kjpomjyk`, `content`.`field_singleLine_privacyCookiesCopy_iuekhypz`, `content`.`field_singleLine_cmpButtonText_nbczhwur`, `content`.`field_singleLine_cmpDescription_tbphkwmc`, `content`.`field_singleLine_description`, `content`.`field_singleLine_functionalDescription_jsqqolzk`, `content`.`field_singleLine_necessaryCookiesDescription_kbuhicbs`, `content`.`field_singleLine_performanceDescription_onnmscov`, `content`.`field_singleLine_rolexDescription_snjwxowr`, `content`.`field_singleLine_engagementRingsCutLink`, `content`.`field_singleLine_engagementRingsCutButtonText`, `content`.`field_singleLine_editCookieSettingButtonText_czcuuxsm`, `content`.`field_singleLine_editCookieSettingsCopy_wcnrphlk`, `content`.`field_singleLine_explanationText`, `content`.`field_singleLine_engagementRingsFeatureOneBackgroundColour_dyxspurg`, `content`.`field_singleLine_engagementRingsFeatureOneBackgroundPosition_rjlcensp`, `content`.`field_singleLine_engagementRingsFeatureOneLink`, `content`.`field_singleLine_engagementRingsFeatureOneButtonText`, `content`.`field_singleLine_engagementRingsFeatureOneCopy`, `content`.`field_singleLine_engagementRingsCutFeatureOneHeading`, `content`.`field_singleLine_engagementRingsFeatureThreeBackgroundColour_rjzwcddt`, `content`.`field_singleLine_engagementRingsFeatureThreeBackgroundPosition_loymfufc`, `content`.`field_singleLine_engagementRingsFeatureThreeLink_opiisrnl`, `content`.`field_singleLine_engagementRingsFeatureThreeButtonText_abgleqgt`, `content`.`field_singleLine_engagementRingsFeatureThreeCopy_nzntlsof`, `content`.`field_singleLine_engagementRingsCutFeatureThreeHeading_eazcwgth`, `content`.`field_singleLine_engagementRingsFeatureTwoBackgroundColour_syimddcz`, `content`.`field_singleLine_engagementRingsFeatureTwoBackgroundPosition_jbarbmjq`, `content`.`field_singleLine_engagementRingsFeatureTwoLink_rcyrwbgp`, `content`.`field_singleLine_engagementRingsFeatureTwoButtonText_texbfgim`, `content`.`field_singleLine_engagementRingsFeatureTwoCopy_xbayzylg`, `content`.`field_singleLine_engagementRingsCutFeatureTwoHeading_ykhcxfdw`, `content`.`field_singleLine_featuredHeader`, `content`.`field_singleLine_financeAvailable`, `content`.`field_singleLine_financeHistory`, `content`.`field_singleLine_firstName`, `content`.`field_singleLine_fullName`, `content`.`field_singleLine_giftMessage`, `content`.`field_singleLine_cmpHeading_yrhdndgs`, `content`.`field_singleLine_functionalHeading_zeoiykqa`, `content`.`field_singleLine_necessaryCookiesHeading_vhbklvqk`, `content`.`field_singleLine_performanceHeading_okzkhjne`, `content`.`field_singleLine_prefsHeading_ydfsfnyw`, `content`.`field_singleLine_rolexHeading_nzavmfvq`, `content`.`field_singleLine_engagementRingsIntroLink`, `content`.`field_singleLine_engagementRingsIntroButtonText`, `content`.`field_singleLine_engagementRingsIntroCopy`, `content`.`field_singleLine_introduction`, `content`.`field_singleLine_prefsDescription_qsrbxvwn`, `content`.`field_singleLine_prefsIntroTitle_ievtzkyu`, `content`.`field_singleLine_lastName`, `content`.`field_singleLine_localBusinessSchema_jyrbtmjv`, `content`.`field_singleLine_location`, `content`.`field_singleLine_longestPossibleTime`, `content`.`field_singleLine_lowestPossibleDeposit`, `content`.`field_singleLine_maxFinancePrice`, `content`.`field_singleLine_engagementRingsMetalCopy`, `content`.`field_singleLine_minFinancePrice`, `content`.`field_singleLine_moreInformationDescription_bovyfufi`, `content`.`field_singleLine_moreInformationHeading_gxzwvfan`, `content`.`field_singleLine_onlyDisplay`, `content`.`field_singleLine_organizationSchema_hflbcanr`, `content`.`field_singleLine_addressPhone_obseldfd`, `content`.`field_singleLine_engagementRingsPriceCopy`, `content`.`field_singleLine_productCategoriesHeader`, `content`.`field_singleLine_productVideo`, `content`.`field_singleLine_cmpRejectText_kfnkdzjc`, `content`.`field_singleLine_reserveInStore`, `content`.`field_singleLine_revisionDate_teqvokdq`, `content`.`field_singleLine_ringSizeRequired`, `content`.`field_singleLine_rolexTemplate_hosupsce`, `content`.`field_singleLine_saleEndDate`, `content`.`field_singleLine_saleOffCTALink`, `content`.`field_singleLine_saleOffCTAText`, `content`.`field_singleLine_saleOffCopy`, `content`.`field_singleLine_saleOnCTALink`, `content`.`field_singleLine_saleOnCTAText`, `content`.`field_singleLine_saleOnCopy`, `content`.`field_singleLine_jcSalePrice`, `content`.`field_singleLine_saleStartDate`, `content`.`field_singleLine_prefsSaveButtonText_wlvcgflq`, `content`.`field_singleLine_searchRedirects`, `content`.`field_singleLine_seoContent`, `content`.`field_singleLine_engagementRingsStyleLink`, `content`.`field_singleLine_engagementRingsStyleButtonText`, `content`.`field_singleLine_summaryText`, `content`.`field_singleLine_addressTitle_bykdtxdc`, `content`.`field_singleLine_ukOnly`, `content`.`field_singleLine_ukOnlyCartPageExplanationText`, `content`.`field_singleLine_ukOnlyCartPageShortExplanationText`, `content`.`field_singleLine_ukOnlyProductPageExplanationText`
FROM (SELECT `elements`.`id` AS `elementsId`, `elements_sites`.`id` AS `elementsSitesId`, `content`.`id` AS `contentId`
FROM `elements` `elements`
INNER JOIN `globalsets` `globalsets` ON `globalsets`.`id` = `elements`.`id`
INNER JOIN `elements_sites` `elements_sites` ON `elements_sites`.`elementId` = `elements`.`id`
INNER JOIN `content` `content` ON `content`.`elementId` = `elements`.`id`
WHERE (`elements`.`archived`=FALSE) AND (`elements`.`dateDeleted` IS NULL) AND (`elements`.`draftId` IS NULL) AND (`elements`.`revisionId` IS NULL)
ORDER BY `globalsets`.`sortOrder`) `subquery`
INNER JOIN `elements` `elements` ON `elements`.`id` = `subquery`.`elementsId`
INNER JOIN `elements_sites` `elements_sites` ON `elements_sites`.`id` = `subquery`.`elementsSitesId`
INNER JOIN `globalsets` `globalsets` ON `globalsets`.`id` = `subquery`.`elementsId`
INNER JOIN `content` `content` ON `content`.`id` = `subquery`.`contentId`
ORDER BY `globalsets`.`sortOrder`