- Posts: 4
- Thank you received: 0
Login or create new account.
By registering on joomprod.com, you will have immediate access to all our free products and to the public side of our support forum.
Enjoy our subscriptions.
Each of our subscriptions allow you to enjoy the private side of the support forum and all the update of our products for a period ranging from 3 months to 1 year.
Payment And immediate download.
After subscribing to one of our subscription, the products are immediately downloadable.
Login
Login
Support Availability Because we must sleep sometimes
Working days: Monday to Friday.
Reply time: Depending on the complexity of your support issue it's usually between a few hours to 48 hours.
Support is only guaranteed to paid subscribers
AdsManager - End of life
It is with great regrets that we have chosen to end the developpement of Adsmanager and its other associated components.
AdsManager is born 10 years ago and, as of today, the number of new subscriptions and downloads have fallen and we cannot maintain the component anymore.
All active subscribers will be able to continue enjoying support until the end of their subscription.
The components will be free and no support will be provided anymore for the other users.
Error message bei using top search field
8 years 3 months ago - 8 years 3 months ago #23340
by Planet Unicum
Error message bei using top search field was created by Planet Unicum
If I try to search by using top search module an error massage will be generated (see pict. below)
1191 Can't find FULLTEXT index matching the column list SQL=SELECT adext.*, a.id FROM #__adsmanager_ads as a LEFT JOIN #__paidsystem_ads as adext ON a.id = adext.id INNER JOIN #__adsmanager_adcat as adcat ON adcat.adid = a.id LEFT JOIN #__users as u ON a.userid = u.id INNER JOIN #__adsmanager_categories as c ON adcat.catid = c.id LEFT JOIN #__adsmanager_categories as p ON c.parent = p.id WHERE 1 AND a.published = 1 AND c.published = TRUE AND ( MATCH (a.ad_headline,a.ad_text) AGAINST ('test*' IN BOOLEAN MODE)) AND c.id IN (1,2,3,4,5,6,17,18,15,16,19,20,21,7,8,9,12,13,14) GROUP BY a.id
1191 Can't find FULLTEXT index matching the column list SQL=SELECT adext.*, a.id FROM #__adsmanager_ads as a LEFT JOIN #__paidsystem_ads as adext ON a.id = adext.id INNER JOIN #__adsmanager_adcat as adcat ON adcat.adid = a.id LEFT JOIN #__users as u ON a.userid = u.id INNER JOIN #__adsmanager_categories as c ON adcat.catid = c.id LEFT JOIN #__adsmanager_categories as p ON c.parent = p.id WHERE 1 AND a.published = 1 AND c.published = TRUE AND ( MATCH (a.ad_headline,a.ad_text) AGAINST ('test*' IN BOOLEAN MODE)) AND c.id IN (1,2,3,4,5,6,17,18,15,16,19,20,21,7,8,9,12,13,14) GROUP BY a.id
8 years 3 months ago - 8 years 3 months ago #23411
by Planet Unicum
Replied by Planet Unicum on topic Error message bei using top search field
By using advanced search module the failure does not occure.
The database: MySQL (by Strato)
Collation: UTF8 Fulltext exist (please see picture below)
The database: MySQL (by Strato)
Collation: UTF8 Fulltext exist (please see picture below)
Time to create page: 0.143 seconds