[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Error upgrading Database for 1.4 beta

Subject: Error upgrading Database for 1.4 beta
From: Jigme Datse Yli-Rasku <..hidden..>
Date: Mon, 19 Nov 2012 07:59:09 -0800
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I just went and tried to upgrade my database and get the following
HTML error:

Error!

file error - -1.4.sql: not found at LedgerSMB/Template/TXT.pm line 131.

dbversion: 1.3.999, company:

and the following error_log errors:

(this may be more information than is relevant, but it is all coming up):

[Mon Nov 19 07:46:28 2012] [error] [client 127.0.0.1] DBI
connect('dbname=template1','',...) failed: FATAL:  role "_www" does
not exist at LedgerSMB.pm line 868., referer:
http://localhost/ledgersmb1.4/setup.pl
[Mon Nov 19 07:46:31 2012] [error] [client 127.0.0.1] DBD::Pg::st
execute failed: ERROR:  column "version" does not exist, referer:
http://localhost/ledgersmb1.4/setup.pl
[Mon Nov 19 07:46:31 2012] [error] [client 127.0.0.1] LINE 1: SELECT
version FROM defaults, referer: http://localhost/ledgersmb1.4/setup.pl
[Mon Nov 19 07:46:31 2012] [error] [client 127.0.0.1]                ^
at LedgerSMB/Database.pm line 328., referer:
http://localhost/ledgersmb1.4/setup.pl
[Mon Nov 19 07:46:39 2012] [error] [client 127.0.0.1] DBD::Pg::st
execute failed: ERROR:  column "version" does not exist, referer:
http://localhost/ledgersmb1.4/setup.pl
[Mon Nov 19 07:46:39 2012] [error] [client 127.0.0.1] LINE 1: SELECT
version FROM defaults, referer: http://localhost/ledgersmb1.4/setup.pl
[Mon Nov 19 07:46:39 2012] [error] [client 127.0.0.1]                ^
at LedgerSMB/Database.pm line 328., referer:
http://localhost/ledgersmb1.4/setup.pl
[Mon Nov 19 07:46:40 2012] [error] [client 127.0.0.1] Issuing
rollback() due to DESTROY without explicit disconnect() of DBD::Pg::db
handle dbname=DatseMultimedia2 at lsmb-request.pl line 109., referer:
http://localhost/ledgersmb1.4/setup.pl
[Mon Nov 19 07:47:26 2012] [error] [client 127.0.0.1] DBD::Pg::st
execute failed: ERROR:  relation "defaults" does not exist, referer:
http://localhost/ledgersmb1.4/setup.pl
[Mon Nov 19 07:47:26 2012] [error] [client 127.0.0.1] LINE 1: SELECT
version FROM defaults, referer: http://localhost/ledgersmb1.4/setup.pl
[Mon Nov 19 07:47:26 2012] [error] [client 127.0.0.1]
            ^ at LedgerSMB/Database.pm line 328., referer:
http://localhost/ledgersmb1.4/setup.pl
[Mon Nov 19 07:47:26 2012] [error] [client 127.0.0.1] DBD::Pg::st
execute failed: ERROR:  relation "defaults" does not exist, referer:
http://localhost/ledgersmb1.4/setup.pl
[Mon Nov 19 07:47:26 2012] [error] [client 127.0.0.1] LINE 1: SELECT
value FROM defaults WHERE setting_key = $1, referer:
http://localhost/ledgersmb1.4/setup.pl
[Mon Nov 19 07:47:26 2012] [error] [client 127.0.0.1]
          ^ at LedgerSMB/Database.pm line 343., referer:
http://localhost/ledgersmb1.4/setup.pl
[Mon Nov 19 07:47:26 2012] [error] [client 127.0.0.1] DBD::Pg::st
fetchrow_hashref failed: no statement executing at
LedgerSMB/Database.pm line 344., referer:
http://localhost/ledgersmb1.4/setup.pl
[Mon Nov 19 07:47:26 2012] [error] [client 127.0.0.1] DBD::Pg::st
execute failed: ERROR:  relation "defaults" does not exist, referer:
http://localhost/ledgersmb1.4/setup.pl
[Mon Nov 19 07:47:26 2012] [error] [client 127.0.0.1] LINE 1: SELECT
fldvalue FROM defaults WHERE fldname = $1, referer:
http://localhost/ledgersmb1.4/setup.pl
[Mon Nov 19 07:47:26 2012] [error] [client 127.0.0.1]
             ^ at LedgerSMB/Database.pm line 363., referer:
http://localhost/ledgersmb1.4/setup.pl
[Mon Nov 19 07:47:26 2012] [error] [client 127.0.0.1] DBD::Pg::st
fetchrow_hashref failed: no statement executing at
LedgerSMB/Database.pm line 364., referer:
http://localhost/ledgersmb1.4/setup.pl
[Mon Nov 19 07:47:26 2012] [error] [client 127.0.0.1] rollback
ineffective with AutoCommit enabled at lsmb-request.pl line 117.,
referer: http://localhost/ledgersmb1.4/setup.pl
[Mon Nov 19 07:47:26 2012] [error] [client 127.0.0.1] commit
ineffective with AutoCommit enabled at LedgerSMB/App_State.pm line
135., referer: http://localhost/ledgersmb1.4/setup.pl
[Mon Nov 19 07:47:26 2012] [error] [client 127.0.0.1] 2012/11/19
07:47:26 - ERROR - LedgerSMB::error LedgerSMB.pm (820) -- file error -
- -1.4.sql: not found at LedgerSMB/Template/TXT.pm line 131., referer:
http://localhost/ledgersmb1.4/setup.pl
[Mon Nov 19 07:47:26 2012] [error] [client 127.0.0.1] 2012/11/19
07:47:26 - ERROR - LedgerSMB::error LedgerSMB.pm (821) -- dbversion:
1.3.999, company: , referer: http://localhost/ledgersmb1.4/setup.pl
[Mon Nov 19 07:47:26 2012] [error] [client 127.0.0.1] Directory index
forbidden by Options directive: /usr/local/ledgersmb1.4/css/, referer:
http://localhost/ledgersmb1.4/setup.pl
[Mon Nov 19 07:47:27 2012] [error] [client 127.0.0.1] File does not
exist: /Library/WebServer/Documents/favicon.ico
[Mon Nov 19 07:50:13 2012] [error] [client 127.0.0.1] DBI
connect('dbname=DatseMultimedia2','',...) failed: FATAL:  role "_www"
does not exist at LedgerSMB.pm line 868., referer:
http://localhost/ledgersmb1.4/login.pl
[Mon Nov 19 07:50:16 2012] [error] [client 127.0.0.1] DBD::Pg::st
execute failed: ERROR:  relation "defaults" does not exist, referer:
http://localhost/ledgersmb1.4/login.pl
[Mon Nov 19 07:50:16 2012] [error] [client 127.0.0.1] LINE 2:
    SELECT value FROM defaults , referer:
http://localhost/ledgersmb1.4/login.pl
[Mon Nov 19 07:50:16 2012] [error] [client 127.0.0.1]
                      ^ at LedgerSMB.pm line 899., referer:
http://localhost/ledgersmb1.4/login.pl
[Mon Nov 19 07:50:16 2012] [error] [client 127.0.0.1] DBD::Pg::st
fetchrow_array failed: no statement executing at LedgerSMB.pm line
900., referer: http://localhost/ledgersmb1.4/login.pl
[Mon Nov 19 07:50:16 2012] [error] [client 127.0.0.1] DBD::Pg::st
execute failed: ERROR:  current transaction is aborted, commands
ignored until end of transaction block at LedgerSMB.pm line 904.,
referer: http://localhost/ledgersmb1.4/login.pl
[Mon Nov 19 07:50:16 2012] [error] [client 127.0.0.1] DBD::Pg::st
fetchrow_array failed: no statement executing at LedgerSMB.pm line
907., referer: http://localhost/ledgersmb1.4/login.pl
[Mon Nov 19 07:50:16 2012] [error] [client 127.0.0.1] 2012/11/19
07:50:16 - ERROR - LedgerSMB::error LedgerSMB.pm (820) -- Database is
not the expected version.  Was , expected 1.3.999.  Please re-run
setup.pl against this database to correct.<a
href='setup.pl'>setup.pl</a>, referer:
http://localhost/ledgersmb1.4/login.pl
[Mon Nov 19 07:50:16 2012] [error] [client 127.0.0.1] 2012/11/19
07:50:16 - ERROR - LedgerSMB::error LedgerSMB.pm (821) -- dbversion:
1.3.999, company: DatseMultimedia2, referer:
http://localhost/ledgersmb1.4/login.pl
[Mon Nov 19 07:50:16 2012] [error] [client 127.0.0.1] Directory index
forbidden by Options directive: /usr/local/ledgersmb1.4/css/, referer:
http://localhost/ledgersmb1.4/login.pl?action=login&company=DatseMultimedia2
[Mon Nov 19 07:50:16 2012] [error] [client 127.0.0.1] File does not
exist: /Library/WebServer/Documents/favicon.ico
[Mon Nov 19 07:51:05 2012] [error] [client 127.0.0.1] DBI
connect('dbname=template1','',...) failed: FATAL:  role "_www" does
not exist at LedgerSMB.pm line 868., referer:
http://localhost/ledgersmb1.4/setup.pl
[Mon Nov 19 07:51:09 2012] [error] [client 127.0.0.1] DBD::Pg::st
execute failed: ERROR:  relation "defaults" does not exist, referer:
http://localhost/ledgersmb1.4/setup.pl
[Mon Nov 19 07:51:09 2012] [error] [client 127.0.0.1] LINE 1: SELECT
version FROM defaults, referer: http://localhost/ledgersmb1.4/setup.pl
[Mon Nov 19 07:51:09 2012] [error] [client 127.0.0.1]
            ^ at LedgerSMB/Database.pm line 328., referer:
http://localhost/ledgersmb1.4/setup.pl
[Mon Nov 19 07:51:09 2012] [error] [client 127.0.0.1] DBD::Pg::st
execute failed: ERROR:  relation "defaults" does not exist, referer:
http://localhost/ledgersmb1.4/setup.pl
[Mon Nov 19 07:51:09 2012] [error] [client 127.0.0.1] LINE 1: SELECT
value FROM defaults WHERE setting_key = $1, referer:
http://localhost/ledgersmb1.4/setup.pl
[Mon Nov 19 07:51:09 2012] [error] [client 127.0.0.1]
          ^ at LedgerSMB/Database.pm line 343., referer:
http://localhost/ledgersmb1.4/setup.pl
[Mon Nov 19 07:51:09 2012] [error] [client 127.0.0.1] DBD::Pg::st
fetchrow_hashref failed: no statement executing at
LedgerSMB/Database.pm line 344., referer:
http://localhost/ledgersmb1.4/setup.pl
[Mon Nov 19 07:51:09 2012] [error] [client 127.0.0.1] DBD::Pg::st
execute failed: ERROR:  relation "defaults" does not exist, referer:
http://localhost/ledgersmb1.4/setup.pl
[Mon Nov 19 07:51:09 2012] [error] [client 127.0.0.1] LINE 1: SELECT
fldvalue FROM defaults WHERE fldname = $1, referer:
http://localhost/ledgersmb1.4/setup.pl
[Mon Nov 19 07:51:09 2012] [error] [client 127.0.0.1]
             ^ at LedgerSMB/Database.pm line 363., referer:
http://localhost/ledgersmb1.4/setup.pl
[Mon Nov 19 07:51:09 2012] [error] [client 127.0.0.1] DBD::Pg::st
fetchrow_hashref failed: no statement executing at
LedgerSMB/Database.pm line 364., referer:
http://localhost/ledgersmb1.4/setup.pl
[Mon Nov 19 07:51:33 2012] [error] [client 127.0.0.1] DBI
connect('dbname=template1','',...) failed: FATAL:  role "_www" does
not exist at LedgerSMB.pm line 868., referer:
http://localhost/ledgersmb1.4/setup.pl
[Mon Nov 19 07:51:36 2012] [error] [client 127.0.0.1] DBD::Pg::st
execute failed: ERROR:  relation "defaults" does not exist, referer:
http://localhost/ledgersmb1.4/setup.pl
[Mon Nov 19 07:51:36 2012] [error] [client 127.0.0.1] LINE 1: SELECT
version FROM defaults, referer: http://localhost/ledgersmb1.4/setup.pl
[Mon Nov 19 07:51:36 2012] [error] [client 127.0.0.1]
            ^ at LedgerSMB/Database.pm line 328., referer:
http://localhost/ledgersmb1.4/setup.pl
[Mon Nov 19 07:51:36 2012] [error] [client 127.0.0.1] DBD::Pg::st
execute failed: ERROR:  relation "defaults" does not exist, referer:
http://localhost/ledgersmb1.4/setup.pl
[Mon Nov 19 07:51:36 2012] [error] [client 127.0.0.1] LINE 1: SELECT
value FROM defaults WHERE setting_key = $1, referer:
http://localhost/ledgersmb1.4/setup.pl
[Mon Nov 19 07:51:36 2012] [error] [client 127.0.0.1]
          ^ at LedgerSMB/Database.pm line 343., referer:
http://localhost/ledgersmb1.4/setup.pl
[Mon Nov 19 07:51:36 2012] [error] [client 127.0.0.1] DBD::Pg::st
fetchrow_hashref failed: no statement executing at
LedgerSMB/Database.pm line 344., referer:
http://localhost/ledgersmb1.4/setup.pl
[Mon Nov 19 07:51:36 2012] [error] [client 127.0.0.1] DBD::Pg::st
execute failed: ERROR:  relation "defaults" does not exist, referer:
http://localhost/ledgersmb1.4/setup.pl
[Mon Nov 19 07:51:36 2012] [error] [client 127.0.0.1] LINE 1: SELECT
fldvalue FROM defaults WHERE fldname = $1, referer:
http://localhost/ledgersmb1.4/setup.pl
[Mon Nov 19 07:51:36 2012] [error] [client 127.0.0.1]
             ^ at LedgerSMB/Database.pm line 363., referer:
http://localhost/ledgersmb1.4/setup.pl

I hope this helps.  Database is in version 1.3.23 I believe format.

Jigme Datse Yli-Rasku

- -- 
Datse Multimedia Productions
http://DatseMultimedia.com/
Tel:    250-352-6870
Mobile: 250-354-7094


-----BEGIN PGP SIGNATURE-----
Version: GnuPG/MacGPG2 v2.0.18 (Darwin)
Comment: GPGTools - http://gpgtools.org
Comment: Using GnuPG with undefined - http://www.enigmail.net/

iQEcBAEBAgAGBQJQqldMAAoJEPTTlG5JFW+7mcYH/A+XZPnS5RBhng0P6qfnarNy
4xWUZIronMzJ6QzDVzjnpDjS8zl3FPDJn6L5JwJgNDUzyZHNS+M7y/qPLBym2P/V
SMjTVmryDpO1S4MNV7dMFy0ECRsjtOX9ue0NTb0EqPODvBM1Px0rBOf0LVgbmWl4
WvmVdgkp+IegwHqCk/CFNf2SdbZSCrnVGu4jhUHYTwJ6E9VzG48UXcp6s35ZQO8c
cUcPSnRpKpw40HSSDopp0WjziArWOGDs/pryVmWZZpRhH2cINR2LBtSkprR9+kGb
4nXXHvSIdViVXubyBvezcnlCNn6D8lJDYICQsDb5oe4njr8ac5rf7jFxK31GkiM=
=SBwj
-----END PGP SIGNATURE-----
Prev by Date: LedgerSMB 1.3.24 in release candidate stage
Next by Date: Any objection to releasing 1.3.24 tomorrow?
Previous by thread: LedgerSMB 1.3.24 in release candidate stage
Next by thread: Any objection to releasing 1.3.24 tomorrow?
Index(es):
- Date
- Thread