SF.net SVN: ledger-smb:[2901] addons/1.3/assets/trunk

[..hidden..]

Revision: 2901
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2901&view=rev
Author:   einhverfr
Date:     2010-02-19 16:28:46 +0000 (Fri, 19 Feb 2010)

Log Message:
-----------
Fixing internal server errors with asset module and DBD::Pg 1.x

Modified Paths:
--------------
    addons/1.3/assets/trunk/LedgerSMB/DBObject/Asset_Report.pm
    addons/1.3/assets/trunk/sql/modules/Assets.sql

Modified: addons/1.3/assets/trunk/LedgerSMB/DBObject/Asset_Report.pm
===================================================================
--- addons/1.3/assets/trunk/LedgerSMB/DBObject/Asset_Report.pm	2010-02-18 19:12:13 UTC (rev 2900)
+++ addons/1.3/assets/trunk/LedgerSMB/DBObject/Asset_Report.pm	2010-02-19 16:28:46 UTC (rev 2901)
@@ -20,6 +20,7 @@
     if ($self->{depreciation}){
         my ($ref) = $self->exec_method(funcname => 'asset_report__save');
         $self->{report_id} = $ref->{id};
+        $self->{asset_ids} = $self->_db_array_scalars(@{$self->{asset_ids}});
         my ($dep) = $self->exec_method(funcname => 'asset_class__get_dep_method');
         $self->exec_method(funcname => $dep->{sproc});
     } else {

Modified: addons/1.3/assets/trunk/sql/modules/Assets.sql
===================================================================
--- addons/1.3/assets/trunk/sql/modules/Assets.sql	2010-02-18 19:12:13 UTC (rev 2900)
+++ addons/1.3/assets/trunk/sql/modules/Assets.sql	2010-02-19 16:28:46 UTC (rev 2901)
@@ -334,7 +334,7 @@
                 dep_account_id = in_dep_account_id
 	WHERE id = in_id;
 	IF FOUND THEN
-		SELECT * INTO ret_val WHERE id = in_id;
+		SELECT * INTO ret_val FROM asset_item WHERE id = in_id;
 		return ret_val;
 	END IF;
 


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.