Hello,
When saving data to the database, a record has been created but there is no user name, password, none of the fields created in the form saved to the record? It only show the below data
cf_id : 0
uid : IMWJiNzk1MDQ1ZmYy670b3b8cd1fcdfb3ede18f12eb8f1a00
recordtime : 2010-01-26 - 13:35:44
ipaddress : 95.232.81.74
cf_user_id : 0
Under CB Registration I am getting this error Warning: Invalid argument supplied for foreach() in /home/metatlc1/public_html/components/com_chronocontact/plugins/cf_cb_registration.php on line 89?
Can anyone help? Thanks
Hi kmousi,
Please check the forums for similar messages, I don't believe that the plugin works with the latest release of CB.
Bob
Hello Bob,
Under my MyPHP admin I deleted the jos_chronoforms_Newsletter and now I am trying to create the table again but This message appers Error while creating table :You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') TYPE = MYISAM' at line 1 SQL=CREATE TABLE `jos_chronoforms_Newsletter` () TYPE = MYISAM ;
How can solve this? Thanks
Hi kmousi,
You haven't selected any fields and so you are trying to create an empty table with no columns. MySQL can't handle that.
Bob
Hi Bob,
Everything is working now (joomla registration and creates a record). But the email with this info does not go through. It used to work before I created the table is there something that needs to be changed?
The emails result is on(yes) and the email is set (green)? Can you help? Thanks
Hi kmousi,
Changing the DB Connection doesn't normally affect sending emails.
What is in the Emails column for this form in the Forms Manager? Does it say Enabled: 1 Disabled: 0 ?
Bob
Hi Bob,
This is the email template
Newsletter:{check0}
Coaching Institute: {check1}
Contact me: {check2}
Phone: {text_19}
Name: {text_7}
Username: {text_25}
Email: {text_28}
Confirm Email: {text_34}
Password: {text_27}
JobTitle: {select_19}
Grade Level: {select_20}
Address 1 {text_15}
Address 2 {text_21}
State: {select_22}
Zip: {text_18}
Country: {select_24}
All the fields are enabled and email results is on (yes). It was working before? Thanks
Here is a screen capture. Any thoughts? Thanks Bob.
Hi kmousi,
All that looks fine. What does the debug info say?
Bob
Hi Bob,
I turned on debug and test it. It did not say anything?
Now when a user fills out the form, it register them as user in Joomla (user must activate the account by the link) and creates a record of the user information submitted but it does not send the email with info? Should I turn off the joomla registration plugin and test if it work s then?
Hi kmousi,
I forgot, there's a setting in the Joomla Registration Plugin for the emails to send. What is that set to?
Bob
Hi Bob,
Attached are the settings. I just disabled Joomla registration and the email came through. So it possible for a form to send the user info via email, register the user to joomla and create a record to the database after the user activates their account? Should have them first create an account and after subscribe to the newsletter? Thanks
Hi kmousi,
No settings attached :-(
The better approach is to save the data to to database when they register but with a 'disabled' setting somewhere. Then it is possible to have a custom validation link come back to a form that will both unblock the registration and enable the database record.
This does require knowledge of Joomla, PHP and ChronoForms but it's not particularly difficult.
Bob
Hello Bob,
Under email verification > DB confing > form DB table > what do you select here? Do you select the form name jos_chronoforms_Newsletter ? What to write in the Verification flag field: ?
Thank you.