• 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!

TOPIC: Search module not working

Search module not working 10 years 3 months ago #30077

  • ronnos
  • ronnos's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 2
I bought the RSEvents plugin today. Unfortunately the Search module isn't working. I reinstalled it, and tried it on a fresh joomla installation. It gives me the following SQL error:
1052 - Column 'name' in order clause is ambiguous

I hope someone can solve this problem for me
The administrator has disabled public write access.

Search module not working 10 years 3 months ago #30082

  • alexp
  • alexp's Avatar
  • OFFLINE
  • RSJoomla! Official Staff
  • Posts: 2253
  • Thank you received: 180
I tried to replicate this, but without success. Can you post an URL to a test page so we can have a look ? ...or even better submit a support request here:

https://www.rsjoomla.com/support.html
Please note: my help is not official customer support. To receive your support, submit a ticket by clicking here
Regards,
RSJoomla! Development Team
The administrator has disabled public write access.

Search module not working 10 years 3 months ago #30089

  • ronnos
  • ronnos's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 2
I'm still running at my local server, so I can't provide you an URL. Is this problem common? I'm running joomla 3.6.
The full error is:
1052 - COLUMN 'name' IN ORDER clause IS ambiguous SQL=SELECT `e`.`id` FROM `q46di_rseventspro_events` AS `e` LEFT JOIN `q46di_rseventspro_locations` AS `l` ON `l`.`id` = `e`.`location` LEFT JOIN `q46di_rseventspro_taxonomy` AS `tx` ON `tx`.`ide` = `e`.`id` LEFT JOIN `q46di_categories` AS `c` ON `c`.`id` = `tx`.`id` WHERE `e`.`completed` = 1 AND `c`.`extension` = 'com_rseventspro' AND `e`.`published` = 1 GROUP BY `e`.`id` ORDER BY `name` ASC LIMIT 0, 20

There are dublicate "name" entries?
Last Edit: 10 years 3 months ago by ronnos.
The administrator has disabled public write access.
  • 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!