1. Forums
  3. Support and Presales
  5. Developer Members Support
  7. Column 'authProvider' cannot be null

Column 'authProvider' cannot be null

2 years 3 weeks ago - 2 years 3 weeks ago #328996 by dhphllps
Column 'authProvider' cannot be null was created by dhphllps
J! 4.1.1
PHP 8.0.16
CB 2.7.2+build.2022.03.22.14.03.47.175c40bd4

I just updated a site under construction to J! 4.1.1 and now there's a glitch in creating new users. Either from the front or back side, when I click Save I get the message:

"Column 'authProvider' cannot be null"

and the form remains open. If I simply click Save a second time, the user is saved. On the back side I'm taken back to the User Manager, and on the front side, the page says:

"You are already signed up with this username and password.
Sign Up Complete!"

In both cases the registration email is not sent. The only change was the update to J!4.1.1. In looking at the DB, it appears that authProvider is a new column in the users table in 4.1.1. If I change it to allow null, then everything works as expected. On first login, the column value is updated to Joomla. I guess this is a Joomla issue, not CB? Or should CB set the value on user creation?

Please Log in to join the conversation.

2 years 3 weeks ago #329002 by krileon
Replied by krileon on topic Column 'authProvider' cannot be null
Downgrade to 4.1.0 or wait for 4.1.2 (should be out soon). It's caused by a bug in Joomla's authentication plugin.

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

Please Log in to join the conversation.

2 years 3 weeks ago #329004 by beat
Replied by beat on topic Column 'authProvider' cannot be null
Joomla 4.1.2 and 3.10.8 have just been released, that fix this issue:

www.joomla.org/announcements/release-news/5858-joomla-4-1-2-and-3-10-8-release.html

You may have to clear the cache of Updates in Joomla updates to see it there.
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: dhphllps, RebeccaWool

Please Log in to join the conversation.

Moderators: beat, nant, krileon
  1. Forums
  3. Support and Presales
  5. Developer Members Support
  7. Column 'authProvider' cannot be null
Time to create page: 0.195 seconds

Facebook Twitter LinkedIn

    You are here:  
  1. Home
  2. Forums
  3. Support and Presales
  4. Developer Members Support
  5. Column 'authProvider' cannot be null

Search

Login / Logout

User Menu