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

Or Register
Accueil / forum / Public Forum / Main Forum / AdsManager search returns SQL error

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.

×

Notice

The forum is in read only mode.

  1. forum
  3. Public Forum
  5. Main Forum
  7. AdsManager search returns SQL error
× OLD Forum post could be checked here : forum.joomprod.com

AdsManager search returns SQL error

  • TeroKankaanpera
  • Topic Author
  • Offline
  • User
  • User
More
10 years 11 months ago - 10 years 11 months ago #16896 by TeroKankaanpera
AdsManager search returns SQL error was created by TeroKankaanpera

1214 - The used table type doesn't support FULLTEXT indexes SQL=SELECT a.id FROM f73_adsmanager_ads as a INNER JOIN f73_adsmanager_adcat as adcat ON adcat.adid = a.id LEFT JOIN f73_users as u ON a.userid = u.id INNER JOIN f73_adsmanager_categories as c ON adcat.catid = c.id LEFT JOIN f73_adsmanager_categories as p ON c.parent = p.id WHERE a.published = 1 AND c.published = TRUE AND a.publication_date <= NOW() AND ( MATCH (a.ad_headline,a.ad_text) AGAINST ('vesannon*' IN BOOLEAN MODE)) AND c.id IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14) GROUP BY a.id


That's what I get when I try to use the AdsManager search box in the frontend.

Joomla! version: 3.4.5 Platform: Apache PHP version: 5.4.38 | safe_mode: Off | register_globals: Off | mbstring: Enabled | GD: bundled (2.1.0 compatible) | MySQL version: 5.5.42-cll | Base URL:

Database collation check: The collation of your table fields are correct

Joomla! SEF: Enabled | Joomla! SEF rewrite: Enabled | FTP layer: Disabled |
htaccess: Exists | PHP environment: Max execution time: 30 seconds | Max execution memory: 128M | Max file upload: 6M

Joomla default template details : nagre960template | author: NagreMedia | version: 1.7.0 | creationdate: 2011

Kunena default template details : Blue Eagle | author: Kunena Team | version: 4.0.7 | creationdate: 2015-11-16

Third-party components: None

Third-party SEF components: None

Last edit: 10 years 11 months ago by TeroKankaanpera.
More
10 years 11 months ago #16905 by tompap
Replied by tompap on topic AdsManager search returns SQL error
It's the type of your mysql table which should be MyISAM and not InnoDB (as define in the SQL) I don't know if you change it or not but please change it using phpMyAdmin for example
The following user(s) said Thank You: adarr
Moderators: perry
  1. forum
  3. Public Forum
  5. Main Forum
  7. AdsManager search returns SQL error
Time to create page: 0.049 seconds
Powered by Kunena Forum