Forums / Setting Up Categories, Products, Attributes / Sql Error using product book type

Sql Error using product book type

Locked

Results 1 to 1 of 1

This thread is locked. New replies are disabled.

16 Nov 2009, 11:31 AM

yosemirza

New Zenner

Join Date:: Aug 2009
Posts:: 25
Plugin Contributions:: 0

Sql Error using product book type

Please help: I have sql error on my site

"1104 The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay
in:
[select a.book_authors_name from book_authors a, book_authors_info ad, books_to_authors b where b.products_id = '1269' and b.book_authors_id = a.book_authors_id and a.book_authors_id = ad.book_authors_id and ad.language_id = '1' and ad.language_id = b.language_idta and ad.language_id = a.language_ida order by book_authors_name]"

I am using product book type. Thank you