You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@juddi.apache.org by "Richard Qualis (JIRA)" <ju...@ws.apache.org> on 2009/04/29 03:41:31 UTC

[jira] Created: (JUDDI-225) create_database.sql failed when I tried to load data. Fix below

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.


[jira] Closed: (JUDDI-225) create_database.sql failed when I tried to load data. Fix below

Posted by "Kurt T Stam (JIRA)" <ju...@ws.apache.org>.
     [ https://issues.apache.org/jira/browse/JUDDI-225?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kurt T Stam closed JUDDI-225.
-----------------------------

    Resolution: Fixed

Applied fix

> 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
>             Fix For: 2.0rc7
>
>
> 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.


[jira] Updated: (JUDDI-225) create_database.sql failed when I tried to load data. Fix below

Posted by "Kurt T Stam (JIRA)" <ju...@ws.apache.org>.
     [ https://issues.apache.org/jira/browse/JUDDI-225?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kurt T Stam updated JUDDI-225:
------------------------------

    Fix Version/s: 2.0rc7

> 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
>             Fix For: 2.0rc7
>
>
> 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.