formagenda

Johann: I’m using WP Migrate DB Pro 1.5.2.

Wow, this is really annoying – I haven’t touched the site since my last message, and I tried migrating several times, always with the same result – Messed up tables. And now when I look at the production site, every table is just as it should be. Like magic.

I will keep an eye on it, and see if I can reproduce the issue, so we can get some real data for you to look at, and hopefully get to the bottom of this.

It’s exactly the same on local and live.

You can try viewing it here: https://raabjergmilecamping.dk/wp-json/acf/post/17
Here’s the JSON output:

"table-layout": {
          "header": false,
          "body": [
            [
              {
                "c": ""
              },
              {
                "c": "20/3-29/5"
              },
              {
                "c": "29/5-14/8"
              },
              {
                "c": "14/8-30/9"
              }
            ],
            [
              {
                "c": "Voksen"
              },
              {
                "c": "59 kr"
              },
              {
                "c": "76 kr"
              },
              {
                "c": "59 kr"
              }
            ],
            [
              {
                "c": "B?rn 0-11 ?r"
              },
              {
                "c": "34 kr"
              },
              {
                "c": "49 kr"
              },
              {
                "c": "34 kr"
              }
            ],
            [
              {
                "c": "Milj?till?g pr. person"
              },
              {
                "c": "14 kr"
              },
              {
                "c": "14 kr"
              },
              {
                "c": "14 kr"
              }
            ],
            [
              {
                "c": "Str?m 10 A"
              },
              {
                "c": "39 kr"
              },
              {
                "c": "39 kr"
              },
              {
                "c": "39 kr"
              }
            ],
            [
              {
                "c": "Hund"
              },
              {
                "c": "15 kr"
              },
              {
                "c": "15 kr"
              },
              {
                "c": "15 kr"
              }
            ]
          ]
        }
      }

This is from this page: https://raabjergmilecamping.dk/priser/
Where the backend looks like this live: https://c.matiasvad.com/e1mj
And like this locally (and on test-server): https://c.matiasvad.com/e2Is

I’ll have to take back that confirmation – Yes, it does work when migrating from my local to test (Digital Ocean) server – But going live (not a Digital Ocean server) is not migrating the tables correctly, unfortunately.

I don’t want to hijack another thread though, just a heads up.

I can confirm that this is actually also part of fixing this old issue (which turned out not to be server-related at all, now).
https://www.ads-software.com/support/topic/fields-being-deleted-on-save?replies=6

We had to dig up the project again this week, and make adjustments to it, then migrate it to test and live – And it was causing the exact issue, again.

I installed 1.1.5, and tried a new migration to test. All tables are intact.

After some troubleshooting with Johann I came to the conclusion that it must be a server related issue.
On the test-server I upgraded from 512MB to 1GB of ram, which solved the issue (plenty of test-sites are running there). And on the live server I increased max_input_vars and php_memory_limit, which also solved the issue there – For now.

This issue is resolved, and shouldn’t prevent anyone from trying out this plugin on a live site.

Hi Johann.

I’ve added you as a user on our test-site, you can go crazy there.

If you navigate to the “Priser” page and try saving that, you will see the issue happening on the table fields in the Flexible Content Field on there.

– I do not know if this will happen on a fresh new table.
– Some content may have been copypasted into the fields, I don’t know for sure.