[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Upgrade to 1.4.33 Problems



Hi Dave,

Which PostgreSQL version?

Regards,

Erik


On Sep 13, 2016 21:59, "Dave" <..hidden..> wrote:
Hi All,
        Upgrade to 1.3.48 went fine, no issues, however, the upgrade to 1.4.33 is giving me trouble.
I have proper backups :), I am working on a dev server :)

The browser error is:

Error!
Module Files.sql failed to load at /home/apache/prd/ledgersmb/LedgerSMB/Database.pm line 656.
dbversion: 1.4.34-dev, company:


 From the apache error logs:
[Tue Sep 13 13:28:50.874174 2016] [cgi:error] [pid 6542] [client 66.18.214.59:63302] AH01215: 14 at /home/apache/prd/ledgersmb/LedgerSMB/Scripts/setup.pm line 730., referer:
http://accounts.1001111.com/setup.pl
[Tue Sep 13 13:28:50.875003 2016] [cgi:error] [pid 6542] [client 66.18.214.59:63302] AH01215: 15 at /home/apache/prd/ledgersmb/LedgerSMB/Scripts/setup.pm line 730., referer:
http://accounts.1001111.com/setup.pl
[Tue Sep 13 13:28:50.926373 2016] [cgi:error] [pid 6542] [client 66.18.214.59:63302] AH01215: WARNING:  nonstandard use of escape in a string literal, referer: http://accounts.1001111.com/setup.pl
[Tue Sep 13 13:28:50.926413 2016] [cgi:error] [pid 6542] [client 66.18.214.59:63302] AH01215: LINE 6:                          and gifi_accno !~ '^\\s*$', referer: http://accounts.1001111.com/setup.pl
[Tue Sep 13 13:28:50.926434 2016] [cgi:error] [pid 6542] [client 66.18.214.59:63302] AH01215:                                                    ^, referer: http://accounts.1001111.com/setup.pl
[Tue Sep 13 13:28:50.926470 2016] [cgi:error] [pid 6542] [client 66.18.214.59:63302] AH01215: HINT:  Use the escape string syntax for escapes, e.g., E'\\r\\n'., referer:
http://accounts.1001111.com/setup.pl
[Tue Sep 13 13:28:50.936352 2016] [cgi:error] [pid 6542] [client 66.18.214.59:63302] AH01215: DBD::Pg::db begin_work failed: Already in a transaction at
/home/apache/prd/ledgersmb/LedgerSMB/Scripts/setup.pm line 630., referer: http://accounts.1001111.com/setup.pl
[Tue Sep 13 13:28:50.952898 2016] [cgi:error] [pid 6542] [client 66.18.214.59:63302] AH01215: DBD::Pg::db begin_work failed: Already in a transaction at
/home/apache/prd/ledgersmb/LedgerSMB/Scripts/setup.pm line 1001., referer: http://accounts.1001111.com/setup.pl
[Tue Sep 13 13:29:13.104424 2016] [cgi:error] [pid 6542] [client 66.18.214.59:63302] AH01215: 2016/09/13 13:29:13 - ERROR - LedgerSMB::_error /home/apache/prd/ledgersmb/LedgerSMB.pm (640) -- Module
Files.sql failed to load at /home/apache/prd/ledgersmb/LedgerSMB/Database.pm line 656., referer: http://accounts.1001111.com/setup.pl
[Tue Sep 13 13:29:13.104519 2016] [cgi:error] [pid 6542] [client 66.18.214.59:63302] AH01215: 2016/09/13 13:29:13 - ERROR - LedgerSMB::_error /home/apache/prd/ledgersmb/LedgerSMB.pm (641) --
dbversion: 1.4.34-dev, company: , referer: http://accounts.1001111.com/setup.pl
[Tue Sep 13 13:29:13.104547 2016] [cgi:error] [pid 6542] [client 66.18.214.59:63302] AH01215: Died at /home/apache/prd/ledgersmb/LedgerSMB.pm line 654., referer: http://accounts.1001111.com/setup.pl
[Tue Sep 13 13:29:13.104581 2016] [cgi:error] [pid 6542] [client 66.18.214.59:63302] AH01215: Compilation failed in require at /home/apache/prd/ledgersmb/setup.pl line 8., referer:
http://accounts.1001111.com/setup.pl

Running the file against the db manually results in:
BEGIN
CREATE FUNCTION
COMMENT
CREATE FUNCTION
COMMENT
CREATE FUNCTION
COMMENT
CREATE FUNCTION
COMMENT
CREATE FUNCTION
COMMENT
CREATE FUNCTION
CREATE FUNCTION
COMMENT
psql:./Files.sql:249: ERROR:  syntax error at or near "UPDATE"
LINE 7:     UPDATE file_internal
             ^
psql:./Files.sql:255: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:./Files.sql:261: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:./Files.sql:263: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:./Files.sql:275: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:./Files.sql:299: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:./Files.sql:314: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:./Files.sql:318: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:./Files.sql:324: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:./Files.sql:327: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:./Files.sql:329: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:./Files.sql:342: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:./Files.sql:346: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:./Files.sql:354: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:./Files.sql:360: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:./Files.sql:387: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:./Files.sql:389: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:./Files.sql:395: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:./Files.sql:398: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:./Files.sql:400: ERROR:  current transaction is aborted, commands ignored until end of transaction block
ROLLBACK


Any ideas?
TIA
Dave

--
Dave Morgan
Senior Consultant, 1001111 Alberta Limited
..hidden..
403 399 2442

------------------------------------------------------------------------------
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
------------------------------------------------------------------------------
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users