cs-project-svn_notify

[CS-Project-svn_notify] SF.net SVN: cs-project:[914] trunk/1.2/lib/mainRecordClass.php

[<cra...@us...>]

Revision: 914
          http://cs-project.svn.sourceforge.net/cs-project/?rev=914&view=rev
Author:   crazedsanity
Date:     2009-02-03 17:31:32 +0000 (Tue, 03 Feb 2009)

Log Message:
-----------
Fix problem with typecasts (not a problem in PostgreSQL v8.2.5)(issue #234).

/lib/mainRecordClass.php:
	* get_records():
		-- specifically when retrieving parent records, the "record_id" is cast 
		as text (since ancestry is text) to avoid a database error. 

Modified Paths:
--------------
    trunk/1.2/lib/mainRecordClass.php

Modified: trunk/1.2/lib/mainRecordClass.php
===================================================================
--- trunk/1.2/lib/mainRecordClass.php	2009-01-07 18:15:53 UTC (rev 913)
+++ trunk/1.2/lib/mainRecordClass.php	2009-02-03 17:31:32 UTC (rev 914)
@@ -94,7 +94,7 @@
 		if(is_numeric($parent)) {
 			if($parent == 0) {
 				//
-				$critArr['ancestry'] = "=record_id";
+				$critArr['ancestry'] = "=record_id::text";
 			}
 			else {
 				//tricksie things to facilitate a 'like' search.


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

[CS-Project-svn_notify] SF.net SVN: cs-project:[986] trunk/1.2/lib/mainRecordClass.php

[<cra...@us...>]

Revision: 986
          http://cs-project.svn.sourceforge.net/cs-project/?rev=986&view=rev
Author:   crazedsanity
Date:     2009-09-21 03:04:42 +0000 (Mon, 21 Sep 2009)

Log Message:
-----------
Fix issue #299 (Helpdesk Search No Longer Works).

/lib/mainRecordClass.php:
	* get_records():
		-- remove r.leader_contact_id from the SQL.

Modified Paths:
--------------
    trunk/1.2/lib/mainRecordClass.php

Modified: trunk/1.2/lib/mainRecordClass.php
===================================================================
--- trunk/1.2/lib/mainRecordClass.php	2009-09-21 02:58:51 UTC (rev 985)
+++ trunk/1.2/lib/mainRecordClass.php	2009-09-21 03:04:42 UTC (rev 986)
@@ -152,9 +152,8 @@
 					$critArr['u.username like'] = $keyword;
 					$critArr['r.subject like'] = $keyword;
 				
-					$query = "WHERE is_helpdesk_issue IS ". cleanString($isHelpdesk, 'bool_strict') ." AND (lower(r.name) like ". $keyword ." OR r.leader_contact_id LIKE ". $keyword 
+					$query = "WHERE is_helpdesk_issue IS ". cleanString($isHelpdesk, 'bool_strict') ." AND (lower(r.name) like ". $keyword  
 						." OR lower(u.username) LIKE ". $keyword ." OR lower(r.subject) LIKE ". $keyword .")";
-				
 				}
 				
 				if(isset($critArr['status_id'])) {


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

[CS-Project-svn_notify] SF.net SVN: cs-project:[993] trunk/1.2/lib/mainRecordClass.php

[<cra...@us...>]

Revision: 993
          http://cs-project.svn.sourceforge.net/cs-project/?rev=993&view=rev
Author:   crazedsanity
Date:     2009-10-26 01:29:53 +0000 (Mon, 26 Oct 2009)

Log Message:
-----------
Fix a broken call to log information.

Modified Paths:
--------------
    trunk/1.2/lib/mainRecordClass.php

Modified: trunk/1.2/lib/mainRecordClass.php
===================================================================
--- trunk/1.2/lib/mainRecordClass.php	2009-10-25 18:37:02 UTC (rev 992)
+++ trunk/1.2/lib/mainRecordClass.php	2009-10-26 01:29:53 UTC (rev 993)
@@ -375,7 +375,7 @@
 				debug_print($sqlArr);
 				debug_print($definitionArr);
 				$details = __METHOD__ .": no data left for (". $type .")!";
-				$this->log_by_class($details, 'error');
+				$this->logsObj->log_by_class($details, 'error');
 				throw new exception($details);
 			}
 			


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