On Fri, Nov 4, 2011 at 10:24 PM, Steven Marshall
<
..hidden..> wrote:
> On Nov 4, 2011, at 5:20 PM, "David A. Bandel" <
..hidden..> wrote:
>
>> On Fri, Nov 4, 2011 at 11:11, Steven Marshall
>> <
..hidden..> wrote:
>>> I have brand new installation of 1.3.3 with I believe all prereqs.
>>>
>>> 1. Created Postgresql superuser "ledgersmb"
>>> 2. From browser navigate to
http://localhost/ledgersmb/setup.pl
>>> 3. On
setup.pl screen enter ledgersmb/password/foo for SuperUser Credentials
>>> and click Login button
>>> 4. On the Confirm Operation screen I select "Yes" to create database and
>>> click Next
>>> 5. On the Database Management Console screen select Country Code "Br" and
>>> click Next
>>
>> Did you check that you have postgresql-contrib (psql-contrib) and
>> enter your contrib (extension) directory location?
>>
>
> I confirmed my postgresql-contrib directory existed and was properly
> entered in Ledgersmb.conf. Looking at dblog_stderr it appears to be
> bombing in Pg-database.sql during the table creation of
> account_link_description where it is inserting values.
>
Here are the initial errors I see in dblog_stderr. I have uploaded all revelant logs to bug # 3433256 so you can see a more complete picture.
psql:/usr/share/postgresql/contrib/tsearch2.sql:548: NOTICE: argument type gtsvector is only a shell
psql:sql/Pg-database.sql:2: ERROR: syntax error at or near "EXTENSION" at character 8
psql:sql/Pg-database.sql:2: LINE 1: CREATE EXTENSION tablefunc;
psql:sql/Pg-database.sql:2: ^
psql:sql/Pg-database.sql:34: NOTICE: CREATE TABLE will create implicit sequence "account_heading_id_seq" for serial column "
account_heading.id"
psql:sql/Pg-database.sql:34: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "account_heading_pkey" for table "account_heading"
psql:sql/Pg-database.sql:34: NOTICE: CREATE TABLE / UNIQUE will create implicit index "account_heading_id_key" for table "account_heading"
psql:sql/Pg-database.sql:50: NOTICE: CREATE TABLE will create implicit sequence "account_id_seq" for serial column "
account.id"
psql:sql/Pg-database.sql:50: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "account_pkey" for table "account"
psql:sql/Pg-database.sql:50: NOTICE: CREATE TABLE / UNIQUE will create implicit index "account_id_key" for table "account"
psql:sql/Pg-database.sql:63: NOTICE: CREATE TABLE will create implicit sequence "account_checkpoint_id_seq" for serial column "
account_checkpoint.id"
psql:sql/Pg-database.sql:63: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "account_checkpoint_pkey" for table "account_checkpoint"
psql:sql/Pg-database.sql:63: NOTICE: CREATE TABLE / UNIQUE will create implicit index "account_checkpoint_id_key" for table "account_checkpoint"
psql:sql/Pg-database.sql:74: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "account_link_description_pkey" for table "account_link_description"
psql:sql/Pg-database.sql:112: ERROR: syntax error at or near "," at character 98
psql:sql/Pg-database.sql:112: LINE 4: ('AR', TRUE, FALSE),
psql:sql/Pg-database.sql:112: ^
psql:sql/Pg-database.sql:119: ERROR: current transaction is aborted, commands ignored until end of transaction block