[
http://jira.undersunconsulting.com/browse/OFBIZ-73?page=all ]
Jacques Le Roux closed OFBIZ-73:
--------------------------------
Resolution: Fixed
Marco,
You are right, there is no more an UTC_TIME field so I close issue.
> SQL Exception creating WF_EVENT_AUDIT on Mysql 4.1
> --------------------------------------------------
>
> Key: OFBIZ-73
> URL:
http://jira.undersunconsulting.com/browse/OFBIZ-73> Project: [OFBiz] Open For Business
> Type: Bug
> Components: entity
> Versions: SVN
> Environment: MySQL 4.1.7-standard, RedHat
> Reporter: Paul Kulp
> Assignee: Jacques Le Roux
> Priority: Minor
>
>
> Entity engine attempts to create column named UTC_TIME which is reserved. Would be fine if field names were properly delimited - why aren't they?
> Log excerpt below:
> 29058[ DatabaseUtil.java:290:ERROR] Could not create table "WF_EVENT_AUDIT": SQL Exception while executing the following:
> CREATE TABLE WF_EVENT_AUDIT (EVENT_AUDIT_ID VARCHAR(20) NOT NULL, UTC_TIME VARCHAR(255), AUDIT_TYPE VARCHAR(255), PACKAGE_ID VARCHAR(255), PROCESS_ID VARCHAR(255), PROCESS_NAME VARCHAR(255), PROCESS_DEF_ID VARCHAR(255), PROCESS_DEF_NAME VARCHAR(255), PROCESS_DEF_VER VARCHAR(255), ACTIVITY_ID VARCHAR(255), ACTIVITY_NAME VARCHAR(255), ACTIVITY_DEF_ID VARCHAR(255), LAST_UPDATED_STAMP DATETIME, LAST_UPDATED_TX_STAMP DATETIME, CREATED_STAMP DATETIME, CREATED_TX_STAMP DATETIME, CONSTRAINT PK_WF_EVENT_AUDIT PRIMARY KEY (EVENT_AUDIT_ID))
> Error was: java.sql.SQLException: 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 'UTC_TIME VARCHAR(255), AUDIT_TYPE VARCHAR(255), PACKAGE_ID VARCHAR(255), PROCESS' at line 1"
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.undersunconsulting.com/secure/Administrators.jspa-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
Locked
