SF.net SVN: ledger-smb:[5321] branches/1.3

[..hidden..]

Revision: 5321
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=5321&view=rev
Author:   einhverfr
Date:     2012-12-08 03:28:10 +0000 (Sat, 08 Dec 2012)
Log Message:
-----------
Correcting projects being lost on 1.2-1.3 upgrade when not attached to customer.

Modified Paths:
--------------
    branches/1.3/Changelog
    branches/1.3/sql/upgrade/1.2-1.3.sql

Modified: branches/1.3/Changelog
===================================================================
--- branches/1.3/Changelog	2012-12-08 03:17:44 UTC (rev 5320)
+++ branches/1.3/Changelog	2012-12-08 03:28:10 UTC (rev 5321)
@@ -9,6 +9,7 @@
 * Fixed eca selection issues when creating invoices (Chris T, 3588301)
 * Added demo templates with for invoices with attached images (Chris T)
 * Fixed attached images not appearing in templates (Chris T)
+* Fixed projects not attached to customers lost 1.2-1.3 (Chris T, h/t Ario)
 
 Changelog for 1.3.25
 * Fixed internal server errors on LedgerSMB->error() during new() (Chris T)

Modified: branches/1.3/sql/upgrade/1.2-1.3.sql
===================================================================
--- branches/1.3/sql/upgrade/1.2-1.3.sql	2012-12-08 03:17:44 UTC (rev 5320)
+++ branches/1.3/sql/upgrade/1.2-1.3.sql	2012-12-08 03:28:10 UTC (rev 5321)
@@ -518,7 +518,7 @@
      SELECT p.id, projectnumber, description, p.startdate, p.enddate,
             parts_id, production, completed, c.credit_id
        FROM lsmb12.project p
-       JOIN lsmb12.customer c ON p.customer_id = c.id;
+  LEFT JOIN lsmb12.customer c ON p.customer_id = c.id;
 
 INSERT INTO partsgroup SELECT * FROM lsmb12.partsgroup;
 

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