SQL Error on Details Link

  • Winston Baccus
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
10 years 3 months ago - 10 years 3 months ago #41122 by Winston Baccus
SQL Error on Details Link was created by Winston Baccus
I'm getting a SQL error when I try to click on the Details link for an event:

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 'AND group_id=0 AND (published = 1 OR (payment_method LIKE "os_offline%" AND publ' at line 1 SQL=SELECT SUM(number_registrants) FROM zmgje_eb_registrants WHERE event_id= AND group_id=0 AND (published = 1 OR (payment_method LIKE "os_offline%" AND published != 2))

I did change the Title of my os_offline plugin to "Invoice or Purchase Order," not sure if that makes a difference.
Last edit: 10 years 3 months ago by Winston Baccus.
The following user(s) said Thank You: David Schroeter

Please Log in or Create an account to join the conversation.

More
10 years 3 months ago #41126 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Re: SQL Error on Details Link
That's strange. Could you please submit a support ticket :

1. Send me the link to the page

2. Send me admin and FTP account of your site.

3. I will check to see what's wrong and get it sorted for you.

Tuan

Please Log in or Create an account to join the conversation.

More
10 years 3 months ago #41149 by David Schroeter
Replied by David Schroeter on topic Re: SQL Error on Details Link
I have just discovered the same error after a fresh install of the component on Joomla! 3.2.2 with a Rockettheme Template.

Please Log in or Create an account to join the conversation.

More
10 years 3 months ago #41187 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Re: SQL Error on Details Link
Really sorry David. There was a bug in the code which I made two days ago (just one line of code modify, so I didn't test it). I fixed it yesterday, so please login to your account, access to My Downloads menu item, see your order and download it from there, upgrade it to your site. After that, the error will be gone !

Regards

Tuan
The following user(s) said Thank You: Winston Baccus

Please Log in or Create an account to join the conversation.

More
10 years 3 months ago #41199 by David Schroeter
Replied by David Schroeter on topic Re: SQL Error on Details Link
Thanks, Tuan.

This seems to have done the trick..

Best wishes,
David S.

Please Log in or Create an account to join the conversation.

More
10 years 3 months ago #41257 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Re: SQL Error on Details Link
Great. Thanks David for confirming !

Tuan

Please Log in or Create an account to join the conversation.

  • Winston Baccus
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
10 years 3 months ago #41293 by Winston Baccus
Replied by Winston Baccus on topic Re: SQL Error on Details Link
That fixed it for me as well. Thanks!

Please Log in or Create an account to join the conversation.

More
10 years 3 months ago #41305 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Re: SQL Error on Details Link
Great. Thanks Winston for confirming !

Tuan

Please Log in or Create an account to join the conversation.

Moderators: Tuan Pham Ngoc