Search in support tickets

#952 – Can't find FULLTEXT index matching the column list, and update Adsmanager from 3.0.4 to latest

Posted in ‘Support’
This is a public ticket. Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.
Thursday, 05 August 2021 15:08 CEST
Joomla! version : 3.9.28
PHP version : 7.4.22
AdsManager version : 3.0.4

We currently face a problem on our website which I have described below (and the attached files).

In addition I have just renewed our Adsmanager license subscription.

Questions that I have:
• Do we have to solve this problem described in the attachment before we update from version 3.0.4 tot the latest version?
• Or, do we have to update first and look into the problem after the update?

Please advise.


Hans Doeve

Its been a while (December 2014) since our last contact regarding Adsmanager and my clients website .
The website and Adsmanager (still version 3.0.4) have been working fine. But we ‘suddenly’ now have a problem (error) with the search module (top of front page).

After entering a search term and clicking on the search button (“Zoeken”), we get an error:

1191 - Can't find FULLTEXT index matching the column list .

Questions are:
• Is there an obvious explanation for the sudden introduction of this error?
• Is there an easy and quick fix for this problem on the current website?
• Will this error disappear if we upgrade to a later/latest release of Adsmanager?

Settings of the search module are shown below.

Field 1 (Veld 1) is field “ad_zoekveld”, which is a multiple search field.

When I try to edit the field äd_zoekveld” I get an error.

Some observations:
1. If no search term is entered then the websites works normal, all ads in the database are shown in the search result.
2. When I change the settings of the search module to:
a. Show search field, and
b. Fields all empty,
then the search seems to work fine (no error). (This is something I don’t understand).
3. The problem became apparent after the latest update of extensions, among which was OSMap Pro. I have uninstalled OSMap Pro and installed an older version of OSMap Free. (Didn’t help). I don’t see a direct relation with the search problem, but I thought I should mention this.

The technical environment of the website is:
• Joomla 3.9.x, hosted by Strato
• PHP 7.4.x
• MySQL 5.7.x
• Akeeba Admin Tools Pro
• Akeeba Subscription integration
• X/OSMap integration
• Adsmanager, with about 10.000 ads of a limited number of advertisers
Custom Fields
Joomla Version
PHP Version
Product Version
Friday, 06 August 2021 10:39 CEST
In a test environment I have updated Adsmanager to the latest version.

The search error (1191 - Can't find FULLTEXT index matching the column list) is still present in the updated website.

However it is now possible to edit the multple search field "ad_zoekveld".

Friday, 06 August 2021 11:14 CEST

Can you give me an access to that test environnement ?

Are you sure that every fields present in the Multiple search field names field in the parameter of the MultipleSearch field exist ?

Best regards.
Thursday, 12 August 2021 23:17 CEST
For the record, and as mentioned in an earlier response mail: Yes, I`m sure that all fields exist. The search module has worked fine for years.
Friday, 13 August 2021 11:07 CEST

You did not answer my question, Can you give me an access to that test environnement ?

Best regards.
Friday, 13 August 2021 11:47 CEST
Dear Loic,

I sure did replied on 6 augustus, by mail and I will do that ones more.


Friday, 13 August 2021 11:55 CEST

The email are not checked as often as the ticket. I will take a look.

You can safely share those kind of information by switching the ticket to private.

Best regards.
Monday, 16 August 2021 13:38 CEST

I have replied your last mail on saturday: removed re-direction and FTP credentials.
Tuesday, 24 August 2021 11:21 CEST
Dear Loic,

Any progress on this one?


Wednesday, 25 August 2021 08:32 CEST

I just answered you by email :)

Best regards.
Friday, 27 August 2021 12:25 CEST
Monday, 06 September 2021 09:04 CEST

More details about that issue.

It is not caused by AdsManager but by the database settings. Did you update the database (you or your host) ?

Best regards.
This ticket is closed, therefore read-only. You can no longer reply to it. If you need to provide more information, please open a new ticket and mention this ticket's number.