Index: branches/2.8.x/CHANGELOG
===================================================================
--- branches/2.8.x/CHANGELOG	(revision 1503)
+++ branches/2.8.x/CHANGELOG	(revision 1504)
@@ -12,6 +12,8 @@
 
 =============================== FEATURES FREEZE ================================
 ----------------------------------- Fixes 2.8.2 --------------------------------
+19 Aug-2011 Build 1504 Werner v.d.Decken(DarkViper)
+# fixed order::clean()
 18 Aug-2011 Build 1503 Dietmar Woellbrink (Luisehahne)
 ! change sql statements to strict in module droplets
 ! fix vars in compatibility mode for versions before 2.8.1 in frontend.functions.php
Index: branches/2.8.x/wb/admin/interface/version.php
===================================================================
--- branches/2.8.x/wb/admin/interface/version.php	(revision 1503)
+++ branches/2.8.x/wb/admin/interface/version.php	(revision 1504)
@@ -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', '1503');
+if(!defined('REVISION')) define('REVISION', '1504');
Index: branches/2.8.x/wb/framework/class.order.php
===================================================================
--- branches/2.8.x/wb/framework/class.order.php	(revision 1503)
+++ branches/2.8.x/wb/framework/class.order.php	(revision 1504)
@@ -139,9 +139,10 @@
 	 */
 	public function clean($group) {
 		// Loop through all records and give new order
-		$sql  = 'SET @c := 0; ';
-		$sql .= 'UPDATE `'.$this->_Table.'` SET `'.$this->_FieldOrder.'`=( SELECT @c := @c + 1 ) ';
-		$sql .= 'WHERE `'.$this->_FieldGroup.'`=\''.$group.'\' ';
+		$sql  = 'SET @c:=0;'."\n";
+		$this->_DB->query($sql);
+		$sql .= 'UPDATE `'.$this->_Table.'` SET `'.$this->_FieldOrder.'`=(@c:=@c+1) ';
+		$sql .= 'WHERE `'.$this->_FieldGroup.'`='.$group.' ';
 		$sql .= 'ORDER BY `'.$this->_FieldOrder.'` ASC;';
 		return $this->_DB->query($sql);
 	}