roller-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Edoardo Panfili <edoa...@aspix.it>
Subject Re: problems installig 4.0RC2
Date Mon, 17 Sep 2007 20:03:37 GMT
Dave ha scritto:
> On 9/17/07, Edoardo Panfili <edoardo@aspix.it> 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?
Yes, I can do it.

Edoardo

> 
> Thanks for the bug report.
> 
> - Dave


Mime
View raw message