Social Extensions Integration

MySQL error using Joomdle CbSubs Plugin

  • 3by400, Inc.
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
4 years 2 months ago - 4 years 2 months ago #1 by 3by400, Inc.
MySQL error using Joomdle CbSubs Plugin was created by 3by400, Inc.
When we subscribe a user to the CBSubs plan, from both the backend or frontend, we receive an error that says:

Code:
0 Could not connect to MySQL server.
Last edit: 4 years 2 months ago by 3by400, Inc..

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

More
4 years 2 months ago #2 by Antonio Durán
Replied by Antonio Durán on topic MySQL error using Joomdle CbSubs Plugin
Hi.

Which Cb Subs version are you using? Can you email it to antonio at joomdle so I can test please?

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

  • 3by400, Inc.
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
4 years 2 months ago #3 by 3by400, Inc.
Replied by 3by400, Inc. on topic MySQL error using Joomdle CbSubs Plugin
We're using CB Paid Subscriptions version 4.5.3+build.2022.02.01.10.46.06.27f67b177

I've emailed you the package.

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

More
4 years 2 months ago #4 by Antonio Durán
Replied by Antonio Durán on topic MySQL error using Joomdle CbSubs Plugin
Thank you. I tested locally and could not replicate the problem.

Are you sure the error is coming from Joomdle? Please try disabling any other integrations in the plan and test only with the Joomdle one enabled, to try to confirm.

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

  • 3by400, Inc.
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
4 years 2 months ago #5 by 3by400, Inc.
Replied by 3by400, Inc. on topic MySQL error using Joomdle CbSubs Plugin
Yes, the error only occurs on the specific plan with Joomdle in use, and when we disable the Joomdle course assignment the plan the error doesn't occur. I think all other CB Subs plugins are CB-developed. I'm attaching a screenshot of our other CB Subs plugins.

Users are being synced to Moodle as expected via CB, so the mysql connection error is specific to Joomdle in CB Subs.

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

  • 3by400, Inc.
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
4 years 2 months ago #6 by 3by400, Inc.
Replied by 3by400, Inc. on topic MySQL error using Joomdle CbSubs Plugin
Also, on the plan edit screen we're shown this message in a red warning:

"The CBSubs integration plugin 'CBSubs Joomdle' is for another CBSubs version 4.3.0."

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

  • 3by400, Inc.
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
4 years 2 months ago #7 by 3by400, Inc.
Replied by 3by400, Inc. on topic MySQL error using Joomdle CbSubs Plugin
I think I've found the issue and corrected it, and then the subscription to the CB Subs plan successfully enrolled me in the Moodle course.

The CBSubs SQL Action tab had an "external" radio option checked, so I guess that was causing it to try and connect to empty server settings.

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

More
4 years 2 months ago #8 by Antonio Durán
Replied by Antonio Durán on topic MySQL error using Joomdle CbSubs Plugin
Great to know that you fixed the issue, thanks for the letting us know the solution.

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