Database error? (8 posts)

  1. Missychele
    Posted 10 years ago #

    Database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY seq' at line 5]
    SELECT wp_options.option_id, option_name, option_type, option_value, option_width, option_height, option_description, option_admin_level FROM wp_options LEFT JOIN wp_optiongroup_options ON wp_options.option_id = wp_optiongroup_options.option_id WHERE group_id = ORDER BY seq

    Warning: Invalid argument supplied for foreach() in /home/.dapper/stripedpink/stripedpinkbunny.com/blog/wp-admin/options.php on line 174

    I haven't really messed with WP in quite awhile, but decided I was going to change the style and WP won't let me update my options. I get the error message above. I using WP 1.2 I think. Any ideas?

  2. Mark (podz)
    Support Maven
    Posted 10 years ago #

    Where do you see this error ?

    You could do with upgrading too ....

  3. Missychele
    Posted 10 years ago #

    No, I can't upgrade! ;-) It took me forever to figure out 1.2 and I still haven't gotten it figured out.

    When I hit the update options button it brings me to another area, like permalinks or something. So I clicked on one of those other links and this message came up. You have any idea?

  4. Mark (podz)
    Support Maven
    Posted 10 years ago #

    Without knowing what other code may be going on I don't know.

    The reason you will get advice to upgrade is not just because 1.5.2 has themes that you may like, but because there is code out there that stupid script kiddies could use to damage your blog. 1.5.2 is protected against that. It is work that is worth doing.
    There is a guide here:
    which may help ? And ask anything you need ? This might also remove the db problem you have.

  5. Missychele
    Posted 10 years ago #

    Oh gosh! Okay, I'll give it a shot. Could I upload the new version to another sub-domain and keep this one up temporarily so I don't lose any entries between? I don't if I could upgrade or not without losing my posts. Most of them aren't worth keeping except the ones about my boys.

  6. Mark (podz)
    Support Maven
    Posted 10 years ago #

    Upgrading shouldn't take too long at all.
    The most important thing is to get a full copy of the database before you start - that has everything that matters inside it.

    Do you have cpanel ?

  7. Missychele
    Posted 10 years ago #

    Yes, I'm with dreamhost. They have a one-click install and that's how I installed it originally. And, I planned on doing it that way again, but I start reading how to upgrade and my eyes glaze over, and I feel like I'm not comprehending anything. I have dinner to get to and then I'm going to give it a shot.

    P.S Thank you for helping. ;-)

  8. Mark (podz)
    Support Maven
    Posted 10 years ago #

    If the glaze remains, I'll upgrade you if you'd like.
    I'd need access to everything to do that, but I promise not to break anything :)
    Email me if needed: tamba2 at gmail dot com

Topic Closed

This topic has been closed to new replies.

About this Topic