Skip to Content Skip to Menu

🎃 Happy Halloween! Treat yourself with an awesome discount on memberships! Get 20% off now with code SPOOKY-2024!

Registration triggers SQL alert

  • drock
  • drock
  • OFFLINE
  • Posts: 7
  • Thanks: 0
  • Karma: 0
11 years 6 months ago - 11 years 6 months ago #224669 by drock
Registration triggers SQL alert was created by drock
Hi,

Joomla! 3.0.3
CB 1.9

I've set up a full self-registration for my users. However, when a user tries to register, they get the following alert:
Code:
SQL = INSERT IN TO (,,,,,,,,,,,,,,) VALUES (75,0,0,0,0,0,0,1,0,0,1,0,1,1,0)

* 'INTO' = one word in alert


My SQL knowledge is limited but it seems above line of code doesn't make much sense as it lacks the table name after INTO?!

When re-typing the password and hitting register again, users get a note that registration requires mail confirmation and approval, which it shouldn't as I disabled the confirmation functionality.

Checking the user lists, users do get assigned to the database but only with username and email. No other field filled during registration makes it to the database. In the backend user list they appear as registered, but neither confirmed nor approved.

Would you have a hint for me which process could stand between the user registration and the database?

The backend registration settings are ...

on Joomla-side:
Joomla User Mgment > Options > Allow User Registration: NO

on CB-side:
CB Configuration > Reg > allow reg independent of global settings
CB Configuration > Reg > require admin approval / email confirm: no
CB Configuration > Reg > pending approval subject / email: blank

Not sure if of interest, but I'm also using a few conditional fields in the registration which might cause problems?!

Sorry for the long request, I'm trying to find a solution for quite some time without much success.

Many thanks for any hints!
Last edit: 11 years 6 months ago by drock. Reason: typo

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 48460
  • Thanks: 8280
  • Karma: 1443
11 years 6 months ago #224730 by krileon
Replied by krileon on topic Registration triggers SQL alert
I've no idea what that's coming from, but that's not a valid query nor does any of its values look familiar. Check and see if you setup a bad query in one of your plans using CBSubs SQL Actions or maybe using CB Auto Actions in a Query action is a bad query. If none of those are configured with a bad query this disable non-core Joomla user plugins 1 by 1 until resolved. If still not resolved repeat with Joomla system plugins. If still not resolved repeat with CB plugins.


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: beatnantkrileon
Powered by Kunena Forum