Forums

This issue has been solved. I had failed to turn the CB plugin on, in the Plugins tab of the form. OnSubmit, the user is created, the application is added to the database and the entire form response is being emailed as per the email list. However, the confirmation plugin is not. Updating to RC5 and will continue to update.

Hey there,

I'm using Joomla 1.5, Community Builder 1.2 Stable with the latest version of Chronoforms. I have a PHP 5 enabled database. I've created my application form and have it posted here: http://semue.com/index.php?option=com_content&view=article&id=3%3Aapplication&catid=1%3Aapplication&Itemid=3

I followed the tutorial for linking the form submission with my User database, and that part works fine. I get an email with the Name, Username and Email and the User is entered into CB Profiles but...

The rest of the information on my application is not emailed. It does get entered into the associated database which is jos_chronoforms_application. What do I have to fix or enter to make the entire application get emailed?

I've double checked the email template of the form, and it's fine. All of the defined fields are properly listed and ID'd.

Thank you in advance for any assistance you can render in this matter =D

Hi,

Do you have Emails setup per this form ? the emails in the CB plugin config are the default registration emails which doesn't include any extra details!

Regards
Max

Yes, I have set the email template in the Email Template tab of the application form. Here is what I have:

Name: {text_14}
Username: {text_15}
Email: {text_16}
Character Name: {text_1}
Character Class: {select_8}
Describe what you are hoping to gain from Semue Shal'tek: {text_4}
MMO Style that fits you best (check as many as apply): {check0}
List other MMOs you have played: {text_7}
List of other guilds/player associations you have been a member: {text_6}
Are you interested in a leadership position? {radio1}
How did you hear about Semue Shal'tek? {text_8}
Have you read and agree to our Code of Conduct? {radio2}
Have you read and agree to our Policies and Procedures? {radio3}
Do you have any specific questions you'd like answered? {text_13}

Do I need to disable the CB plugin emails? If so, how?

and do you have any emails setup and enabled in the "setup emails" tab ?

Max

Yes. I have the To: Subject: fromName: and fromEmail: fields with the proper information.

Bump to get an answer, and to help I just ran a test and this was the resulting email:

Hello Administrator,

A new user has registered at Semue Shal'tek.
This e-mail contains their details:

Name: test
E-mail: [email]test@test.com[/email]
Username: test

Please do not respond to this message. It is automatically generated and is for information purposes only.

As you can see, the rest of the application information isn't being submitted.

Hi,

This is the default registration email, this is not the Chronoforms custom email, can you see "Enabled : 1" in your forms manager in front of the form you have ?

Cheers
Max

Yes, in the Emails column of Forms Management it says Enabled:1, Disabled:0

After reading some of the other posts I double checked my Plugins tab and noticed I had no entries there. Would that make a difference?

~edit~
I've been running a few more tests and did a debug. My form is now creating the user in Community Builder, making a database entry for the application and emailing all of the results. I've made sure to disable my CB plugin from running and only have the confirmation page plugin enabled and I get the following error:


Parse error: syntax error, unexpected T_IF, expecting ',' or ';' in /home/content/l/i/s/lisentia/html/components/com_chronocontact/libraries/chronoform.php(138) : eval()'d code on line 3
Thank you for your submission! A officer will review your application and be in touch with you shortly.

Hi lisentia,

please upgrade to RC5 and let me know if you still have the same problem!

Cheers
Max

Okay. I will update to RC5 tomorrow and work on getting the confirmation page to work.

I updated to RC5, turned on the Confirmation Page plugin, set it to run as 2 right after the CB plugin and received the error "You do not have access to this URL"

Turning the confirmation plugin back off, everything works as normal again.

Hi, why do you need "confirmation page" plugin ? you don't need it here!

Cheers
Max

Because I'd like to have a confirmation page show after the individual submits the form. As it stands now, they are being redirected with no way of them double checking their submission.

Hi lisentia,

the Confirmation page simply holds the form submission until the Confirmation code is shown to the user and if the user clicked submit again then the form is really submitted now and submit routines takes action! do you need this ? if yes then I'm not sure if this will interfere with the CB plugin because I didn't try them together!

Cheers
Max

Yes please. I do need them to work. Should I switch the order so the confirmation page plugin runs first?

Okay. I have the CB plugin running as 1, and the confirmation page plugin running as 2. These are the errors I am receiving:

Unknown column 'forumkarma' in 'field list' SQL=INSERT INTO jos_comprofiler (id,user_id,middlename,firstname,lastname,forumkarma) VALUES ('86','86','','','',''); <=with a red background

Parse error: syntax error, unexpected T_IF, expecting ',' or ';' in /home/content/l/i/s/lisentia/html/components/com_chronocontact/libraries/chronoform.php(212) : eval()'d code on line 3

and then my confirmation page:
Thank you for your submission! A officer will review your application and be in touch with you shortly.
Please be sure to check your email for your verification link to complete your registration process.
Click any of the links above to continue.
[Submit][Back]

Hi Lisentia,

The first error looks like the field forumkarma doesn't exist in the jos_comprofiler table (this isn't a field that is created in the default setup).

The second error is a typo of some kind in the server-side validation code (check line 3 or thereabouts).

Bob

Okay, so how would I go about fixing those errors?

Hi Lisentia,

For the first one you'll need to find out why the field isn't there _ I think perhaps you have to add a custom field in CB. I'm not a CB user so can't help much there.

For the second one - debug the code, or post it here so that we can see what's there.

Bob

Okay, what code from where? This is the same error I got earlier before I updated to RC5

Hi lisentia,

The second error is a typo of some kind in the server-side validation code (check line 3 or thereabouts).

Bob

Hey Bob,

My name is Lisentia, not Lisa =)

And what page is that server side validation code found in? I want to be able to give you the right information to look at to help me, and not something I just *think* is the right thing =D

Hi Lisentia,

Please post any code in the server side validation box under the validation tab in the form edit page, do you have any thing there ?

The CB plugin has been making some trouble recently and I tried to fix that but the CB itself is not clear when looking at the tables scheme, I will try to take another look before RC5.1

Regards
Max

Hi Lisentia,

Apologies for getting your name wrong :-(

As Max says the Server-side Validation code is on the Validation Tab for your form.

Bob

<?php
global $mainframe
if (JRequest::getVar('text_17') != JRequest::getVar('text_18'))
return 'Please be sure your passwords match';
?>

That's the code I have in the server side validation box, under the validation tab of my form. I did hand add this code after going through the Chronoforms tutorial.

I have Enable Validation set to Yes, and Validation Library set to mootools.

Should these be backwards? Should I have text_18 first before text_17?

HI lisentia,

There's a ; missing on line 2 should be

global $mainframe;

Try that, you may get another error because there are some places where PHP won't let you use the JRequest::getVar() syntax. If this happens try

<?php
global $mainframe;
$text_17 = JRequest::getVar('text_17');
$text_18 = JRequest::getVar('text_18');
if ( $text_17 != $text_18 ) {
  return 'Please be sure your passwords match';
}
?>

Bob

THANKS! I'll definitely try that =D

It works perfectly! The forumkarma problem was because I had tried to enable it for CB, instead of checking my forums settings. I've turned it off.