Index: branches/2.8.x/CHANGELOG
===================================================================
--- branches/2.8.x/CHANGELOG	(revision 1504)
+++ branches/2.8.x/CHANGELOG	(revision 1505)
@@ -12,6 +12,8 @@
 
 =============================== FEATURES FREEZE ================================
 ----------------------------------- Fixes 2.8.2 --------------------------------
+19 Aug-2011 Build 1505 Dietmar Woellbrink (Luisehahne)
+# syntaxfix order::clean()
 19 Aug-2011 Build 1504 Werner v.d.Decken(DarkViper)
 # fixed order::clean()
 18 Aug-2011 Build 1503 Dietmar Woellbrink (Luisehahne)
Index: branches/2.8.x/wb/admin/interface/version.php
===================================================================
--- branches/2.8.x/wb/admin/interface/version.php	(revision 1504)
+++ branches/2.8.x/wb/admin/interface/version.php	(revision 1505)
@@ -52,4 +52,4 @@
 
 // check if defined to avoid errors during installation (redirect to admin panel fails if PHP error/warnings are enabled)
 if(!defined('VERSION')) define('VERSION', '2.8.2');
-if(!defined('REVISION')) define('REVISION', '1504');
+if(!defined('REVISION')) define('REVISION', '1505');
Index: branches/2.8.x/wb/framework/class.order.php
===================================================================
--- branches/2.8.x/wb/framework/class.order.php	(revision 1504)
+++ branches/2.8.x/wb/framework/class.order.php	(revision 1505)
@@ -139,12 +139,12 @@
 	 */
 	public function clean($group) {
 		// Loop through all records and give new order
-		$sql  = 'SET @c:=0;'."\n";
+		$sql  = 'SET @c:=0';
 		$this->_DB->query($sql);
-		$sql .= 'UPDATE `'.$this->_Table.'` SET `'.$this->_FieldOrder.'`=(@c:=@c+1) ';
-		$sql .= 'WHERE `'.$this->_FieldGroup.'`='.$group.' ';
+		$sql  = 'UPDATE `'.$this->_Table.'` SET `'.$this->_FieldOrder.'`=(SELECT @c:=@c+1) ';
+		$sql .= 'WHERE `'.$this->_FieldGroup.'`=\''.$group.'\' ';
 		$sql .= 'ORDER BY `'.$this->_FieldOrder.'` ASC;';
 		return $this->_DB->query($sql);
 	}
-	
+
 } // end of class
Index: branches/2.8.x
===================================================================
--- branches/2.8.x	(revision 1504)
+++ branches/2.8.x	(revision 1505)

Property changes on: branches/2.8.x
___________________________________________________________________
Modified: svn:ignore
## -1,2 +1,3 ##
-
 .project
+favicon.ico
+nbproject