Skip to Content Skip to Menu

SQL error in GJ Event Attendance ( CB plugins backend)

  • kdave321
  • kdave321
  • ONLINE
  • Posts: 208
  • Thanks: 26
  • Karma: 2
2 days 15 hours ago #341217 by kdave321
SQL error in GJ Event Attendance ( CB plugins backend) was created by kdave321
When I clicked to sort by event  I got this:

Database loading error. Check and repair your database in Components / Community Builder / Tools.
SQL Error (visible to super-admins only): Unknown column 'c.eventtitle' in 'order clause'
I have not upgraded to latest build. Using 3.6.0-build2025-3-4

I see the "data name="title" as="eventtitle" in view.com_comprofiler.showgjattendancerows.xml , so the SQL is getting constructed incorrectly.

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 49229
  • Thanks: 8415
  • Karma: 1462
2 days 14 hours ago #341220 by krileon
Replied by krileon on topic SQL error in GJ Event Attendance ( CB plugins backend)
Is there any filtering also applied? or just trying to sort by event title? Sorting and searching by event title appears working in my tests.

Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 49229
  • Thanks: 8415
  • Karma: 1462
2 days 14 hours ago #341221 by krileon
Replied by krileon on topic SQL error in GJ Event Attendance ( CB plugins backend)
Ok, was able to confirm. Sorry, missed that you meant in Event Attendance. Am working on a fix.

Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 49229
  • Thanks: 8415
  • Karma: 1462
2 days 14 hours ago #341224 by krileon
Replied by krileon on topic SQL error in GJ Event Attendance ( CB plugins backend)
Ok, this is now fixed in latest GJ Events integration. Thank you for letting us know!

Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
The following user(s) said Thank You: kdave321

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

  • kdave321
  • kdave321
  • ONLINE
  • Posts: 208
  • Thanks: 26
  • Karma: 2
2 days 14 hours ago #341226 by kdave321
Replied by kdave321 on topic SQL error in GJ Event Attendance ( CB plugins backend)
No filtering.  I had a few dozen entries in the table. Sorting by user, group, date, and id works fine.

The table didn't change, right? The column is still "title"?

What script creates the SQL?

It's not critical. I just wanted to see who was attending a past event, before adding other attendees. I can use the search tool but then I have to look up the event id.

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 49229
  • Thanks: 8415
  • Karma: 1462
2 days 14 hours ago #341227 by krileon
Replied by krileon on topic SQL error in GJ Event Attendance ( CB plugins backend)
You should be able to search and sort by event title fine with latest release as a fix has been implemented. Only sorting was bugged. Searching was working fine.

Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

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

Moderators: beat, nant, krileon
Powered by Kunena Forum