WordPress.org

Forums

Modification in aq_options erased a part of my site (4 posts)

  1. JulieLap
    Member
    Posted 3 years ago #

    Hi,

    My WP theme contains a slider on the home page. This slider is customized in the theme’s options. I gave a long title to one of the slide which made it impossible to delete or modify afterwards: the long title made the arrow that can open the slide’s options disappear.

    This title is stored in the wp_options. I tried to shorten it by modifying it in the database:
    In PHP MySQL, I chose wp_options/aq_options. I clicked on “modify” which opened a new window with all the info stored in aq_options. I shortened the title and clicked on “execute”.

    Then all the customized items disappeared: the logo, the slider, the widgets, the access to the English version of the site, the sidebars...

    The only thing I modified was the long title. Here is the before and after (look for “Enregistrement des Golberg”):

    Before:
    {s:5:"order";s:1:"3";s:5:"title";s:58:" Enregistrement des Goldberg en vente en ligne maintenant!";s:3:"url";s:67:"http://davidjalbert.com/dev/wp-content/uploads/2012/03/slider04.jpg";s:4:"link";s:27:"?post_type=portfolio&p=1450";s:11:"description";s:267:"<a href="?post_type=portfolio&p=1450">L''enregistrement des Variations Goldberg</a> de Bach par David Jalbert est maintenant disponible en primeur en ligne, sur le magasin iTunes et autres sites. Le disque lui-même sera disponible en magasin à compter du 27 mars.";s:5:"embed";s:0:"";}}

    After:
    {s:5:"order";s:1:"3";s:5:"title";s:58:"Enregistrement des Goldberg";s:3:"url";s:67:"http://davidjalbert.com/dev/wp-content/uploads/2012/03/slider04.jpg";s:4:"link";s:27:"?post_type=portfolio&p=1450";s:11:"description";s:267:"<a href="?post_type=portfolio&p=1450">L'enregistrement des Variations Goldberg</a> de Bach par David Jalbert est maintenant disponible en primeur en ligne, sur le magasin iTunes et autres sites. Le disque lui-même sera disponible en magasin à compter du 27 mars.";s:5:"embed";s:0:"";}}

    What did I do wrong?
    Is there a way to revert to the previous version?

    Thank you for you help!

  2. robahas
    Member
    Posted 3 years ago #

    Now that you have shortened the title, can you delete that slide? Or can you delete the slide entry in wp_options? Then start again with a shorter name. Probably easier than figuring out how to edit that info.

  3. JulieLap
    Member
    Posted 3 years ago #

    Hello Robahas,

    Since I have shortened the title, the slides seem to no longer exist in the wp dashboard/theme options. Everything I had customized in there is gone.

    My pages and posts are available via the dashboard, though the sidebar of the portfolio section do not show up anymore in the front end. Except for the French menu, everything is gone in my home page.

    For what I just read on a thread, it seems that aq_options was a serialized data and I should not have touched it! I would like to know if it's possible to fix this. The only thing I did was removing five words in the title's content.

  4. JulieLap
    Member
    Posted 3 years ago #

    The problem is fixed! I had to include the missing characters in the string. There were 58 to start with, so I had to insert "empty" characters to equal that amount.

Topic Closed

This topic has been closed to new replies.

About this Topic