*

slaven

  • ***
  • 99 posts
Hello! How to solve the problem in the database that shows the following error?

Also, the search for ads on the site "results not found" does not work for the aforementioned reason.

Any keyword gives the same problem... in the example, a search for "corso".

Search doesn't work in the admin panel either item_ID.


Trying to "repair" the database didn't help.

Also, a recovery operation using the following command in phpmyadmin did not yield any results.

ALTER TABLE oc_t_item_description ADD FULLTEXT id_description (s_title, s_description);


If there is no solution, maybe this will help.
I have a backup that is 10 days old and in the meantime 100 new ads to date. How can I import new ads to the old database without creating a problem?


What is the best solution?



« Last Edit: July 28, 2026, 05:47:48 PM by slaven »
Osclass

Marked as best answer by alexborg on July 29, 2026, 09:19:05 PM
*

MB Themes

Re: Problem in database - Error description: Can't find FULLTEXT index
« Reply #1 on: July 29, 2026, 08:14:49 PM »
Easiest fix is to switch out of fulltext search in general settings.
But error is interesting, does that fullindex really exists?
Item description table also use myisam engine, not innodb just because of fullindex.
  To get fast support, we need following details: Detail description, URL to reproduce problem, Screenshots

*

slaven

  • ***
  • 99 posts
Re: Problem in database - Error description: Can't find FULLTEXT index
« Reply #2 on: July 29, 2026, 09:14:56 PM »
Easiest fix is to switch out of fulltext search in general settings.
But error is interesting, does that fullindex really exists?
Item description table also use myisam engine, not innodb just because of fullindex.

Yes, thanks and this helps ...  it now works under "Pattern filter method" -> Title / Description contains pattern.

 It doesn't work under full text search - default and under with NLP.

The oc_t_item description table is not myisam but innodb.  ???

The problem may be where it is missing "indexes". When we compare the old and new database, fields are missing "indexes".
.
« Last Edit: July 29, 2026, 09:59:34 PM by slaven »
Osclass

*

MB Themes

Re: Problem in database - Error description: Can't find FULLTEXT index
« Reply #3 on: July 30, 2026, 06:49:23 PM »
Innodb do not have fulltext search as far as far as I remember so it should stay myisam.
  To get fast support, we need following details: Detail description, URL to reproduce problem, Screenshots