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]