I get the following error message when I try to use the Atahualpa theme on a brand-new Wordpress site (nothing done after the install but switch to Atahualpa). This happens on two commercial hosting services. When I run the site on my own box, it works fine. The hosts that don't work are the newest and oldest versions of PHP and MySql. My own box, which works, has versions of PHP and MySql in between.

The message in the error log is:

[08-Nov-2010 17:07:13] WordPress 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 'ASC' at line 1 for query SELECT * FROM wp_sb_posts WHERE (post_type = 'page' AND post_status = 'publish') ORDER BY ASC made by require, require_once, include, get_header, locate_template, load_template, require_once, bfa_header_config, bfa_hor_pages, wp_list_pages, get_pages

Any hints as to what might be wrong?

Does the default theme work?

Yes, the default theme works in all three situations.

What are the versions of atahualpa, wp, mysql and php?

Host 1 (MySql Error)
MySql version: 5.1.48
PHP version: 5.2.14
WP version: 3.0.1
Atahualpa version: 3.4.9


Host 2 (MySql Error)
MySql version: 4.1.11
PHP version: 4.4.8-0.dotdeb.0
WP version: 3.0.1
Atahualpa version: 3.4.9


Host 31 (No MySql Error)
MySql version: 5.0.51a
PHP version: 5.2.4-2ubuntu5.3
WP version: 3.0.1
Atahualpa version: 3.4.9

from the wordpress page (http://wordpress.org/about/requirements/)

To run WordPress your host just needs a couple of things:
PHP version 4.3 or greater
MySQL version 4.1.2 or greater

your host2 is at 4.1.11