diff options
| author | tetragon <tetragon@4979c152-3d1c-0410-bac9-87ea11338e46> | 2006-11-02 23:24:28 +0000 |
|---|---|---|
| committer | tetragon <tetragon@4979c152-3d1c-0410-bac9-87ea11338e46> | 2006-11-02 23:24:28 +0000 |
| commit | da36e0095ae8b05e124507abd70b7122a94c15f1 (patch) | |
| tree | e2c0fe8d0bfbf6643af697877218453fa054d9cb /LedgerSMB/AM.pm | |
| parent | 24fa7eca64770b4c2fe9690ba88d77d9ba1f1b75 (diff) | |
Change defaults queries to using new table structure
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@469 4979c152-3d1c-0410-bac9-87ea11338e46
Diffstat (limited to 'LedgerSMB/AM.pm')
| -rwxr-xr-x | LedgerSMB/AM.pm | 7 |
1 files changed, 4 insertions, 3 deletions
diff --git a/LedgerSMB/AM.pm b/LedgerSMB/AM.pm index cf4b5df8..a8fd1e63 100755 --- a/LedgerSMB/AM.pm +++ b/LedgerSMB/AM.pm @@ -251,8 +251,10 @@ sub delete_account { # set inventory_accno_id, income_accno_id, expense_accno_id to defaults $query = qq| UPDATE parts - SET inventory_accno_id = (SELECT inventory_accno_id - FROM defaults) + SET inventory_accno_id = (SELECT value + FROM defaults + WHERE setting_key = + 'inventory_accno_id') WHERE inventory_accno_id = ?|; $sth = $dbh->prepare($query); @@ -1592,7 +1594,6 @@ sub backup { my $boundary = time; my $tmpfile = "${LedgerSMB::Sysconfig::userspath}/$boundary.$myconfig->{dbname}-$form->{dbversion}-$t[5]$t[4]$t[3].sql"; $tmpfile .= ".gz" if ${LedgerSMB::Sysconfig::gzip}; - my $out = $form->{OUT}; $form->{OUT} = ">$tmpfile"; open(OUT, "$form->{OUT}") or $form->error("$form->{OUT} : $!"); |