Content disappeared after upgrade

[stevefloat]

Describe the bug

Hello

I've recently upgraded a website from Craft 3.7 to 4.3. As part of this upgrade, the Super Table plugin went from version 2.7.4 to 3.0.7

When running these upgrades on our local dev environment everything looked okay.

Last night we then pushed the changes up to production, running composer update and php craft up to instantiate everything.

I hadn't noticed at the time, however it's been brought to my attention that all Super Table content has disappeared from the live site. And we've been left with empty containers in the CMS where content had been added. An example of this is a Matrix field for content which includes a Super Table option.

Note that my local dev environment still has this content all displaying / linked.

I've then looked at the live database and within the table structure it looks like the content might still be there. But has perhaps lost it's relationship to the super table fields being used?

Are you able to offer some advice about how I can relink this content?
I appreciate I may have missed some guidance when going from Super Table 2.7.4 to 3.0.7

Steps to reproduce

1. Upgrade form Super Table 2.7.4 to 3.0.7
2. Upgrade Craft from 3.7 to 4.3
3. Deploy update with Composer and Craft Up
4. Content disappeared from frontend and CMS, however appears to still be stored in db tables

Craft CMS version

4.3.10

Plugin version

3.0.7

Multi-site?

No

Additional context

No response

[stevefloat]

Just to follow up after a bit more digging

On the live server after the update:

• the database table supertableblocks is empty
• I have a supert_old table with 470 entries
• And a super_old1 table with 2 entries

In my local dev database:

• the supertableblocks table has 477 entries
• I don't have any tables named supert_old or super_old1

[rowansentesy]

This is similar to an issue I'm facing with updating, however i'm going to Craft 2.7.4, super table 1.0.6 up to the latest of both. Having issues along the path! Following for now...

Rowan

[engram-design]

One thing to mention is that it's pretty critical to run the "content table checker/fixer" when updating to Craft 3. Just wanted to confirm you're both doing that?

[stevefloat]

Hi Josh - I was already running Craft 3. I was going from Craft 3.7 to 4.3

Note that the issues I've outlined with missing content did not happen in my local dev environment after upgrading. Everything worked fine locally. The issue occurred when I deployed to the live environment running the project config migrations with php craft up.

It's like the project-config files didn't execute the migration properly - I was left with two holding database tables (supert_old and super_old1) and my tables supertableblocks and supertableblocks_owners were empty.

I've had to manually re-add the Supertable content, from that which I had locally.

[engram-design]

@stevefloat Good point, my mistake about already being on Craft 3.

I'll look into if I can reproduce that, but it does sound like a project config oddity (one that you've already fixed). I might also recommend a ./craft project-config/apply --force just to ensure everything is applied properly for next time.