On Sat, Nov 5, 2011 at 4:35 AM, Chris Travers <chris.trav...@gmail.com>wrote:
> On Fri, Nov 4, 2011 at 10:24 PM, Steven Marshall
> <steven.marsh...@tekmerge.com> wrote:
> > On Nov 4, 2011, at 5:20 PM, "David A. Bandel" <david.ban...@gmail.com>
> wrote:
> >
> >> On Fri, Nov 4, 2011 at 11:11, Steven Marshall
> >> <steven.marsh...@tatylee.com> 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.
> >
> What's the error?
>
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
>
> Best Wishes,
> Chris Travers
>
>
> ------------------------------------------------------------------------------
> RSA(R) Conference 2012
> Save $700 by Nov 18
> Register now
> http://p.sf.net/sfu/rsa-sfdev2dev1
> _______________________________________________
> Ledger-smb-users mailing list
> Ledger-smb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>
------------------------------------------------------------------------------
RSA(R) Conference 2012
Save $700 by Nov 18
Register now
http://p.sf.net/sfu/rsa-sfdev2dev1
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
