ActiveRecord order by random broken on MySQL ?

[eluser]ctype[/eluser]
Look like here also many breaking changes, now don't work old code :
- $this->db->orderby('','RAND()');
- $this->db->where('table.field!=',$user_id); ! but work "where('field!=',$user_id);"

Any way, small (but probably not good) fix:

DB_active_rec.php
function order_by($orderby, $direction = '')
replace line 867
if (strtolower($direction) == 'random')
to
if (strtolower($direction) == 'random' || strtolower($direction) == 'rand()')


mysql_driver.php
function _escape_identifiers($item)

add at top
if ($item == '')
{
return $item;
}

also replace
$str = $this->_escape_char.str_replace('.', $this->_escape_char.'.'.$this->_escape_char, $item).$this->_escape_char;
to
$str = $item;