From c92d3c00e22fdbcdb64fadbb7a8f4e30b8d43fe5 Mon Sep 17 00:00:00 2001
From: lemonsoftwarero <lemonsoftwarero>
Date: Thu, 5 Apr 2007 19:30:16 +0000
Subject: [PATCH] Bug resolved [ 1520245 ] Unknown column 'e.pc_pid' in 'on
 clause'

---
 .../main/calendar/modules/PostCalendar/common.api.php      | 14 +++++++-------
 1 file changed, 7 insertions(+), 7 deletions(-)

diff --git a/interface/main/calendar/modules/PostCalendar/common.api.php b/interface/main/calendar/modules/PostCalendar/common.api.php
index 1c0b0145b..50b2d26ed 100755
--- a/interface/main/calendar/modules/PostCalendar/common.api.php
+++ b/interface/main/calendar/modules/PostCalendar/common.api.php
@@ -1452,16 +1452,16 @@ function &postcalendar_userapi_pcGetEventDetails($eid)
                     e.pc_contemail,
                     e.pc_website,
                     e.pc_fee,
-					e.pc_sharing,
+                    e.pc_sharing,
                     c.pc_catcolor,
                     c.pc_catname,
                     c.pc_catdesc,
-					e.pc_pid,
-					e.pc_aid,
-					pd.pubpid
-			 FROM   $table e, $cattable c
-			 LEFT JOIN patient_data as pd on pd.pid = e.pc_pid
-			 WHERE  e.pc_eid = '$eid' AND c.pc_catid = e.pc_catid";
+                    e.pc_pid,
+                    e.pc_aid,
+                    pd.pubpid
+            FROM   ($table e, $cattable c)
+            LEFT JOIN patient_data as pd ON (pd.pid = e.pc_pid)
+            WHERE  (e.pc_eid = '$eid' AND c.pc_catid = e.pc_catid)";
 
     $result = $dbconn->Execute($sql);
     if($dbconn->ErrorNo() != 0) {
-- 
2.11.4.GIT