Skip to main content

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'

Carly Hahn

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?

Carly Hahn

David ChurchillΒ I just used php my admin to add the missing table(s) all good now

Carly Hahn

what I found interesting tho, fluent forms and fluent booking as well as fluent cart stopped working until it was fixed.