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-t
f2188372s12275.html#a6054380
Sent from the Roller - User forum at Nabble.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 <lrazovflexsoft.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-t
f2188372s12275.html#a6054380
> Sent from the Roller - User forum at Nabble.com.
>
>

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 <lrazovflexsoft.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-t
f2188372s12275.html#a6054380
>> Sent from the Roller - User forum at Nabble.com.
>>
>>
> 
> 

-- 
View this message in context: http://www.nabble.com/MySQL-syntax-error-t
f2188372s12275.html#a6070003
Sent from the Roller - User forum at Nabble.com.

On 8/30/06, Lena <lrazovflexsoft.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

Got it working by uninstalling gcj and using Sun java.

Thanks.


Dave Johnson-8 wrote:
> 
> On 8/30/06, Lena <lrazovflexsoft.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-t
f2188372s12275.html#a6128729
Sent from the Roller - User forum at Nabble.com.