I am sorry if this is not the right place to post, I try with bug report
but it always say "You have not selected a valid project to create an
issue in."
I can't create the tables for roller, During table creation phase
ENV:-------------------------------------------------------------
roller 4.0RC2
psql 8.2.4
java version "1.5.0_07"
Darwin Kernel Version 8.10.1
Mac OS X 10.4.10
-----------------------------------------------------------------
http://localhost:8080/roller/roller-ui/install/install!create.rol
-----------------------------------------------------------------
ERROR running SQL in database creation script
-----------------------------------------------------------------
in roller.log
-----------------------------------------------------------------
INFO 2007-09-17 20:24:37,639 PlanetCache:<init> - Planet cache =
{timeout=1800, enabled=true, size=10, id=cache.planet}
INFO 2007-09-17 20:24:37,641 PreviewThemeImageServlet:init -
Initializing PreviewThemeImageServlet
INFO 2007-09-17 20:24:37,642 PreviewResourceServlet:init - Initializing
PreviewResourceServlet
INFO 2007-09-17 20:24:37,646 PreviewServlet:init - Initializing
PreviewServlet
INFO 2007-09-17 20:25:07,561 DatabaseInstaller:createDatabase -
Creating Roller Weblogger database tables.
ERROR 2007-09-17 20:25:07,636 DatabaseInstaller:errorMessage - ERROR
running SQL in database creation script
-----------------------------------------------------------------
in postgresql.log
-----------------------------------------------------------------
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"rolleruser_pkey" for table "rolleruser"
NOTICE: ALTER TABLE / ADD UNIQUE will create implicit index
"ru_username_uq" for table "rolleruser"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"userrole_pkey" for table "userrole"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"roller_user_permissions_pkey" for table "roller_user_permissions"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"roller_audit_log_pkey" for table "roller_audit_log"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"usercookie_pkey" for table "usercookie"
ERROR: insufficient data left in message
-----------------------------------------------------------------
I did I try with manual database creation
psql -U roller rollerdb <WEB-INF/classes/dbscripts/postgresql/createdb.sql
-----------------------------------------------------------------
ERROR: syntax error at or near "text"
LINE 204: contenttype varchar(128) default 'text/plain' not null
-----------------------------------------------------------------
I did another try: copy the table definition and paste it into
pgadminIII, it works, but there are other similar problems.
Edoardo Panfili
