[Tikiwiki-cvs/svn] SF.net SVN: tikiwiki:[43355] trunk/lib/core/Tracker/Query.php

[<rob...@us...>]

Revision: 43355
          http://tikiwiki.svn.sourceforge.net/tikiwiki/?rev=43355&view=rev
Author:   robertplummer
Date:     2012-10-09 18:00:28 +0000 (Tue, 09 Oct 2012)
Log Message:
-----------
[FIX] Split each query up into it's own part

Modified Paths:
--------------
    trunk/lib/core/Tracker/Query.php

Modified: trunk/lib/core/Tracker/Query.php
===================================================================
--- trunk/lib/core/Tracker/Query.php	2012-10-09 17:51:43 UTC (rev 43354)
+++ trunk/lib/core/Tracker/Query.php	2012-10-09 18:00:28 UTC (rev 43355)
@@ -236,8 +236,10 @@
 		$this->tracker = $tracker;
 
 		$tikilib->query(
-			"DROP TABLE IF EXISTS temp_tracker_field_options;
-			CREATE TEMPORARY TABLE temp_tracker_field_options (
+			"DROP TABLE IF EXISTS temp_tracker_field_options;"
+		);
+		$tikilib->query(
+			"CREATE TEMPORARY TABLE temp_tracker_field_options (
 				trackerIdHere INT,
 				trackerIdThere INT,
 				fieldIdThere INT,
@@ -247,9 +249,10 @@
 				linkToItems INT,
 				type VARCHAR(1),
 				options VARCHAR(50)
-				);
-
-			INSERT INTO temp_tracker_field_options
+				);"
+		);
+		$tikilib->query(
+			"INSERT INTO temp_tracker_field_options
 			SELECT
 			tiki_tracker_fields.trackerId,
 			REPLACE(SUBSTRING(
@@ -281,10 +284,11 @@
 			tiki_tracker_fields.type,
 			tiki_tracker_fields.options
 				FROM tiki_tracker_fields
-				WHERE tiki_tracker_fields.type = 'l';
-
-			SET group_concat_max_len = 4294967295;"
+				WHERE tiki_tracker_fields.type = 'l';"
 		);
+		$tikilib->query(
+			"SET group_concat_max_len = 4294967295;"
+		);
 
 		/*For any fields that have multi items, we use php to parse those out, there shouldn't be too many
 		 */

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