Viewing 5 replies - 1 through 5 (of 5 total)
  • Hi @katmacau

    I hope you are doing well today.

    Could you let us know, based on your data from database, about which table and row we talk about here, so that we could be on the same page with you? This will allow us to make some test and help you better.

    Kind Regards,
    Kris

    Thread Starter katmacau

    (@katmacau)

    Thanks. I looked it up and it was only in the wp_frmt_form_entry_meta table which had saved submissions that included a file upload.

    I’ve just deleted the old entries now. But good for you to know where it was.

    ‘INSERT INTO wp_frmt_form_entry_meta (meta_id, entry_id, meta_key, meta_value, date_created, date_updated) VALUES
    (33, 3, ‘upload-1’, ‘a:1:{s:4:\”file\”;a:5:{s:7:\”success\”;b:1;s:9:\”file_name\”;s:33:\”qQVFX3MzhOZB-xD8100109.jpg\”;s:8:\”file_url\”;s:135:\”https://my_domain/wp-content/uploads/forminator/426_c7c28ea72fbc457656474121c4e3f114/uploads/qQVFX3MzhOZB-xD8100109.jpg\”;s:7…`

    Thread Starter katmacau

    (@katmacau)

    Hi. I also noticed it in the wp_pas_postmeta table for forminator_form_meta items. Eg… in here:

    ….;s:12:”redirect-url”;s:36:”https://dev.mydomain.com.au/wp-admin/”;s:10:”submitData….

    Plugin Support Laura – WPMU DEV Support

    (@wpmudev-support8)

    Hi @katmacau

    Thanks for response and additional information!

    In Forminator itself, there’s no option to “reset” that – unless you want to reset plugin entirely to the factory setting. For form, it can partially help to simply edit the form and re-save it as it should update form data but it won’t update e.g. already submitted data and similar information, I’m afraid.

    Instead, I’d recommend using this free plugin for such domain updates:

    https://ww.wp.xz.cn/plugins/better-search-replace/

    It can really save a lot of time as it’s a matter of just a few click, it supports “dry run” so you can review potential changes and it actually does support serialized arrays quite nicely. You can also select in which tables you want to make changes.

    Best regards,
    Adam

    Thread Starter katmacau

    (@katmacau)

    Great. Will try that thanks.

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Changing site URL – serialized data in database’ is closed to new replies.