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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
