[Pkg-sql-ledger-discussion] Bug#675816: ledgersmb: Unable to upgrade from 1.2 db to 1.3 db

[Moshe Yudkowsky]

Subject: ledgersmb: Unable to upgrade from 1.2 db to 1.3 db
Package: ledgersmb
Version: 1.3.15-2
Severity: important

All my databases are 1.2 databases. I'm following the update 
instructions for 1.3, using the "setup.pl" page via my browser.

The updates fail with an apache 500 error -- the db is created but all 
the tables are empty. Re-running the update process does _not_ repair 
the db, as might be expected.

While many errors show up, the final pre-500 errors in Apache are:

[Fri Jun 01 17:44:40 2012] [error] [client 127.0.0.1] LINE 1: SELECT 
version FROM defaults, referer: http://localhost/ledgersmb/setup.pl
[Fri Jun 01 17:44:40 2012] [error] [client 127.0.0.1]                ^ 
at LedgerSMB/Database.pm line 310., referer: 
http://localhost/ledgersmb/setup.pl
[Fri Jun 01 17:44:43 2012] [error] [client 127.0.0.1] Directory index 
forbidden by Options directive: /usr/share/ledgersmb/css/, referer: 
http://localhost/ledgersmb/setup.pl
[Fri Jun 01 17:44:49 2012] [error] [client 127.0.0.1] commit ineffective 
with AutoCommit enabled at scripts/setup.pl line 519., referer: 
http://localhost/ledgersmb/setup.pl

(the ones above seem to indicate a problem with the httpd conf file in 
/etc/ledgersmb)

[Fri Jun 01 17:45:46 2012] [error] [client 127.0.0.1] Bareword found 
where operator expected at LedgerSMB/Template/TXT.pm line 116, near "'.' 
get_extension", referer: http://localhost/ledgersmb/setup.pl
[Fri Jun 01 17:45:46 2012] [error] [client 127.0.0.1] \t(Missing 
operator before get_extension?), referer: 
http://localhost/ledgersmb/setup.pl
[Fri Jun 01 17:45:46 2012] [error] [client 127.0.0.1] syntax error at 
LedgerSMB/Template/TXT.pm line 116, near "'.' get_extension", referer: 
http://localhost/ledgersmb/setup.pl
[Fri Jun 01 17:45:46 2012] [error] [client 127.0.0.1] Compilation failed 
in require at (eval 98) line 2., referer: 
http://localhost/ledgersmb/setup.pl
[Fri Jun 01 17:45:46 2012] [error] [client 127.0.0.1] Compilation failed 
in require at /usr/share/ledgersmb/setup.pl line 8., referer: 
http://localhost/ledgersmb/setup.pl
[Fri Jun 01 17:45:46 2012] [error] [client 127.0.0.1] Premature end of 
script headers: setup.pl, referer: http://localhost/ledgersmb/setup.pl

These appear to be the fatal errors. A look upstream shows that there's 
a report of this error:

http://www.mail-archive.com/ledger-smb-users@lists.sourceforge.net/msg05917.html

but I haven't been able to determine if this problem was ever solved.

Estimated taxes are due in about 10 days. I'm getting ready to panic. Is 
it possible to, at least in the meantime, downgrade to 1.2.x until this 
issue is resolved? Otherwise I'll end up with 1.3.17 or 1.2.x installed 
from the site directly, or some similar fix.

-- System Information:
Debian Release: wheezy/sid
   APT prefers unstable
   APT policy: (990, 'unstable'), (500, 'testing'), (500, 'stable'), (1, 
'experimental')
Architecture: amd64 (x86_64)

Kernel: Linux 3.1.0-1-amd64 (SMP w/2 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash

Versions of packages ledgersmb depends on:
ii  apache2-mpm-prefork [httpd-cgi]            2.2.22-6
ii  dbconfig-common                            1.8.47+nmu1
ii  debconf [debconf-2.0]                      1.5.43
ii  libcgi-simple-perl                         1.113-2
ii  libconfig-any-perl                         0.23-1
ii  libconfig-std-perl                         0.9-1
ii  libdatetime-perl                           2:0.7300-1
ii  libdbd-pg-perl                             2.19.2-1
ii  libdbi-perl                                1.621-1
ii  liberror-perl                              0.17-1
ii  libfile-mimeinfo-perl                      0.16-1
ii  libhtml-parser-perl                        3.69-2
ii  libio-stringy-perl                         2.110-5
ii  liblocale-maketext-lexicon-perl            0.91-1
ii  liblog-log4perl-perl                       1.29-1
ii  libmime-lite-perl                          3.028-1
ii  libtemplate-perl                           2.22-0.1+b2
ii  perl                                       5.14.2-11
ii  postgresql-client                          9.1+130
ii  postgresql-client-8.3 [postgresql-client]  8.3.12-0lenny1
ii  postgresql-client-9.1 [postgresql-client]  9.1.3-2
ii  postgresql-contrib                         9.1+130
ii  thttpd [httpd-cgi]                         2.25b-11

Versions of packages ledgersmb recommends:
ii  libmath-bigint-gmp-perl        1.37-1+b1
ii  libopenoffice-oodoc-perl       2.125-2
ii  libparse-recdescent-perl       1.967009+dfsg-1
ii  nbsmtp [mail-transport-agent]  1.00-4
ii  texlive-latex-recommended      2012.20120529-1

Versions of packages ledgersmb suggests:
ii  cups-bsd [lpr]      1.5.3-1
ii  latex-cjk-all       <none>
ii  libnet-tclink-perl  <none>
ii  postgresql          9.1+130

-- Configuration Files:
/etc/ledgersmb/ledgersmb.conf changed [not included]

-- debconf information:
* ledgersmb/debconf_install: false
   ledgersmb/admin_login: ledgersmb

-- 
Moshe Yudkowsky * moshe at pobox.com * www.pobox.com/~moshe
  "Live fast. Die young. Leave no documentation."
    			-- Programmer's Creed, as told by Mike Bakula