Post by andrei_petrov » Tue Jun 27, 2023 1:56 pm

Hi Opencart support,

we came across the issue when adding a tag to the product. When clicking on tag on the frontend the error message occuring,
e.g. https://www.cleverkids.ie/index.php?rou ... ng%20tools

Fatal error: Uncaught Exception: Error: Can't find FULLTEXT index matching the column list<br />Error No: 1191<br />SELECT p.product_id, MATCH(pd.name,pd.description,pd.tag) AGAINST('interactive learning tools') AS pdscore, MATCH(p.model) AGAINST('interactive learning tools') AS pscore, MATCH(cd.name) AGAINST('interactive learning tools') AS cdscore, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id) LEFT JOIN oc_category_description cd ON (p2c.category_id = cd.category_id) WHERE TRUE AND p.date_available <= NOW() AND p2s.store_id = 0 AND pd.language_id = 1 AND p.status = 1 AND (LCASE(pd.tag) LIKE '%interactive learning tools%') AND ( MATCH(pd.name,pd.description,pd.tag) AGAINST('interactive learning tools') OR MATCH(p.model) AGAINST('interactive learning tools') OR MATCH(cd.name) AGAINST('interactive learning tools')) ORDER BY ( in /home/cleveie/public_html/system/library/db/mysqli.php on line 48

Also recorded a short video explaining the things:

https://www.loom.com/share/1518e6d4c105 ... a10c84ea53

We also tried to add FULLTEXT for the column tag in the oc_product_description table, but it did not solved the issue:

ALTER TABLE oc_product_description ADD FULLTEXT(tag);

With Regards,
Andrei.

Newbie

Posts

Joined
Thu May 30, 2019 6:14 am

Post by SohBH » Tue Jun 27, 2023 7:36 pm

Drop your fulltext index, then

Code: Select all

ALTER TABLE oc_product_description ADD FULLTEXT (name, description, tag);

View all extensions | Request custom work | Pricing | Contact Me


User avatar
Active Member

Posts

Joined
Mon Nov 02, 2020 12:01 am
Location - Malaysia

Post by andrei_petrov » Tue Jun 27, 2023 10:43 pm

Hi SohBH,

thank you, it solved the issue on the dev site, but the live database has another issue:

MariaDB [cleveie_2new]> ALTER TABLE oc_product_description ADD FULLTEXT (name, description, tag);
ERROR 1062 (23000): Duplicate entry '' for key '*UNKNOWN*'

Have attached both dev and live database screenshot of oc_product_description table.

With Regards,
Andrei.

Attachments

cleverkids_dev_index.png

cleverkids_dev_index.png (467.29 KiB) Viewed 2132 times

cleverkids_live_index.png

cleverkids_live_index.png (462.34 KiB) Viewed 2132 times


Newbie

Posts

Joined
Thu May 30, 2019 6:14 am

Post by andrei_petrov » Wed Jun 28, 2023 1:28 pm

Hi SohBH,

finally dropped the table oc_product_description on the live site then uploaded it back and it solved the issue with the primary key. Many thanks for your help!

With Regards,
Andrei.

Newbie

Posts

Joined
Thu May 30, 2019 6:14 am
Who is online

Users browsing this forum: No registered users and 5 guests