Hi Dave, Which PostgreSQL version?
Regards, Erik On Sep 13, 2016 21:59, "Dave" <ledger...@1001111.com> 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 > dave.mor...@1001111.com > 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 Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
