Cone's To Do List portlet configuration problem

["Dalton, Michael D" <Mi...@nasa.gov>]

I am attempting to configure Cone's To Do List portlet ( see http://jakarta.apache.org/jetspeed/site/community-portlets.html ) with Jetspeed and mySQL.  Having some problems.  I hope someone can lead me in the right direction.

I am:
- Using Jetspeed 1.4 final build (as-is war file with a couple of patches in modules)
- Running under Tomcat 4.1 and Windows 2000 server.
- Configured mySQL (latest stable build 4.0.17) as a Win 2000 service.
- Configured mySQL for Jetspeed user database.  Works OK!

I have:
- Downloaded http://www.cone.it/cone/saved_files/jetspeed-opensource/todolist-portlet-1.0.zip
- Compiled source and uploaded class files to WEB-INF/classes/com ...
- Uploaded your sql directory with the todolist sql scripts
- Uploaded the todolist velocity templates
- To Do List portlet comes up in Jetspeed and looks good with 2 pull down menus and 
	Category	Short description		Priority	Done		Actions 
- But nothing happens when you click on "Insert Item"

I think my problem is in configuring mySQL which I am new at using.  

I attempted to create a mySQL database called "todolist" (QUESTION: Did I need to do this?) and ran the todolist-schema.sql script but I get the following errors:
----------------------------------------------------------------------------------
Query OK, 0 rows affected (0.00 sec)

ERROR 1064: You have an error in your SQL syntax.  Check the manual that corresp
onds to your MySQL server version for the right syntax to use near 'NOT NULL,
    NAME VARCHAR (50) NOT NULL,
    PRIMARY KEY(CAT
Query OK, 0 rows affected (0.00 sec)

ERROR 1064: You have an error in your SQL syntax.  Check the manual that corresp
onds to your MySQL server version for the right syntax to use near '
    PRIORITY INTEGER (11) NOT NULL,
    USE_EXPIRATION INTEG
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.03 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.03 sec)
-----------------------------------------------------------------------------

Any idea what I am doing wrong?

Any help will be very much appreciated.

Thanks,

Michael Dalton

Michael.D.Dalton@nasa.gov
Internet Business Manager
Computing Systems Services Branch
Information Technology Directorate
IT-D3-A
Kennedy Space Center, FL 32899
(W) 321-861-2207 (F) 321-867-7133



---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org

Re: Cone's To Do List portlet configuration problem

[karthikeyan <ka...@email.unc.edu>]

Try This:

#
-----------------------------------------------------------------------
# PORTAL_TODOLIST_CATEGORY
#
-----------------------------------------------------------------------
drop table if exists PORTAL_TODOLIST_CATEGORY;

CREATE TABLE PORTAL_TODOLIST_CATEGORY
(
                    CATEGORY_ID INTEGER (11) NOT NULL AUTO_INCREMENT,
                    DESCRIPTION VARCHAR (250) NOT NULL,
                    NAME VARCHAR (50) NOT NULL,
    PRIMARY KEY(CATEGORY_ID)
);

#
-----------------------------------------------------------------------
# PORTAL_TODOLIST
#
-----------------------------------------------------------------------
drop table if exists PORTAL_TODOLIST;

CREATE TABLE PORTAL_TODOLIST
(
                    TODO_ID INTEGER (11)  NOT NULL AUTO_INCREMENT,
                    OWNER VARCHAR (50) NOT NULL,
                    SINGLE INTEGER default 0,
                    CATEGORY_ID INTEGER (11) NOT NULL,
                    SHORT_TEXT VARCHAR (100) NOT NULL,
                    LONG_TEXT VARCHAR (255),
                    PRIORITY INTEGER (11) NOT NULL,
                    USE_EXPIRATION INTEGER (11) NOT NULL,
                    EXPIRATION_DATE DATETIME,
                    DONE INTEGER default 0,
    PRIMARY KEY(TODO_ID),
    FOREIGN KEY (CATEGORY_ID) REFERENCES PORTAL_TODOLIST_CATEGORY
(CATEGORY_ID)
);

#
-----------------------------------------------------------------------
# PORTAL_TODOLIST_GROUP
#
-----------------------------------------------------------------------
drop table if exists PORTAL_TODOLIST_GROUP;

CREATE TABLE PORTAL_TODOLIST_GROUP
(
                    TODO_GROUP_ID INTEGER (11) NOT NULL AUTO_INCREMENT,
                    TODO_ID INTEGER (11) NOT NULL,
                    GROUP_NAME VARCHAR (50) NOT NULL,
    PRIMARY KEY(TODO_GROUP_ID),
    FOREIGN KEY (TODO_ID) REFERENCES PORTAL_TODOLIST (TODO_ID)
);

#
-----------------------------------------------------------------------
# PORTAL_TODOLIST_USER
#
-----------------------------------------------------------------------
drop table if exists PORTAL_TODOLIST_USER;

CREATE TABLE PORTAL_TODOLIST_USER
(
                    TODO_USER_ID INTEGER (11) NOT NULL AUTO_INCREMENT,
                    TODO_ID INTEGER (11) NOT NULL,
                    USER_NAME VARCHAR (50) NOT NULL,
    PRIMARY KEY(TODO_USER_ID),
    FOREIGN KEY (TODO_ID) REFERENCES PORTAL_TODOLIST (TODO_ID)
);


--
M. Karthikeyan, Ph.D., Scientist
 _|      _|    _|_|_|  _|
 _|_|    _|  _|        _|
 _|  _|  _|  _|        _|
 _|    _|_|  _|        _|
 _|      _| o  _|_|_|o _|_|_|_|
 National    Chemical  Laboratory
 Pune - 411 008, INDIA
 Ph: +91-(0)20-5893 457  FAX: 5893 973
 http://www.ncl-india.org/



---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org