Skip to Content Skip to Menu

[SOLVED] Error message after payment 1048 column 'subid' cannot be null

  • marse7
  • marse7
  • OFFLINE
  • Posts: 138
  • Thanks: 38
  • Karma: 10
6 years 1 month ago - 6 years 3 weeks ago #307890 by marse7
Hello,

I get this message on two plans (five in all) after paying for the membership plans using a credit card. Not sure if it happens in PayPal - still checking.

1048 column 'subid' cannot be null

The plans under which it occurs are copies of other plans with just the information and pricing changed so there is really nothing all that different between plans.

I'm using the latest build on both Community Builder and CB Subs and Joomla is up to date.

Any thoughts?
Mark

4.3.0+build.2018.07.05.21.23.07.5cee7f443
2.21
3.8.12
Last edit: 6 years 3 weeks ago by krileon. Reason: Added [SOLVED] tag to subject

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 48536
  • Thanks: 8290
  • Karma: 1445
6 years 1 month ago #307930 by krileon
The latest CB build is 2.2.1+build.2018.10.01.17.35.11.88680736f. Please be sure CB it self is up to date as appears you maybe strictly using the stable release which is several builds behind. You mentioned this only happens to the copies of your plans when paying with credit card. What payment gateway are you using specifically? I'm not sure how subid could be empty as that contains the subscription id. Only thing I can think of is if the plan is free lifetime and you don't have subscriptions enabled for free lifetime plans.


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: marse7

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

  • marse7
  • marse7
  • OFFLINE
  • Posts: 138
  • Thanks: 38
  • Karma: 10
6 years 1 month ago #307980 by marse7
Hmmm. Well free subscriptions have been a part of this org since the start so they are activated.

I'll update, do a more thorough testing on gateways and get back to you.

Many thanks!
Mark
The following user(s) said Thank You: krileon

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

  • marse7
  • marse7
  • OFFLINE
  • Posts: 138
  • Thanks: 38
  • Karma: 10
6 years 3 weeks ago #308128 by marse7
I installed the latest build as suggested. Most plans were then fine.

But I still had same issue (see screen shot on original post) with the "STUDENT PLAN." So I recreated the a new Student plan from scratch and that fixed it.

When I first created these three new plans I cloned an existing membership plan. Perhaps there is some issue with that?

Anyway, this has been fixed.

Thank you,
Mark
The following user(s) said Thank You: krileon

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

  • beat
  • beat
  • ONLINE
  • Posts: 2169
  • Thanks: 463
  • Karma: 352
5 years 8 months ago #311380 by beat
Cross-referencing the problem pinpointed and solution here: Was caused by a user-writting SQL query in CBSubs Query plugin settings: www.joomlapolis.com/forum/255-developer-members-support/240719-7495-authorize-net-gateway-not-working-sorta?start=18#311376

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

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

Moderators: beatnantkrileon
Powered by Kunena Forum