error in RAND() funciton

[Anon]

Hi, i keep on geeting error when execute teh sql statement following:
<b>select * from footer order by RAND()</b>

Error:

<b>MySQL said: Got error 28 from table handler</b>

What happend to it? i am using MySQL 3.23.43 V.

Thanks
Louis

[[deleted]]

(google is lovely, use it)
most likely your tables are corrupt, use ismachk or myisamchk to check them/repair them.

If not, then your system might be running low on temporary diskspace/virtual memory.