Post by takayuki » Tue Jan 11, 2022 8:37 am


Will adding fulltext index to opencart database break anything?

I'd like to do this:
ALTER TABLE oc_product_description
ADD FULLTEXT(name, description)

Will this potentially break anything on opencart? It's a big opencart 2.3 site (30k items) with a bunch of plugins, etc. I'm going to add a custom search, but the last thing I want to do is break something.


New member


Thu Aug 13, 2009 10:16 pm

Post by ADD Creative » Tue Jan 11, 2022 8:53 am

It shouldn't do, but always test changes on a copy of your site first.

Expert Member


Sat Jan 14, 2012 1:02 am
Location - United Kingdom

Post by thekrotek » Tue Jan 11, 2022 3:27 pm

How can it break your site? FULLTEXT is just a field type, which will simply increase the amount of data saved.

Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by

User avatar
Expert Member


Sun Jul 03, 2016 12:24 am

Who is online

Users browsing this forum: No registered users and 13 guests