you can use perror 28 to see what does that error code mean Rahul T
-----Original Message----- From: Kittiphum Worachat [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 10:50 AM To: [EMAIL PROTECTED] Subject: Error code 28 Hello, mysql, In select field list if they have some field that field type is text or blob and if I use group by some filed MySQL will generate "Got error 28 from table handler" the query like this select a.f1,a.f2,a.f3,b.f1,b.f2 from table_a as a,table_b as b where a.f1=b.f1 and a.f1='xxx' group by b.f2 if f2.b if mediumtext I will got error 28 but when change type to varchar it OK but I realy need mediumtext type how to solve this problem Best regards. Kittiphum Worachat [EMAIL PROTECTED] 2002-05-13 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php