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

Поиск на сайте, ошибка mysql Can't find FULLTEXT index matching the column list Error No: 1191


newlife
 Share

Recommended Posts

Версия 1.5.4.1

Стоит:

OpenCart Exchange 1C;

Deadcow.

Не работает поиск пишет:

Notice: Error: Can't find FULLTEXT index matching the column list
Error No: 1191
SELECT COUNT(DISTINCT p.product_id) AS total FROM 1_product p LEFT JOIN 1_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN 1_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 '%РїРѕРёСЃРє%' 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 /docs/system/database/mysql.php on line 49

Link to comment
Share on other sites


Извините, мне тяму по аналогии сделать не хватает.

Такой запрос тоже выдает ту же ошибку:

SELECT COUNT(DISTINCT p.product_id) AS total
FROM 1_product p LEFT JOIN
1_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN
1_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 '%qwestion%'
OR MATCH(pd.description) AGAINST('qwestion')
OR MATCH(pd.tag) AGAINST('qwestion')) OR LCASE(p.model) = 'qwestion'
OR LCASE(p.sku) = 'qwestion' OR LCASE(p.upc) = 'qwestion' OR LCASE(p.ean) = 'qwestion'
OR LCASE(p.jan) = 'qwestion' OR LCASE(p.isbn) = 'qwestion' OR LCASE(p.mpn) = 'qwestion'

Link to comment
Share on other sites


  • 2 months later...

Такая же проблема, помогите как это исправить

 

2013-05-20 2:04:31 - PHP Notice:  Error: Can't find FULLTEXT index matching the column list<br />Error No: 1191<br />SELECT COUNT(DISTINCT p.product_id) AS total FROM kal_product p LEFT JOIN kal_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN kal_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN kal_product_master pm  ON pm.product_id = p.product_id  WHERE (pm.master_product_id = -1  OR pm.master_product_id = 0  OR pm.master_product_id IS NULL) AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND (LCASE(pd.name) LIKE '%15309%' OR MATCH(pd.tag) AGAINST('15309')) OR LCASE(p.model) = '15309' OR LCASE(p.sku) = '15309' OR LCASE(p.upc) = '15309' OR LCASE(p.ean) = '15309' OR LCASE(p.jan) = '15309' OR LCASE(p.isbn) = '15309' OR LCASE(p.mpn) = '15309' in /..../system/database/mysql.php on line 49
Link to comment
Share on other sites


  • 6 months later...

Notice: Error: Can't find FULLTEXT index matching the column list
Error No: 1191
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 '%высоцкий%' 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 /home/

выдает ошибку, но ALTER TABLE `product_description` ADD FULLTEXT `tag` (`tag`) не помогает, пишет что дублирование tag

ocstore 1.5.4.1

Edited by bigerok
Link to comment
Share on other sites


  • 3 weeks later...

 

Почему не помогает? Ведь то что прописываем в таблицах уже есть

 

выдает ошибку, но ALTER TABLE `product_description` ADD FULLTEXT `tag` (`tag`) не помогает, пишет что дублирование tag

 

что делать в таком случае? тоже самое и для индекса description

Link to comment
Share on other sites


  • 1 month later...

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
 Share

×
×
  • 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.