Custom Tabs missing

  • Resolved kumaresan

    (@kumaresanwp)


    6 years, 10 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 6 years, 10 months ago by kumaresan.
Viewing 15 replies - 1 through 15 (of 15 total)
  • Plugin Contributor yikesitskevin

    (@yikesitskevin)

    6 years, 10 months ago

    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)

    6 years, 10 months ago

    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)

    6 years, 10 months ago

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

    Thread Starter kumaresan

    (@kumaresanwp)

    6 years, 10 months ago

    Hi,

    Yes, it’s working fine now mate.

    F C

    (@pmagony)

    6 years, 9 months ago

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

    Thread Starter kumaresan

    (@kumaresanwp)

    6 years, 9 months ago

    Hi pmagony,

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

    F C

    (@pmagony)

    6 years, 9 months ago

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

    Thread Starter kumaresan

    (@kumaresanwp)

    6 years, 9 months ago

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

    F C

    (@pmagony)

    6 years, 9 months ago

    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)

    6 years, 9 months ago

    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 6 years, 9 months ago by kumaresan.
    F C

    (@pmagony)

    6 years, 9 months ago

    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 6 years, 9 months ago by F C.
    F C

    (@pmagony)

    6 years, 9 months ago

    https://pasteboard.co/GBEUVVL.png

    Thread Starter kumaresan

    (@kumaresanwp)

    6 years, 9 months ago

    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 kumaresandevacc@gmail.com

    • This reply was modified 6 years, 9 months ago by kumaresan.
    F C

    (@pmagony)

    6 years, 9 months ago

    Collation value for that column is UTF8MB4_unicode_520_ci

    Thread Starter kumaresan

    (@kumaresanwp)

    6 years, 9 months ago

    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 6 years, 9 months ago by kumaresan.
Viewing 15 replies - 1 through 15 (of 15 total)
  • The topic ‘Custom Tabs missing’ is closed to new replies.