WordPress.org

Forums

[resolved] New hosting, restored DB and getting errors (5 posts)

  1. thesiege
    Member
    Posted 7 years ago #

    I had an old host, i exported my DB in sql
    installed the new wordpress via telnet
    restored DB and getting errors when viewing
    no errors when editing or logged in as admin

    its kind of an old version of phpmyadmin
    any ideas

    cjweber.com/blog

    WordPress database error: [You have an error in your SQL syntax near '.* FROM wp_posts WHERE 1=1 AND (post_type = 'post' AND (post_status = 'publish' at line 1]
    SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND (post_type = 'post' AND (post_status = 'publish' OR post_status = 'private')) ORDER BY post_date DESC LIMIT 0, 10

    WordPress database error: [You have an error in your SQL syntax near '()' at line 1]
    SELECT FOUND_ROWS()

  2. MichaelH
    Member
    Posted 7 years ago #

    What version of WordPress? When you started this thread you said 2.3, but your site's source code says WordPress 2.2.

  3. thesiege
    Member
    Posted 7 years ago #

    really? hmm, i just installed the newest version
    ok i guess its 2.2

    here is where it was installed originally
    http://69.89.31.61/~myextraf/cjweber/blog/

  4. MichaelH
    Member
    Posted 7 years ago #

    What version of MySQL are you using?

    WordPress needs version 4.0 or higher.

  5. thesiege
    Member
    Posted 7 years ago #

    yeah its 3.23 or something like that, i will need to upgrade it, i hope i can do it without screwing things up

Topic Closed

This topic has been closed to new replies.

About this Topic