- Posts: 61
- Thank you received: 2
SQL Error on Details Link
- Winston Baccus
- Topic Author
- Offline
- Senior Member
Less
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.
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.
- Tuan Pham Ngoc
- Offline
- Administrator
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
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.
- David Schroeter
- Offline
- New Member
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.
- Tuan Pham Ngoc
- Offline
- Administrator
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
Regards
Tuan
The following user(s) said Thank You: Winston Baccus
Please Log in or Create an account to join the conversation.
- David Schroeter
- Offline
- New Member
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.
This seems to have done the trick..
Best wishes,
David S.
Please Log in or Create an account to join the conversation.
- Tuan Pham Ngoc
- Offline
- Administrator
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
Tuan
Please Log in or Create an account to join the conversation.
- Winston Baccus
- Topic Author
- Offline
- Senior Member
Less
More
- Posts: 61
- Thank you received: 2
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.
- Tuan Pham Ngoc
- Offline
- Administrator
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
Tuan
Please Log in or Create an account to join the conversation.
Moderators: Tuan Pham Ngoc
Support
Documentation
Information
Copyright © 2024 Joomla Extensions by Joomdonation. All Rights Reserved.
joomdonation.com is not affiliated with or endorsed by the Joomla! Project or Open Source Matters.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.