Re: Upgrade to 1.4.33 Problems

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