• I’ve upgraded my site but got this strange message on the left columm:

    WordPress database error: [Unknown column ‘a’ in ‘order clause’]
    SELECT * FROM wp_posts WHERE (post_type = ‘page’ AND post_status = ‘publish’) AND ( ID <> 0 ) ORDER BY a ASC

    also the characters, got strange like:
    A tradição mianmar é uma das mais fortes do budismo. Pagodes e monastérios se espalham pelo país e, em grande medida, são sua principal atração turística

    instead of
    A tradição mianmar é uma das mais fortes do budismo. Pagodes e monastérios se espalham pelo paí­s e, em grande medida, são sua principal atração turí­stica

    I’m writing on portuguese so ç ã í are very helpfull 😉

    any ideas?

    thanks

    zagg

Viewing 3 replies - 1 through 3 (of 3 total)
  • I’d say this part of the code
    ORDER BY a ASC

    should be
    ORDER BY xxxx ASC

    where xxxx is a valid name of a column in the wp_posts table.

    Also if you upgraded from a version before 2.2 then you might want to read the information about Database Character Set and Database collation. In short you may need to add:

    define('DB_CHARSET', 'utf8');
    define('DB_COLLATE', '');

    to your wp-config.php file.

    Thread Starter zagg

    (@zagg)

    Thanks MichaelH, but still not working. News post are ok, the problem is the old ones coming with that character error.

    and also that strange message on the left sidebar “WordPress database error: [Unknown column ‘a’ in ‘order clause’]
    SELECT * FROM wp_posts WHERE (post_type = ‘page’ AND post_status = ‘publish’) AND ( ID <> 0 ) ORDER BY a ASC”

    using phpMyAdmin 2.5.6, MySQL 4.1.11-Debian_4sarge2-log

    any help?
    zagg

    Do not use your old wp-config.php but update then rename the new wp-config-sample.php. It’s slightly different.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘upgrade problem’ is closed to new replies.