On 9/17/07, Edoardo Panfili <[EMAIL PROTECTED]> wrote: > 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."
This is the right place. > 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 > ----------------------------------------------------------------- > ERROR 2007-09-17 20:25:07,636 DatabaseInstaller:errorMessage - ERROR > running SQL in database creation script > ----------------------------------------------------------------- > > in postgresql.log > ----------------------------------------------------------------- > ERROR: insufficient data left in message Hmm. I wonder what that means. > ----------------------------------------------------------------- > 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 Looks like we're using the wrong syntax for PostgreSQL here. If I get you a replacement createdb.sql file, are you willing to test it with a fresh new database? Thanks for the bug report. - Dave
