Unable to adjust column settings for a migrated table

  • Resolved dizwell

    (@dizwell)


    5 months, 3 weeks ago

    I’m moving my website to a new host. My WP Data Access tables have been migrated across and all data imported. On the original site (see https://absolutelybaching.com/a-list-of-composers/wolfgang-amadeus-mozart/symphonies-of-wolfgang-amadeus-mozart/) you’ll see that each data item can be expanded to show a small graphic of a piece of music and a short music audio file extract can also be played.

    On the migrated site, all I see when I expand an item on the equivalent page are two numbers (which I’m assuming are the ID numbers for the relevant graphic and music file items in the media library). It won’t display the image, nor a music player to allow the music snipper to be heard.

    I went into Data Explorer, and clicked on ‘Manage’ for the relevant table. I clicked Settings -> Column Settings. The column type for *every* column is shown blank, whereas on the original site, the two columns are listed as type ‘Image’ and ‘Audio’ respectively.

    So I change the column type for those two columns by selecting from the drop-down and then click ‘Save Column Settings’. At which point, a red box appears in the top left corner of the screen saying ‘Application Error! Please contact the plugin development team’.

    I suppose I have two questions: 1) why did the column types not come across in the migration? I’m pretty sure I copied across all wp_wpda* tables, so is there another table that stores this sort of information? And 2) why can I not set the data types for the columns now without generating an application error?

    An unrelated third question is: is it possible to turn table and column name verification off? I think it was introduced in version 4.x and I have tables created way back in version 1.x which do not obey the current naming rules (but which work fine as far as my site is concerned, so I’m not in need of additional functionality).

    I created a page showing screenshots from the live and migrated sites so you can see what I’m attempting to describe here: https://absolutelybaching.com/problem-with-wp-data-access-column-types/ (the migrated site is not yet publicly accessible, for obvious reasons!)

    • This topic was modified 5 months, 3 weeks ago by dizwell.

    The page I need help with: [log in to see the link]

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Contributor Kim L

    (@kimmyx)

    Hi @dizwell,

    Thanks for the post and we’re sorry to hear you encountered this issue.

    It’d be best if we can take a closer look at the migrated site so we can troubleshoot properly.

    Could you send us a message via Contact | WP Data Access?

    We’ll wait for your email!

    Thread Starter dizwell

    (@dizwell)

    That’s disappointing. I can’t let you look at the migrated site because it’s obviously just sitting on a home PC, uncontactable from the outside world, until such time as I can get this issue resolved. So we’re at something of an impasse, I fear.

    An answer to my third question would be appreciated, though: can one switch off the ‘table name/column name verification feature’?

    Plugin Contributor Kim L

    (@kimmyx)

    Hi @dizwell,

    We understand. Have you already tested for possible plugin/theme conflict?

    Otherwise, please also try following the steps here: Transfer to other WP DB | WP Data Access

    can one switch off the ‘table name/column name verification feature’?

    Apologies for missing this question. ?? It’s currently not possible to disable the warning. The red flags are mostly just there as a warning in case there’s anything amiss with your table setup, and if there’s none, the plugin usually just works as is.

    Let us know how it goes.

Viewing 3 replies - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.