SF.net SVN: ledger-smb: [1291] branches/1.2

[..hidden..]

Revision: 1291
          http://svn.sourceforge.net/ledger-smb/?rev=1291&view=rev
Author:   einhverfr
Date:     2007-06-21 11:58:25 -0700 (Thu, 21 Jun 2007)

Log Message:
-----------
Fixed error updating custom fields and another error saving project not attached to customer

Modified Paths:
--------------
    branches/1.2/Changelog
    branches/1.2/LedgerSMB/Form.pm
    branches/1.2/LedgerSMB/PE.pm

Modified: branches/1.2/Changelog
===================================================================
--- branches/1.2/Changelog	2007-06-21 18:31:22 UTC (rev 1290)
+++ branches/1.2/Changelog	2007-06-21 18:58:25 UTC (rev 1291)
@@ -5,7 +5,8 @@
 * Fixed the alias inconsistancy for the ledgersmb-httpd.conf (Chris T).
 * Fixed invalid html in ca.pl (reported by Donna Robinson) (Chris T)
 * Fixed error searching for customer by address (Chris T)
-* Fixed error db error saving project (Chris T)
+* Fixed error db error saving items with custom fields (Chris T)
+* Fixed db error saving project with NULL customer id (Chris T)
 
 Changelog for 1.2.5
 * Partsgroup handling corrected on POS and Sales invoice screens (Chris T)

Modified: branches/1.2/LedgerSMB/Form.pm
===================================================================
--- branches/1.2/LedgerSMB/Form.pm	2007-06-21 18:31:22 UTC (rev 1290)
+++ branches/1.2/LedgerSMB/Form.pm	2007-06-21 18:58:25 UTC (rev 1291)
@@ -1537,7 +1537,7 @@
         if ( $query_type eq 'UPDATE' ) {
             $query = "DELETE FROM $_ WHERE row_id = ?";
             my $sth = $dbh->prepare($query);
-            $sth->execute->( $self->{ "id" . "$linenum" } )
+            $sth->execute( $self->{ "id" . "$linenum" } )
               || $self->dberror($query);
         }
         elsif ( $query_type eq 'INSERT' ) {

Modified: branches/1.2/LedgerSMB/PE.pm
===================================================================
--- branches/1.2/LedgerSMB/PE.pm	2007-06-21 18:31:22 UTC (rev 1290)
+++ branches/1.2/LedgerSMB/PE.pm	2007-06-21 18:58:25 UTC (rev 1291)
@@ -204,7 +204,7 @@
 
     my $dbh = $form->{dbh};
 
-    $form->{customer_id} ||= 'NULL';
+    $form->{customer_id} ||= undef;
 
     $form->{projectnumber} =
       $form->update_defaults( $myconfig, "projectnumber", $dbh )


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