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.
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
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.
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 (467.29 KiB) Viewed 2131 times
cleverkids_live_index.png (462.34 KiB) Viewed 2131 times
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.
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.
Who is online
Users browsing this forum: No registered users and 5 guests