Jump to content
Search In
  • More options...
Find results that contain...
Find results in...
  • Sign Up

Ошибка при поиске


Recommended Posts

При поиске возникает такая ошибка:

Notice: Error: 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
Error No: 1104
SELECT COUNT(DISTINCT p.product_id) AS total FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND (LCASE(pd.name) LIKE '............

 

Было загружено около 20 тыс. товаров в 600 категорий и подкатегорий

Opencart 1.5.4

 

Как исправить?

Link to post
Share on other sites

Поиск по слову max_join_size вернул 16 результатов

Поиск по слову sql_big_selects вернул 16 результатов

Link to post
Share on other sites

afwollis конечно прав, нужно использовать поиск

но я практически на 100% уверен, что причина та же самая: https://opencartforum.com/topic/23340-uskorit-rabotu-saita-na-ocstore-1541-poriadka-50-000-tovarov/

Читать можно начинать отсюда: https://opencartforum.com/topic/23340-uskorit-rabotu-saita-na-ocstore-1541-poriadka-50-000-tovarov/?do=findComment&comment=177047

 

Кстати, если в моих ссылках указана только причина и способ её лечения в другом модуле, то по ссылкам afwollis есть решение и вашей проблемы

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...

Important Information

On our site, cookies are used and personal data is processed to improve the user interface. To find out what and what personal data we are processing, please go to the link. If you click "I agree," it means that you understand and accept all the conditions specified in this Privacy Notice.