Upgraded FluentCart Database Issues
Has anyone expereinced this? This was just the update not settings or anything
WordPress database error: [Table 'xxxx_wp_xxxx.p5cfW_fct_retention_snapshots' doesn't exist]
DESCRIBE p5cfW_fct_retention_snapshots
WordPress database error: [Table 'xxxxx_wp_xxxxx.p5cfW_fct_retention_snapshots' doesn't exist]
ALTER TABLE p5cfW_fct_retention_snapshots ADD COLUMN currency VARCHAR(10) NOT NULL DEFAULT '' AFTER product_id;
WordPress database error: [Table 'xxxx_wp_xxxx.p5cfW_fct_retention_snapshots' doesn't exist]
SHOW INDEX FROM p5cfW_fct_retention_snapshots WHERE Key_name = 'p5cfW_fct_rs_cohort_period_product_currency_idx'
WordPress database error: [Table 'xxxxx_wp_xxxxx.p5cfW_fct_retention_snapshots' doesn't exist]
ALTER TABLE p5cfW_fct_retention_snapshots ADD UNIQUE INDEX p5cfW_fct_rs_cohort_period_product_currency_idx (cohort, period, product_id, currency);
WordPress database error: [Table 'xxxx_wp_xxxxx.p5cfW_fct_retention_snapshots' doesn't exist]
SHOW COLUMNS FROM p5cfW_fct_retention_snapshots LIKE 'currency'
WordPress database error: [Table 'xxxx_wp_xxxxx.p5cfW_fct_retention_snapshots' doesn't exist]
SHOW COLUMNS FROM p5cfW_fct_retention_snapshots LIKE 'currency'
Due to this issue my store will not accept any orders
Carly HahnΒ what version of FC Free and Pro are you using? As it looks like there might be an issue with the Free 2.1.0, so roll it back to v 2.0.0 for now and see if that help?
David ChurchillΒ I just used php my admin to add the missing table(s) all good now
what I found interesting tho, fluent forms and fluent booking as well as fluent cart stopped working until it was fixed.