Maruthi a �crit :
Hello Stijn,
I tried with the files you sent.Still i am getting these errors.Anything wrong in the syntax again?.I copy and pasted the error message below.
Maruthi. ============================= Error Messages :: =============================
mysql> \. c:\jetspeed-1.5-src\src\sql\external\turbine-mysql.sql 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 '- implied. - drop table if exists TURBINE_USER' at line 1 Query OK, 0 rows affected (0.01 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.01 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.01 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.01 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 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 '- - CREATE TABLE EMAIL_INBOX ( EMAIL_INBOX_ID integer(11
---------------------------------
Do you Yahoo!?
Yahoo! Mail - Helps protect you from nasty viruses.
Hi tried this patch. there is bug on this file. <cid:[EMAIL PROTECTED]>
--
________________________
Xavier Arnaudin
Analyste-D�veloppeur Alienor Tel +33 (0)5 57 19 65 00
Fax +33 (0)5 57 19 65 01
-- MySQL dump 8.22 -- -- Host: localhost Database: senetrix_jetspeed --------------------------------------------------------- -- Server version 3.23.52-Max
-- -- Table structure for table 'JETSPEED_GROUP_PROFILE' -- CREATE TABLE JETSPEED_GROUP_PROFILE ( PSML_ID int(11) NOT NULL auto_increment, GROUP_NAME varchar(99) NOT NULL default '', MEDIA_TYPE varchar(99) default NULL, LANGUAGE char(2) default NULL, COUNTRY char(2) default NULL, PAGE varchar(99) default NULL, PROFILE blob, PRIMARY KEY (PSML_ID), UNIQUE KEY GROUP_NAME (GROUP_NAME,MEDIA_TYPE,LANGUAGE,COUNTRY,PAGE) ) TYPE=MyISAM; -- -- Dumping data for table 'JETSPEED_GROUP_PROFILE' -- -- -- Table structure for table 'JETSPEED_ROLE_PROFILE' -- CREATE TABLE JETSPEED_ROLE_PROFILE ( PSML_ID int(11) NOT NULL auto_increment, ROLE_NAME varchar(99) NOT NULL default '', MEDIA_TYPE varchar(99) default NULL, LANGUAGE char(2) default NULL, COUNTRY char(2) default NULL, PAGE varchar(99) default NULL, PROFILE blob, PRIMARY KEY (PSML_ID), UNIQUE KEY ROLE_NAME (ROLE_NAME,MEDIA_TYPE,LANGUAGE,COUNTRY,PAGE) ) TYPE=MyISAM; -- -- Dumping data for table 'JETSPEED_ROLE_PROFILE' -- -- -- Table structure for table 'JETSPEED_USER_PROFILE' -- CREATE TABLE JETSPEED_USER_PROFILE ( PSML_ID int(11) NOT NULL auto_increment, USER_NAME varchar(32) NOT NULL default '', MEDIA_TYPE varchar(99) default NULL, LANGUAGE char(2) default NULL, COUNTRY char(2) default NULL, PAGE varchar(99) default NULL, PROFILE blob, PRIMARY KEY (PSML_ID), UNIQUE KEY USER_NAME (USER_NAME,MEDIA_TYPE,LANGUAGE,COUNTRY,PAGE) ) TYPE=MyISAM; -- -- Dumping data for table 'JETSPEED_USER_PROFILE' -- -- -- Table structure for table 'TURBINE_GROUP' -- CREATE TABLE TURBINE_GROUP ( GROUP_ID int(11) NOT NULL auto_increment, GROUP_NAME varchar(99) NOT NULL default '', OBJECTDATA blob, PRIMARY KEY (GROUP_ID), UNIQUE KEY GROUP_NAME (GROUP_NAME) ) TYPE=MyISAM; -- -- Dumping data for table 'TURBINE_GROUP' -- INSERT INTO TURBINE_GROUP VALUES (1,'Jetspeed',NULL); INSERT INTO TURBINE_GROUP VALUES (2,'apache',NULL); -- -- Table structure for table 'TURBINE_PERMISSION' -- CREATE TABLE TURBINE_PERMISSION ( PERMISSION_ID int(11) NOT NULL auto_increment, PERMISSION_NAME varchar(99) NOT NULL default '', OBJECTDATA blob, PRIMARY KEY (PERMISSION_ID), UNIQUE KEY PERMISSION_NAME (PERMISSION_NAME) ) TYPE=MyISAM; -- -- Dumping data for table 'TURBINE_PERMISSION' -- INSERT INTO TURBINE_PERMISSION VALUES (1,'view',NULL); INSERT INTO TURBINE_PERMISSION VALUES (2,'customize',NULL); INSERT INTO TURBINE_PERMISSION VALUES (3,'maximize',NULL); INSERT INTO TURBINE_PERMISSION VALUES (4,'minimize',NULL); INSERT INTO TURBINE_PERMISSION VALUES (5,'personalize',NULL); INSERT INTO TURBINE_PERMISSION VALUES (6,'info',NULL); INSERT INTO TURBINE_PERMISSION VALUES (7,'close',NULL); INSERT INTO TURBINE_PERMISSION VALUES (8,'detach',NULL); -- -- Table structure for table 'TURBINE_ROLE' -- CREATE TABLE TURBINE_ROLE ( ROLE_ID int(11) NOT NULL auto_increment, ROLE_NAME varchar(99) NOT NULL default '', OBJECTDATA blob, PRIMARY KEY (ROLE_ID), UNIQUE KEY ROLE_NAME (ROLE_NAME) ) TYPE=MyISAM; -- -- Dumping data for table 'TURBINE_ROLE' -- INSERT INTO TURBINE_ROLE VALUES (1,'user',NULL); INSERT INTO TURBINE_ROLE VALUES (2,'admin',NULL); INSERT INTO TURBINE_ROLE VALUES (3,'guest',NULL); -- -- Table structure for table 'TURBINE_ROLE_PERMISSION' -- CREATE TABLE TURBINE_ROLE_PERMISSION ( ROLE_ID int(11) NOT NULL default '0', PERMISSION_ID int(11) NOT NULL default '0', PRIMARY KEY (ROLE_ID,PERMISSION_ID) ) TYPE=MyISAM; -- -- Dumping data for table 'TURBINE_ROLE_PERMISSION' -- INSERT INTO TURBINE_ROLE_PERMISSION VALUES (1,1); INSERT INTO TURBINE_ROLE_PERMISSION VALUES (1,2); INSERT INTO TURBINE_ROLE_PERMISSION VALUES (1,3); INSERT INTO TURBINE_ROLE_PERMISSION VALUES (1,4); INSERT INTO TURBINE_ROLE_PERMISSION VALUES (1,5); INSERT INTO TURBINE_ROLE_PERMISSION VALUES (1,6); INSERT INTO TURBINE_ROLE_PERMISSION VALUES (2,1); INSERT INTO TURBINE_ROLE_PERMISSION VALUES (2,2); INSERT INTO TURBINE_ROLE_PERMISSION VALUES (2,3); INSERT INTO TURBINE_ROLE_PERMISSION VALUES (2,4); INSERT INTO TURBINE_ROLE_PERMISSION VALUES (2,5); INSERT INTO TURBINE_ROLE_PERMISSION VALUES (2,6); INSERT INTO TURBINE_ROLE_PERMISSION VALUES (2,7); INSERT INTO TURBINE_ROLE_PERMISSION VALUES (3,1); INSERT INTO TURBINE_ROLE_PERMISSION VALUES (3,6); -- -- Table structure for table 'TURBINE_USER' -- CREATE TABLE TURBINE_USER ( USER_ID int(11) NOT NULL auto_increment, LOGIN_NAME varchar(32) NOT NULL default '', PASSWORD_VALUE varchar(32) NOT NULL default '', FIRST_NAME varchar(99) NOT NULL default '', LAST_NAME varchar(99) NOT NULL default '', EMAIL varchar(99) default NULL, CONFIRM_VALUE varchar(99) default NULL, MODIFIED timestamp(14) NOT NULL, CREATED timestamp(14) NOT NULL, LAST_LOGIN timestamp(14) NOT NULL, DISABLED char(1) default NULL, OBJECTDATA blob, PASSWORD_CHANGED timestamp(14) NOT NULL, PRIMARY KEY (USER_ID), UNIQUE KEY LOGIN_NAME (LOGIN_NAME) ) TYPE=MyISAM; -- -- Dumping data for table 'TURBINE_USER' -- INSERT INTO TURBINE_USER VALUES (1,'admin','jetspeed','Jetspeed','Admin','[EMAIL PROTECTED]','CONFIRMED',20031231005902,20031231005902,20021015184541,'F',NULL,20031231005902); INSERT INTO TURBINE_USER VALUES (2,'turbine','turbine','Tommy','Turbine','[EMAIL PROTECTED]','CONFIRMED',20031231005902,20031231005902,20021015184541,'F',NULL,20031231005902); INSERT INTO TURBINE_USER VALUES (3,'anon','anon','Anonymous','User','[EMAIL PROTECTED]','CONFIRMED',20031231005902,20031231005902,20021015184541,'F',NULL,20031231005902); -- -- Table structure for table 'TURBINE_USER_GROUP_ROLE' -- CREATE TABLE TURBINE_USER_GROUP_ROLE ( USER_ID int(11) NOT NULL default '0', GROUP_ID int(11) NOT NULL default '0', ROLE_ID int(11) NOT NULL default '0', PRIMARY KEY (USER_ID,GROUP_ID,ROLE_ID) ) TYPE=MyISAM; -- -- Dumping data for table 'TURBINE_USER_GROUP_ROLE' -- INSERT INTO TURBINE_USER_GROUP_ROLE VALUES (1,1,1); INSERT INTO TURBINE_USER_GROUP_ROLE VALUES (1,1,2); INSERT INTO TURBINE_USER_GROUP_ROLE VALUES (2,1,1); INSERT INTO TURBINE_USER_GROUP_ROLE VALUES (3,1,3);
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
