<<Error 28 Db HANdler>>

[admin]

HI,


I need some help here.

I have a sql statement, which works previously, but somehow after upgrade the MYSQL to 3.23.43-, it seem like bring me so many problem.

Please help me check the sql statement below:

============================
Select tblSearch.*, IF(tblSearch.mbox_id=0, 'INBOX', tblMailBoxes.mboxname) AS mboxname from tblSearch, tblMailBoxes where (tblSearch.mbox_id=tblMailBoxes.mbox_id or tblSearch.mbox_id='INBOX') and tblSearch.user_id='325' and tblMailBoxes.user_id='325' group by tblSearch.message_id order by header_date desc limit 0, 50;
============================

Result :
<b>
1030: Got error 28 from table handler
DB Error: unknown error:
</b>

I find out this error is cause by the 'order by' ??

I am using PEARL DB to for my DB handler.


Louis

Thanks in advance, any advice or solution is much appreciatable.