When i do certain sql queries like this one: "SELECT f.*, u.uname, u.uid, p.post_time FROM nuke_forums f LEFT JOIN nuke_posts p ON p.post_id = f.forum_last_post_id LEFT JOIN nuke_users u ON u.uid = p.poster_id ORDER BY f.cat_id, f.forum_id" i get this error: Got error 28 from table
but when i remove the "ORDER BY f.cat_id, f.forum_id" it works fine. any idea? p.s: i searched the net and they say error 28 is "not enough space", but i don't think it is connected to space since most of my phpnuke queries works fine, and the error only happens with order by. * - * - * Tzahi Fadida [EMAIL PROTECTED] Technion Email: [EMAIL PROTECTED] Fax (+1 Outside the US) 240-597-3213 My Cool Site: HTTP://WWW.My2Nis.Com * - * - * - * - * - * - * - * - * - * WARNING TO SPAMMERS: see at http://members.lycos.co.uk/my2nis/spamwarning.html ================================================================To unsubscribe, send mail to [EMAIL PROTECTED] with the word "unsubscribe" in the message body, e.g., run the command echo unsubscribe | mail [EMAIL PROTECTED]