hi,
i have changed the database to mysql by following the guidelines given on
https://cwiki.apache.org/confluence/display/OFBIZ/How+to+migrate+OfBiz+from+Derby+to+MySQL+databaseit seems to be making new data as the party id is starting from 10000 again but when i am trying to search that particular party id is showing this error.
ERROR:-->
org.ofbiz.widget.screen.ScreenRenderException: Error rendering screen [component://party/widget/partymgr/CommonScreens.xml#main-decorator]: org.ofbiz.entity.transaction.GenericTransactionException: The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Error in Service [findParty]: Failure in party find operation, rolling back transaction: org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT DISTINCT PT.PARTY_ID, PT.STATUS_ID, PT.PARTY_TYPE_ID, PT.CREATED_DATE, PT.LAST_MODIFIED_DATE FROM PARTY PT WHERE (((PT.STATUS_ID IS NULL OR PT.STATUS_ID <> ?))) (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 'OPTION SQL_SELECT_LIMIT=20' at line 1) (The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Error in Service [findParty]: Failure in party find operation, rolling back transaction: org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT DISTINCT PT.PARTY_ID, PT.STATUS_ID, PT.PARTY_TYPE_ID, PT.CREATED_DATE, PT.LAST_MODIFIED_DATE FROM PARTY PT WHERE (((PT.STATUS_ID IS NULL OR PT.STATUS_ID <> ?))) (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 'OPTION SQL_SELECT_LIMIT=20' at line 1))
please guide what to do?