When I issue the following query from phpMyAdmin, SELECT b.* FROM newblocks b LEFT JOIN groups_blocks_link l ON l.block_id=b.bid WHERE (l.groupid=3) AND b.isactive=1 AND b.side=0 AND b.visible=1 ORDER BY b.weight,b.bid
I get the following error Can't create/write to file '/var/tmp/#sql3f2_194_0.MYI' (Errcode: 2) but when I change * to bid in the above query like this SELECT b.bid FROM newblocks b LEFT JOIN groups_blocks_link l ON l.block_id=b.bid WHERE (l.groupid=3) AND b.isactive=1 AND b.side=0 AND b.visible=1 ORDER BY b.weight,b.bid I have no problem retrieving data, and no errors as I received with the first query. Has anybody got this problem? thanks in advance K. Ono --------------------------------------------------------------------- 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