Hi,

I had previously changed the jetspeed user database from hsqldb to mysql.
However on jetspeed 1.5 I get errors running the turbine-mysql.sql script:

Anybody know what they are (and how to fix them)?
-Stijn

-----
mysql> use codamo;
Database changed
mysql> source
C:/bit/dev/project/bergland-portal/jetspeed/src/sql/external/turbine-mysql.s
ql
ERROR 1064: 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
'IDENTITY,
    PERMISSION_NAME VARCHAR (99) NOT NULL,
    OBJE
ERROR 1064: 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
'IDENTITY,
    ROLE_NAME VARCHAR (99) NOT NULL,
    OBJECTDATA
ERROR 1064: 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
'IDENTITY,
    GROUP_NAME VARCHAR (99) NOT NULL,
    OBJECTDAT
Query OK, 0 rows affected (0.02 sec)

Query OK, 0 rows affected (0.00 sec)
Records: 0  Duplicates: 0  Warnings: 0

ERROR 1064: 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
'IDENTITY,
    LOGIN_NAME VARCHAR (32) NOT NULL,
    PASSWORD_
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.02 sec)

ERROR 1064: 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
'IDENTITY,
    COFFEE_NAME VARCHAR (50),
    SUPPLIER_ID integ
Query OK, 0 rows affected (0.00 sec)
-----


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to