Custom Tabs missing

  • Resolved kumaresan

    (@kumaresanwp)


    7 years, 6 months ago

    Hi,

    I have imported my backup files, then i lost custom product tabs in products pages.
    I have checked the metakey ‘yikes_woo_products_tabs’ in postmeta table in Db, i have seen that table having values but in the front-end custom tables are disappeared.

    Please help me to solve this ASAP

    • This topic was modified 7 years, 6 months ago by kumaresan.
Viewing 15 replies - 1 through 15 (of 15 total)
  • Plugin Contributor yikesitskevin

    (@yikesitskevin)

    Hi @kumaresanwp,

    Have the tabs disappeared on the back-end as well?

    The data is stored as a serialized array and if the array is corrupted the data will not return properly. One common way corruption happens is by changing something manually in the database (or through a database script). Did anything change about your custom product tabs? For example, did you run any search and replace functions on the database to update URLs?

    Let me know – apologies for the issue,
    Kevin.

    Thread Starter kumaresan

    (@kumaresanwp)

    Thanks yikesitskevin,
    The problem happened because of Db collation changed while importing the Db.
    Now we have changed the Collation to UTF8MB4 and now everything working fine.

    Plugin Contributor yikesitskevin

    (@yikesitskevin)

    Oh great news! So the tabs are back and working properly?

    Thread Starter kumaresan

    (@kumaresanwp)

    Hi,

    Yes, it’s working fine now mate.

    Which UTF8mb4_unicode subset specifically? You can’t just change it to UTF8MB4.

    Thread Starter kumaresan

    (@kumaresanwp)

    Hi pmagony,

    I can’t understand, what you are speaking about?

    I’m speaking about the collation value, for the meta_key column, in the postmeta table.

    Thread Starter kumaresan

    (@kumaresanwp)

    Ok i have changed the collation using notepad++ and uploaded Db file, then everything working fine.

    Aha… that makes sense now. Can you tell me which option you chose in Notepad++ Encoding drop-down menu?

    https://pasteboard.co/GBENPwi.png

    Thread Starter kumaresan

    (@kumaresanwp)

    I didn’t changed options in notepad++.
    I just replaced collation to UTF8MB4 general.

    Sorry, are faced the same problem or trying to solve my problem?
    If you are trying to solve my problem, don’t worry i have fixed that already.

    Thanks

    • This reply was modified 7 years, 4 months ago by kumaresan.

    This is for me to resolve, as I am experiencing the same issue you originally faced and fixed. I now want to fix it for me.

    You wrote: “Ok i have changed the collation using notepad++ and uploaded Db file, then everything working fine.”

    But now you are saying you didn’t change collation in Notepad++. Which means you changed it in the DB table structure. So which did you choose from the collation column?

    https://pasteboard.co/GBEUVVL.png

    • This reply was modified 7 years, 4 months ago by F C.

    https://pasteboard.co/GBEUVVL.png

    Thread Starter kumaresan

    (@kumaresanwp)

    Can you please check the your table wp_post table collation and let me know what was the collation in that table.

    If you can mail me at [email protected]

    • This reply was modified 7 years, 4 months ago by kumaresan.

    Collation value for that column is UTF8MB4_unicode_520_ci

    Thread Starter kumaresan

    (@kumaresanwp)

    Yes that is problem.

    Download DB and make one backup.

    Open Db in notepad++ and find wp_post and change the collation from UTF8MB4_unicode_520_ci to utf8_general_ci then import that DB and check the tabs in website.

    Try to use previous Backup DB which was having tabs(means website working perfectly previously with that DB)

    • This reply was modified 7 years, 4 months ago by kumaresan.
Viewing 15 replies - 1 through 15 (of 15 total)
  • The topic ‘Custom Tabs missing’ is closed to new replies.