I haven't seen that error before, but since Roller is known to work on
MySQL 4.X, I wonder if you have some configuration problem -- or
perhaps the wrong version of the MySQL JDBC driver. What version of
the MySQL JDBC driver are you using?
- Dave
On 8/30/06, Lena <[EMAIL PROTECTED]> wrote:
Hi. I'm trying to install Roller 2.3 on Fedora Core 4 using MySQL 4.1.11 and
Tomcat 5.0.30 and getting this mysql syntax error:
ERROR 2006-08-30 17:22:42,309 lang:String) - Syntax error or access
violation, message from server: "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 '17:22:42 and this_.pubtime<=2006-08-30 17:25:42 order by
this_.pubtime desc' at line 1"
INFO 2006-08-30 17:22:42,387 servlet:FilterConfig) - {timeout=3600,
size=200}
ERROR 2006-08-30 17:22:42,493 lang:Integer) -
org.hibernate.exception.SQLGrammarException: could not execute query
INFO 2006-08-30 17:22:42,599 servlet:FilterConfig) - Initializing
if-modified cache
ERROR 2006-08-30 17:22:42,638 FuturePostingsInvalidationJob:execute() -
org.apache.roller.RollerException
It looks like the mysql query tries to test against pubtime values and the
values aren't in quotes.
What do I need to change to make it work?
Thanks,
lrazov
--
View this message in context:
http://www.nabble.com/MySQL-syntax-error-tf2188372s12275.html#a6054380
Sent from the Roller - User forum at Nabble.com.
