Tabs have disappeared

  • Resolved edmtec

    (@edmtec)


    6 years, 4 months ago

    Hello,

    I have added tabs to over 2000 products.
    All had the same name (Referenz), but different content.
    I renamed all the tabs in the database from “Referenz” to “Entspricht” (German).
    Now no more tab is displayed. Not in the frontend and also not in the products in the admin.
    I renamed it back but nothing happened.

    Could you plkease help me?

Viewing 15 replies - 1 through 15 (of 16 total)
  • Plugin Contributor yikesitskevin

    (@yikesitskevin)

    Hi @edmtec,

    Due to the way we save the custom tabs (i.e. a serialized array), changing any property directly in the database will corrupt the tabs. However, changing the name back should have fixed the issue.

    Did you run any other search and replaces on the tabs directly from the database?

    Can you copy one of your product’s tabs directly from the database (i.e. the full value of yikes_woo_products_tabs) and paste it here? I’d like to figure out what is going wrong with the serialization and see if I can fix it.

    Thank you,
    Kevin.

    Thread Starter edmtec

    (@edmtec)

    I changed it directly in the database. I changed the names back but it did not work.
    Some are visible now but some not.

    Plugin Contributor yikesitskevin

    (@yikesitskevin)

    Did you run any other search and replaces in your database that may have affected the tabs?

    Thread Starter edmtec

    (@edmtec)

    no. What does the number of signs mean: content”;s:281:”

    I count the signs but it is not correct. Does ist have an effect?

    Plugin Contributor yikesitskevin

    (@yikesitskevin)

    s:281 means the following value should be a string with 281 characters.

    Can you send me a full value of one of these serialized strings?

    • This reply was modified 6 years, 4 months ago by yikesitskevin.
    Thread Starter edmtec

    (@edmtec)

    a:1:{i:0;a:3:{s:5:\”title\”;s:30:\”[:de]Referenz[:en]Reference[:]\”;s:2:\”id\”;s:16:\”technische-daten\”;s:7:\”content\”;s:1035:\”[:de]<table>
    <tbody>
    <tr>
    <td>Maschinentyp</td>
    <td>
    <div>

    FANUC, MATRA, SODICK

    </div></td>
    </tr>
    <tr>
    <td>Anwendung</td>
    <td>Drahterodieren</td>
    </tr>
    <tr>
    <td>Abmessungen</td>
    <td>260/29 x 346mm</td>
    </tr>
    <tr>
    <td>Filterfeinheit</td>
    <td>15 μm</td>
    </tr>
    <tr>
    <td>Anstr?mung</td>
    <td>von innen</td>
    </tr>
    <tr>
    <td>Filterfl?che</td>
    <td>5,17 m2</td>
    </tr>
    <tr>
    <td>Differenzdruck</td>
    <td>max. 3,0 bar</td>
    </tr>
    <tr>
    <td>Material</td>
    <td>Papierflies</td>
    </tr>
    </tbody>
    </table>[:en]<table>
    <tbody>
    <tr>
    <td>Machine type</td>
    <td>
    <div>FANUC, MATRA, SODICK</div></td>
    </tr>
    <tr>
    <td>Use</td>
    <td>Wire EDM</td>
    </tr>
    <tr>
    <td>Size</td>
    <td>260/29 x 346mm</td>
    </tr>
    <tr>
    <td>Filter density</td>
    <td>15 μm</td>
    </tr>
    <tr>
    <td>Flow</td>
    <td>from inside</td>
    </tr>
    <tr>
    <td>Filter Area</td>
    <td>5,17 m2</td>
    </tr>
    <tr>
    <td>Pressure diffenrential</td>
    <td>max. 3,0 bar</td>
    </tr>
    <tr>
    <td>Material</td>
    <td>Paper</td>
    </tr>
    </tbody>
    </table>
     [:]\”;}}”

    Plugin Contributor yikesitskevin

    (@yikesitskevin)

    Can you re-send that formatted with the code tags? The HTML is being interpreted by the browser so I can’t properly copy it.

    Thread Starter edmtec

    (@edmtec)

    INSERT INTO wp_postmeta VALUES (“83438″,”4093″,”yikes_woo_products_tabs”,”a:1:{i:0;a:3:{s:5:\”title\”;s:30:\”[:de]Referenz[:en]Reference[:]\”;s:2:\”id\”;s:16:\”technische-daten\”;s:7:\”content\”;s:1035:\”[:de]<table>
    <tbody>
    <tr>
    <td>Maschinentyp</td>
    <td>
    <div>

    FANUC, MATRA, SODICK

    </div></td>
    </tr>
    <tr>
    <td>Anwendung</td>
    <td>Drahterodieren</td>
    </tr>
    <tr>
    <td>Abmessungen</td>
    <td>260/29 x 346mm</td>
    </tr>
    <tr>
    <td>Filterfeinheit</td>
    <td>15 μm</td>
    </tr>
    <tr>
    <td>Anstr?mung</td>
    <td>von innen</td>
    </tr>
    <tr>
    <td>Filterfl?che</td>
    <td>5,17 m2</td>
    </tr>
    <tr>
    <td>Differenzdruck</td>
    <td>max. 3,0 bar</td>
    </tr>
    <tr>
    <td>Material</td>
    <td>Papierflies</td>
    </tr>
    </tbody>
    </table>[:en]<table>
    <tbody>
    <tr>
    <td>Machine type</td>
    <td>
    <div>FANUC, MATRA, SODICK</div></td>
    </tr>
    <tr>
    <td>Use</td>
    <td>Wire EDM</td>
    </tr>
    <tr>
    <td>Size</td>
    <td>260/29 x 346mm</td>
    </tr>
    <tr>
    <td>Filter density</td>
    <td>15 μm</td>
    </tr>
    <tr>
    <td>Flow</td>
    <td>from inside</td>
    </tr>
    <tr>
    <td>Filter Area</td>
    <td>5,17 m2</td>
    </tr>
    <tr>
    <td>Pressure diffenrential</td>
    <td>max. 3,0 bar</td>
    </tr>
    <tr>
    <td>Material</td>
    <td>Paper</td>
    </tr>
    </tbody>
    </table>
     [:]\”;}}”);

    Plugin Contributor yikesitskevin

    (@yikesitskevin)

    Use backticks or the code button around the whole thing please

    Thread Starter edmtec

    (@edmtec)

    INSERT INTO wp_postmeta VALUES (“83438″,”4093″,”yikes_woo_products_tabs”,”a:1:{i:0;a:3:{s:5:\”title\”;s:30:\”[:de]Referenz[:en]Reference[:]\”;s:2:\”id\”;s:16:\”technische-daten\”;s:7:\”content\”;s:1035:\”[:de]<table>
    <tbody>
    <tr>
    <td>Maschinentyp</td>
    <td>
    <div>

    FANUC, MATRA, SODICK

    </div></td>
    </tr>
    <tr>
    <td>Anwendung</td>
    <td>Drahterodieren</td>
    </tr>
    <tr>
    <td>Abmessungen</td>
    <td>260/29 x 346mm</td>
    </tr>
    <tr>
    <td>Filterfeinheit</td>
    <td>15 μm</td>
    </tr>
    <tr>
    <td>Anstr?mung</td>
    <td>von innen</td>
    </tr>
    <tr>
    <td>Filterfl?che</td>
    <td>5,17 m2</td>
    </tr>
    <tr>
    <td>Differenzdruck</td>
    <td>max. 3,0 bar</td>
    </tr>
    <tr>
    <td>Material</td>
    <td>Papierflies</td>
    </tr>
    </tbody>
    </table>[:en]<table>
    <tbody>
    <tr>
    <td>Machine type</td>
    <td>
    <div>FANUC, MATRA, SODICK</div></td>
    </tr>
    <tr>
    <td>Use</td>
    <td>Wire EDM</td>
    </tr>
    <tr>
    <td>Size</td>
    <td>260/29 x 346mm</td>
    </tr>
    <tr>
    <td>Filter density</td>
    <td>15 μm</td>
    </tr>
    <tr>
    <td>Flow</td>
    <td>from inside</td>
    </tr>
    <tr>
    <td>Filter Area</td>
    <td>5,17 m2</td>
    </tr>
    <tr>
    <td>Pressure diffenrential</td>
    <td>max. 3,0 bar</td>
    </tr>
    <tr>
    <td>Material</td>
    <td>Paper</td>
    </tr>
    </tbody>
    </table>
    [:]\”;}}”);

    Plugin Contributor yikesitskevin

    (@yikesitskevin)

    I’m having a hard time finding an issue with the data you sent. It seems to be valid from a serialization point of view. Do you have any database back ups?

    Thread Starter edmtec

    (@edmtec)

    A database backup does not solve my problem. What about my changes that get lost since the last backup?

    Plugin Contributor yikesitskevin

    (@yikesitskevin)

    Do you have the ability to filter the backup so it only includes the yikes_woo_products_tabs postmeta field?

    Plugin Contributor Tracy Levesque

    (@liljimmi)

    ?????? YIKES, Inc. Co-Owner

    Hello @edmtec,

    Just checking in.

    Please let us know if you still need help with this issue.

    Thank you!
    -Tracy

    Thread Starter edmtec

    (@edmtec)

    No thanks, i restored the database and everything works fine. I never will change data in the database. i will use tools in the future, this works.

Viewing 15 replies - 1 through 15 (of 16 total)
  • The topic ‘Tabs have disappeared’ is closed to new replies.