You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@roller.apache.org by Lena <lr...@flexsoft.com.au> on 2006/08/30 10:11:38 UTC
MySQL syntax error
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.
Re: MySQL syntax error
Posted by Lena <lr...@flexsoft.com.au>.
Got it working by uninstalling gcj and using Sun java.
Thanks.
Dave Johnson-8 wrote:
>
> On 8/30/06, Lena <lr...@flexsoft.com.au> wrote:
>> 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.
>
> Connector/J 3.0.14 sounds right, but gcj generally spells trouble for
> Roller.
>
> - Dave
>
>
--
View this message in context: http://www.nabble.com/MySQL-syntax-error-tf2188372s12275.html#a6128729
Sent from the Roller - User forum at Nabble.com.
Re: MySQL syntax error
Posted by Dave Johnson <sn...@gmail.com>.
On 8/30/06, Lena <lr...@flexsoft.com.au> wrote:
> 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.
Connector/J 3.0.14 sounds right, but gcj generally spells trouble for Roller.
- Dave
Re: MySQL syntax error
Posted by Lena <lr...@flexsoft.com.au>.
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 <lr...@flexsoft.com.au> 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.
Re: MySQL syntax error
Posted by Dave Johnson <sn...@gmail.com>.
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 <lr...@flexsoft.com.au> 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.
>
>