create_database.sql failed when I tried to load data. Fix below
---------------------------------------------------------------
Key: JUDDI-225
URL: https://issues.apache.org/jira/browse/JUDDI-225
Project: jUDDI
Issue Type: Bug
Components: core
Affects Versions: 2.0rc6
Environment: MySQL mysql-5.0.67
Reporter: Richard Qualis
Assignee: Kurt T Stam
When I tried to run the sql found in create_database.sql, it failed at the
following line.
ERROR LINE
==========================
INSERT INTO TMODEL
(TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
VALUES
('uuid:1E3E9CBC-F8CE-41ab-8F99-88326BAD324A','Administrator','admin','jUDDI.org','uddi-org:taxonomy_v2','http://www.uddi.org/taxonomies/UDDI_Registry_tModels.htm#TaxV2',CURTIMESTAMP());
THE FIX:
==============
I had t change CURTIMESTAMP() to CURRENT_TIMESTAMP() and it worked ok.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
