Forums

Welcome, Guest
Username: Password: Remember me

TOPIC: error in your SQL syntax;

error in your SQL syntax; 1 year 11 months ago #3681

  • sloguy
  • sloguy's Avatar
  • Offline
  • Fresh Boarder
  • Posts: 5
  • Karma: 0
I have install the quickstart package, but when I visit the 'Directory>Featured Listing' pre-installed links, I get the following error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*) ......

clicking on the pre-installed 'Directory>Search', I get this error:
500 - Unknown column 'txref.tag_id' in 'on clause' SQL=SELECT 1 FROM cgk1t_judirectory_listings AS listing JOIN cgk1t_judirectory_listings_xref AS listingxmain ON listing.id = listingxmain.
and the same with the pre-installed"Directory>Alpha Listing:
500 - Unknown column 'txref.tag_id' in 'on clause' SQL=SELECT 1 FROM cgk1t_judirectory_listings AS listing JOIN cgk1t_judirectory_listings_xref AS listingxref ON listing.id = listingxref.listing_id.

Thanks for your help with this issue.
cheers~
Robert
The administrator has disabled public write access.

error in your SQL syntax; 1 year 11 months ago #3684

  • admin
  • admin's Avatar
  • Offline
  • Administrator
  • Posts: 1641
  • Thank you received: 178
  • Karma: 43
Hi,
If you install quick start of JU Directory template, then install latest version of JU Directory component override the existing one.
The administrator has disabled public write access.

error in your SQL syntax; 1 year 11 months ago #3686

  • sloguy
  • sloguy's Avatar
  • Offline
  • Fresh Boarder
  • Posts: 5
  • Karma: 0
I have done that already... when I notice that the pro features (map in listing) were not available. These features are working currently. I currently have JU Directory v1.1.2, which seems to be the current version.
The administrator has disabled public write access.

error in your SQL syntax; 1 year 11 months ago #3687

  • admin
  • admin's Avatar
  • Offline
  • Administrator
  • Posts: 1641
  • Thank you received: 178
  • Karma: 43
With the map feature, please make sure that you enable location field in field manager.
If any issue, send me your site url + admin account via: www.joomultra.com/contact-us.html
I'll check it closer.
The administrator has disabled public write access.
Time to create page: 0.230 seconds
Powered by Kunena Forum