|
#1
Nov 8, 2010, 06:21 PM
|
|
[SOLVED] Atahualpa Gets MySQL Error Message
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?
|
#2
Nov 8, 2010, 07:25 PM
|
|
|
|
23,765 posts · Mar 2009
OSX 10.11.5 WP 4.x Atahualpa(all) Safari, Firefox, Chrome
|
|
Does the default theme work?
__________________
"Tell me and I forget, teach me and I may remember, involve me and I learn." - Benjamin Franklin
Juggledad | Forum Moderator/Support
|
#3
Nov 8, 2010, 08:39 PM
|
|
Yes, the default theme works in all three situations.
|
#4
Nov 9, 2010, 03:37 AM
|
|
|
|
23,765 posts · Mar 2009
OSX 10.11.5 WP 4.x Atahualpa(all) Safari, Firefox, Chrome
|
|
What are the versions of atahualpa, wp, mysql and php?
__________________
"Tell me and I forget, teach me and I may remember, involve me and I learn." - Benjamin Franklin
Juggledad | Forum Moderator/Support
|
#5
Nov 9, 2010, 06:47 AM
|
|
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
|
#6
Nov 9, 2010, 06:52 AM
|
|
|
|
23,765 posts · Mar 2009
OSX 10.11.5 WP 4.x Atahualpa(all) Safari, Firefox, Chrome
|
|
from the wordpress page ( http://wordpress.org/about/requirements/)
Quote:
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
__________________
"Tell me and I forget, teach me and I may remember, involve me and I learn." - Benjamin Franklin
Juggledad | Forum Moderator/Support
|
|