Buy Now
Sign in

Issues saving to DB after Joomla Registration

cyberrock , October 26 2016
c
cyberrock

Hi Bob,
I have followed the FAQ page for getting the joomla user ID after the registration plugin with :
<?php
$form->data['user_id'] = $form->data['_PLUGINS_']['joomla_registration']['id'];
?>
In the debugger, I can see the user_id and value, though it is not being saved to the database

				Array
(
[chronoform] => Registeration
[event] => submit
[option] => com_chronoforms5
[Name] => Ben
[Email] => ben@gigreview.com.au
[Password] => Packard12
[Password2] => Packard12
[Company] =>
[Phone] => 1300416722
[Address] => company drv
[DefaultPUName] =>
[DefaultPUPhone] =>
[DefaultPUAddress] =>
[DefaultDelName] =>
[DefaultDelPhone] =>
[DefaultDelAddress] =>
[PaymentPreference] => 0
[button32] => Register
[name] => Ben
[username] => ben@gigreview.com.au
[email] => ben@gigreview.com.au
[password] => Packard12
[password2] => Packard12
[_PLUGINS_] => Array
(
[joomla_registration] => Array
(
[*isRoot] => 1
[id] => 140
[name] => Ben
[username] => **EMAIL**
[email] => **EMAIL**
[password] => $2y$10$M0SGbnU2eJ6WWgm7Sljwoe2Uu.sfu4kSJ4mOZMXyKmPjO.zy9utmS
[password_clear] => ************
[block] => 0
[sendEmail] => 1
[registerDate] => 2016-10-26 20:58:31
[lastvisitDate] => 2016-10-26 10:35:58
[activation] => 0
[groups] => Array
(
[0] => 10
)

[lastResetTime] => 0000-00-00 00:00:00
[resetCount] => 0
[requireReset] => 0
[*_params] => Joomla\Registry\Registry Object
(
[data:protected] => stdClass Object
(
)

[initialized:protected] => 1
[separator] => .
)

[*_authGroups] => Array
(
[0] => 1
[1] => 8
)

[*_authLevels] => Array
(
[0] => 1
[1] => 1
[2] => 2
[3] => 3
[4] => 6
)

[*_authActions] =>
[*_errorMsg] =>
[*userHelper] => JUserWrapperHelper Object
(
)

[*_errors] => Array
(
)

[otpKey] =>
[otep] =>
[chronoform] => Registeration
[event] => submit
[option] => com_chronoforms5
[Name] => Ben
[Email] => **EMAIL**
[Password] => ************
[Password2] => ************
[Company] =>
[Phone] => 1300416722
[Address] => company drv
[DefaultPUName] =>
[DefaultPUPhone] =>
[DefaultPUAddress] =>
[DefaultDelName] =>
[DefaultDelPhone] =>
[DefaultDelAddress] =>
[PaymentPreference] => 0
[button32] => Register
[password2] => ************
[usertype] => deprecated
)

)

[user_id] => 140
[id] => 1
)


				Array
(
[9] => Array
(
[DB Save] => Array
(
[Queries] => Array
(
[0] => INSERT INTO `rwxoq_company_details` (`Company`, `Phone`, `Address`, `DefaultPUName`, `DefaultPUPhone`, `DefaultPUAddress`, `DefaultDelName`, `DefaultDelPhone`, `DefaultDelAddress`, `PaymentPreference`) values ('', '1300416722', 'company drv', '', '', '', '', '', '', '0');
)

)

)

)

Are you able to help please?

Thank you
Ben

GreyHead

Hi Ben,

The User_id isn't showing up in the database INSERT statement. Please try clicking the Delete Cache icon in the Forms Manager toolbar to update CF's table records and see if that make the difference.

Bob

ChronoForms technical support
If you'd like to buy me a coffee or two, thank you very much

c
cyberrock

Thanks for the prompt reply Bob,

				Array
(
[10] => Array
(
[DB Save] => Array
(
[Queries] => Array
(
[0] => INSERT INTO `rwxoq_company_details` (`Company`, `Phone`, `Address`, `DefaultPUName`, `DefaultPUPhone`, `DefaultPUAddress`, `DefaultDelName`, `DefaultDelPhone`, `DefaultDelAddress`, `PaymentPreference`, `user_id`) values ('', '1300416722', 'dfdw', '', '', '', '', '', '', '0', '0');
)

)

)

)

It now shows that it is adding a value, though, it is always '0' i have tried to play around with it, but it is always 0..

I even placed an echo $form->data['user_id']; in the conditions, and it prints the proper value... it just doesnt like being saved in to the database


Ben

GreyHead

Hi Ben,

Hmm . . . is the sequence of the actions like this: Joomla! Registration > Custom Code > DB Save ??

Bob

ChronoForms technical support
If you'd like to buy me a coffee or two, thank you very much

c
cyberrock

the custom code is in the DB save

GreyHead

Hi Ben,

Please try moving it into a Custom Code action before the DB Save action and see if that solves the problem.

Bob

ChronoForms technical support
If you'd like to buy me a coffee or two, thank you very much

c
cyberrock

Disregard.... Sorry Bob.. I just realized the i was using the updated conditions instead of a custom code.... It now works... thanks Bob