AnsweredAssumed Answered

error mysql: error in SQL syntax

Question asked by magrimbe on Aug 14, 2005
Hi,..

I use Alfresco with an excisting tomcat/mysql installation. It works almost fine. I can use the basic functionality (except creating rules), …but I always get an error message:
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
A system error occured during the operation: Bad SQL grammar [] in task 'Hibernate operation'; nested exception is java.sql.SQLException: 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 '?' at line 1
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

I use mysql version 4.1.8,…and jakarta-tomcat-5.0.30.

When try to make an content rule I get the following error message:

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
javax.faces.el.EvaluationException: Expression: #{NewRuleWizard.finish}

caused by:
org.alfresco.error.AlfrescoRuntimeException: Failed to create new rule

caused by:
org.springframework.jdbc.BadSqlGrammarException: Bad SQL grammar [] in task 'Hibernate operation'; nested exception is java.sql.SQLException: 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 '?' at line 1

caused by:
java.sql.SQLException: 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 '?' at line 1
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Does this sound familiar to someone?

Greetings
Rinus Grimberg

Outcomes