Error: 1054 Unknown column 'a.newregs' in 'where clause' SQL=SELECT COUNT(*) FROM `#__cbsubs_payments`......

7 years 8 months ago #283251 by D1on
Hi,

We are getting the following error when trying to access or search for New or Renewing memberships from the CB Subs Payments page, e.g.

An error has occurred.

1054 Unknown column 'a.newregs' in 'where clause' SQL=SELECT COUNT(*) FROM `#__cbsubs_payments` AS a WHERE ( a.`payment_status` = 'Completed' ) AND ( a.`newregs` = '1' ) AND ( a.`time_paid_date` = '2016-06-28' )

This is on a Joomla 3.5.1 website with the latest version of CB and CBSubs, e.g.

Community Builder: 2.0.14
CBSubs: 4.1 (cbplug_CBSubs_MAIN-4.1.0+build.2016.06.13.00.20)

Can you please help resolve this issue?

Thanks,

Dion.
Attachments:

Please Log in to join the conversation.

7 years 8 months ago #283279 by krileon
It's a known issue as originally found below.

www.joomlapolis.com/forum/256-cbsubs-support/231942-payments-filter-by-new-registrations-does-not-work

Logout of backend to clear your session, which will clear filters. Then don't use that filter for the time being.


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 to join the conversation.

7 years 8 months ago #283411 by D1on
Hi Kyle,

Any idea when this issue will be resolved? as it's an important Filter (for New and Renewing memberships) that should be working.

Thanks,

Dion.

Please Log in to join the conversation.

6 years 6 months ago #296995 by D1on
Hi Kyle,

Any update or fix for this issue?

it's still happening with the latest CBSubs 4.1.1...

Error message: cbsubs 1054 Unknown column 'a.newregs' in 'where clause'

Thanks,

Dion

Please Log in to join the conversation.

6 years 6 months ago #296996 by beat
Hi Dion,
That bugfix didn't make it into 4.1.1, as we already gave it 2 tries to fix it, but it's a non-trivial bug that needs some dedicated time to fix it. I have now increased its priority again.

Beat - Community Builder Team Member

Before posting on forums: Read FAQ thoroughly -- Help us spend more time coding by helping others in this forum, many thanks :)
CB links: Our membership - CBSubs - Templates - Hosting - Forge - Send me a Private Message (PM) only for private/confidential info
The following user(s) said Thank You: D1on

Please Log in to join the conversation.

6 years 6 months ago #297024 by D1on
Hi Beat,

It would be great to have this bug finally fixed as it was pointed out to me again by one of our clients this week.

Thanks,

Dion.

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.297 seconds

Facebook Twitter LinkedIn