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.
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.