Hi. I'm using mysql-connector-java-3.0.14-production-bin.jar library.
The other thing I probably should tell you is Tomcat 5.0.30 is compiled with
gcj which comes with Fedora core 4 installation.
Thanks,
-lrazov
Dave Johnson-8 wrote:
>
> 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.
>>
>>
>
>
--
View this message in context:
http://www.nabble.com/MySQL-syntax-error-tf2188372s12275.html#a6070003
Sent from the Roller - User forum at Nabble.com.
