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

Перестал работать поиск


Recommended Posts

Не заметил когда но перестал работать поиск, скорее всего после переноса на другой хостинг.

 

Если поле поиска пустое, то он кидает на страницу поиска, если вставить хоть 1 символ на любой раскладке вылазит ошибка :

Notice: Error: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET 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 <= '2013-06-19 16:00:00' AND p2s.store_id = '0' AND (LCASE(pd.name) LIKE '%аПаОаИбаК%' OR MATCH(pd.tag) AGAINST('аПаОаИбаК')) OR LCASE(p.model) = 'аПаОаИбаК' OR LCASE(p.sku) = 'аПаОаИбаК' OR LCASE(p.upc) = 'аПаОаИбаК' OR LCASE(p.ean) = 'аПаОаИбаК' OR LCASE(p.jan) = 'аПаОаИбаК' OR LCASE(p.isbn) = 'аПаОаИбаК' OR LCASE(p.mpn) = 'аПаОаИбаК' in /public_html/system/database/mysql.php on line 27

 

Может кто то сталкивался с данной проблемой?

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.