Page 1 of 1

Will adding FULLTEXT to a few opencart database columns potentially break my site?

Posted: Tue Jan 11, 2022 8:37 am
by takayuki
Hi,

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.

thanks!

Re: Will adding FULLTEXT to a few opencart database columns potentially break my site?

Posted: Tue Jan 11, 2022 8:53 am
by ADD Creative
It shouldn't do, but always test changes on a copy of your site first.

Re: Will adding FULLTEXT to a few opencart database columns potentially break my site?

Posted: Tue Jan 11, 2022 3:27 pm
by thekrotek
How can it break your site? FULLTEXT is just a field type, which will simply increase the amount of data saved.