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
[email protected]
403 399 2442
------------------------------------------------------------------------------
_______________________________________________
Ledger-smb-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
