On Sun, Nov 09, 2003 at 12:13:34PM +0000, george atef wrote: > > Hi, i got this message after querying the 3255 records table, and the query > is like this: > > > SELECT a.book_no, a.isbn_a, a.author_a, a.title_a, a.title_b, a.title_c, > a.edition, a.place_publication_a, a.place_publication_b, > a.place_publication_c, a.physical_desc_b, a.physical_desc_c, a.actal_price, > a.currency_code, a.book_name, a.author_name, a.publ_name, a.subject_code, > b.subject_desc FROM book_data a, subject b where > a.subject_code=b.subject_code ORDER BY b.subject_desc, a.entry_date DESC > > it works fine locally on my win98 (PWS server) MySQL 4.0.15 but remotly on > my FREEBSD server gives this error: > > query error: Got error 12 from table handler > > Any Suggesstions?
[EMAIL PROTECTED]:~$ perror 12 Error code 12: Cannot allocate memory You have a memory shortage, it seems. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 57 days, processed 2,151,315,841 queries (435/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]