After running 1.3 with no problem for a year or more, I just upgraded to R2 on my Fedora system at eHa.no-ip.org about two weeks ago. Since then, about every three days, apache emails me (the root user) about an error, using the subject heading "Unknown column 'posts' in 'order clause'" In the five years I've been running my web server, Apache's never emailed me about an error, only ever using the error logs, so this email notification is a feature I never knew I had. In any case, not being expert enough I simply don't understand the error: my R2 installation appears to be working fine in every way. I could just proceed to ignore the warnings and not worry, but if anyone can shed light on this situation I'd appreciate it. The complete text of the email Apache sends me is as follows. I don't see any basis for a misspelled timezone identifier, or whatever it's complaining about:

- 2.0.0 - Mon Mar 10 14:38:10 2008

---

1. USER AGENT: Mozilla/5.0 (compatible; Yahoo! Slurp;

http://help.yahoo.com/help/us/ysearch/slurp)

1. ACCT: ID: -1 - Login: guest - e-mail: guest@localhost
2. URL: http://eha.no-ip.org/eHa/blogs/list_blogs.php?sort_mode=posts_desc
3. HOST: eha.no-ip.org
4. IP: 74.6.21.112
5. PHP: It is not safe to rely on the system's timezone settings. Please use the

date.timezone setting, the TZ environment variable or the
date_default_timezone_set() function. In case you used any of those methods and
you are still getting this warning, you most likely misspelled the timezone
identifier. We selected 'America/Los_Angeles' for 'PDT/-7.0/DST' instead

1. SQL: SELECT b.`content_id` AS `hash_key`, b.*, uu.`login`, uu.`real_name`,

lc.*, lch.hits ,gks.`security_id`, gks.`security_description`, gks.`is_private`,
gks.`is_hidden`, gks.`access_question`, gks.`access_answer` FROM `blogs` b
INNER JOIN `liberty_content` lc ON (lc.`content_id` = b.`content_id`) INNER
JOIN `users_users` uu ON (uu.`user_id` = lc.`user_id`) LEFT OUTER JOIN
`gatekeeper_security_map` cg ON (lc.`content_id`=cg.`content_id`) LEFT OUTER JOIN
`gatekeeper_security` gks ON (gks.`security_id`=cg.`security_id` ) LEFT OUTER
JOIN `liberty_content_hits` lch ON (lc.`content_id` = lch.`content_id`) WHERE
(cg.`security_id` IS NULL OR lc.`user_id`='-1') order by `posts` DESC

1. ERROR CODE: Errno: 1054 Message: Unknown column 'posts' in 'order clause'

}}}}}}} -> bit_error_string(Array6)
}}}}}}} LINE: 638, /var/www/html/eHa/kernel/BitDbAdodb.php
}}}}}} -> bit_error_handler(mysql, EXECUTE, 1054, Unknown column 'posts' in
'order clause', SELECT b.`content_id` AS `hash_key`, b.*, uu.`login`,
uu.`real_n..., false, Object:ADODB_mysql)
}}}}}} LINE: 916, /var/www/html/eHa/util/adodb/adodb.inc.php
}}}}} -> ADOConnection::_Execute(SELECT b.`content_id` AS `hash_key`, b.*,
uu.`login`, uu.`real_n...)
}}}}} LINE: 872, /var/www/html/eHa/util/adodb/adodb.inc.php
}}}} -> ADOConnectionExecute(SELECT b.`content_id` AS
`hash_key`, b.*, uu.`login`, uu.`real_n..., Array1)
}}}} LINE: 1266, /var/www/html/eHa/util/adodb/adodb.inc.php
}}} -> ADOConnectionADOConnection::GetAssoc(SELECT
b.`content_id` AS `hash_key`, b.*, uu.`login`, uu.`real_n..., Array1, 10, 0)
}}} LINE: 378, /var/www/html/eHa/kernel/BitDbAdodb.php
}} -> ADOConnectionADOConnectiongetAssoc(
SELECT b.`content_id` AS `hash_key`, b.*, uu.`login`, uu.`re..., Array1, 10, 0)
}} LINE: 273, /var/www/html/eHa/blogs/BitBlog.php
} ->
ADOConnectionADOConnectionBitBlog::getList(Array10)
} LINE: 39, /var/www/html/eHa/blogs/list_blogs.php


$_GET:
array (
'sort_mode' => 'posts_desc',
)

I posted this question. I came up as anonymous apparently because of a cookie issue.

This thread belongs in the Support forum, not here. I restarted the thread there, so please delete this one.