Exception in Customer Care > Customer Scroll Down

[rajnish]

Dear All,

I get this exception when Customer Care > Customer and scroll down.

Any help is appreciated.

Regards,
Rajnish.

Code: Select all

[ WARN] 04:01:13 JDBCExceptionReporter - SQL Error: 1064, SQLState: 42000
[ERROR] 04:01:13 JDBCExceptionReporter - 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 'offset 75 limit 75' at line 1
[ERROR] 04:01:13 BasicPersistenceModule - Problem fetching results for org.broadleafcommerce.core.order.domain.Order
org.hibernate.exception.SQLGrammarException: could not execute query
   at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
.
.
.
   at java.lang.Thread.run(Thread.java:662)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'offset 75 limit 75' at line 1
   at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
.
.


[rajnish]

Found the solution,

the dialect was missing:

added the common-shared.properties with following content to make it work:

Code: Select all

blPU.hibernate.show_sql=false
blPU.hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect
blSecurePU.hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect
blCMSStorage.hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect