Forums

Migrating a site to latest Joomla & Chronoforms on a clients server.

When email IS NOT ENABLED - the form submits (where it goes I don't know) and redirects to a thank you page.

When email IS ENABLED - the form stalls at submit. The icon spins and the fill bar shows empty until I kill the process.

The client relies heavily on Chronoforms in their current website. At this point - I have no idea how to proceed - or what to try.

Could there be a conflict with another component? (Mosets Tree/SWMenu Pro/FlexBanner/Xplorer)?

Could there be email rules I don't know about? Could it be a module conflict?

Any help is appreciated. Deadline is fast approaching. Thanks!

I installed the ChronoForms update V3.1_RC4.11.zip.

It erased my email information in the Set UP Emails tab.

So I went back in and filled it out

To Email
Subject
From Name
From Email

I enable the "Enable" pulldown and clicked Apply.

I then went up and saved. I then got this huge error message:

TableChronoContactEmails::store failed - Unknown column 'replytoname' in 'field list' SQL=INSERT INTO `jos_chrono_contact_emails` ( `formid`,`to`,`dto`,`subject`,`dsubject`,`cc`,`dcc`,`bcc`,`dbcc`,`fromname`,`dfromname`,`fromemail`,`dfromemail`,`replytoname`,`dreplytoname`,`replytoemail`,`dreplytoemail`,`enabled`,`params`,`template` ) VALUES ( '4','tag1365@yahoo.com','','HR Application','','','','','','John','','webmaster@andersonhospital.org','','','','','','1','recordip=1\nemailtype=html\nenabled=1\neditor=1\nenable_attachments=1','TEST PRIME Making a difference one footstep at a time.....\r\n

\r\n Submit your information with our secure form below
\r\n\r\n

Due to limited availability, our classes are only open to those families delivering at Anderson Hospital Pavilion for Women.
\r\n\r\n

Select \r\n Course 1: \r\n  {Course_Selection_1}
\r\n

\r\n Desired Class Month / Date:        \r\n \r\n {Desired_Class_1}
\r\n

Select \r\n Course 2: \r\n  {Course_Selection_2}
\r\n

\r\n Desired Class Month / Date:\r\n {Desired_Class_2}
\r\n

Select \r\n Course 3: \r\n  {Course_Selection_3}
\r\n

\r\n Desired Class Month / Date:\r\n {Desired_Class_3}
\r\n

Name:\r\n \r\n  {Name}
\r\n

\r\n Address: \r\n  {Address}
\r\n

City:\r\n {City} \r\n State: \r\n {State} \r\n Zip: {Zip}
\r\n

\r\n Contact Phone Numbers:
\r\n

Home:\r\n \r\n {Home_Phone}
\r\n

Work:\r\n \r\n {Work_Phone}
\r\n

Cell:\r\n \r\n {Cell_Phone}
\r\n

\r\n Physician : \r\n  {Physician}
\r\n

Due \r\n Date:
\r\n

Day:\r\n \r\n  {Delivery_Day} Month: \r\n \r\n  {Delivery_Month} Year: \r\n \r\n  {Delivery_Year}
\r\n

\r\n Coaches Name: \r\n {Couches_Name}
\r\n

Which \r\n Pregnancy is this? \r\n  {Pregnancy_number}
\r\n

Names \r\n And Ages Of Children for Sibling Class
\r\n

Child \r\n Name \r\n {Child_name_1} \r\n Age \r\n {Child_Age_1}
\r\n

Child \r\n Name \r\n {Child_Name_2} \r\n Age \r\n {Child_Age_2}
\r\n

Child \r\n Name \r\n {Child_Name_3} \r\n Age \r\n {Child_Age_3}
\r\n

Child \r\n Name \r\n {Child_Name_4} \r\n Age \r\n {Child_Age_4}
\r\n

Email \r\n Address for confirmation: \r\n \r\n {email_address}
\r\n

Are \r\n you delivering at Anderson? Yes \r\n {Delivering_Yes}    \r\n No {Delivering_No}
\r\n

{imageverification}
\r\n

\r\n
' )

Now it looks like my chronoforms is MORE broke then before.


I really need some help on this.

Hi cb1,

Whice version are you upgrading from? The old database table seems to be missing the 'replytoname' field - I think that was added quite a while back. Here's the current 'create code for the table from my test site. Please compare this with your tabele and add any missing fields.

CREATE TABLE  `jos_chrono_contact_emails` (
  `emailid` int(11) NOT NULL AUTO_INCREMENT,
  `formid` int(11) NOT NULL,
  `to` text NOT NULL,
  `dto` text NOT NULL,
  `subject` text NOT NULL,
  `dsubject` text NOT NULL,
  `cc` text NOT NULL,
  `dcc` text NOT NULL,
  `bcc` text NOT NULL,
  `dbcc` text NOT NULL,
  `fromname` text NOT NULL,
  `dfromname` text NOT NULL,
  `fromemail` text NOT NULL,
  `dfromemail` text NOT NULL,
  `replytoname` text NOT NULL,
  `dreplytoname` text NOT NULL,
  `replytoemail` text NOT NULL,
  `dreplytoemail` text NOT NULL,
  `enabled` tinyint(1) NOT NULL,
  `params` longtext NOT NULL,
  `template` longtext NOT NULL,
  PRIMARY KEY (`emailid`)
) ENGINE=MyISAM AUTO_INCREMENT=79 DEFAULT CHARSET=utf8;

Bob

It was upgraded from version 3.1 RC2

Now - what you are asking: Is this done in mySQL? Or is this done from the Chronoforms component?

Is there - by any chance - a tutorial that shows how to do this?

At the moment - I am waiting for the client to upgrade the php to version 5.2 from 5.1 - should I wait for them to do the upgrade before I try this?

Thanks!

Hi cb1,

First of all, backup the DB tables through phpmyadmin!

now backup forms, uninstall the Chronoforms completely, install RC4.11 again OR just wait for the new RC4.2 to go out in a few hours then restore forms!

Regards
Max

While waiting for 4c2 I uninstalled and reinstalled rc11.

That cleared up the previous problem regarding the reply to column in the table.

But it still did not fix the issue with the application choking out when you enable an email address.

When I disabled the email address - I get this in the debug diagnostics:

   1. Form passed first SPAM check OK
   2. Form passed the submissions limit (if enabled) OK
   3. Form passed the Image verification (if enabled) OK
   4. Form passed the server side validation (if enabled) OK
   5. $_POST Array: Array ( [Course_Selection_1] => Prep School for Dads [Desired_Class_1] => 010910 [Course_Selection_2] => Infant/Child CPR [Desired_Class_2] => 010410 [Course_Selection_3] => Sibling [Desired_Class_3] => 010110 [Name] => Elvis [Address] => 111 Main [City] => Edville [State] => IL [Zip] => 11111 [Home_Phone] => 111-111-1111 [Work_Phone] => 111-111-1111 [Cell_Phone] => 111-111-1111 [Physician] => Dr. Michael Scharff [Delivery_Day] => 8 [Delivery_Month] => October [Delivery_Year] => 2009 [Couches_Name] => Coach Pat [Pregnancy_number] => 7 [Child_name_1] => Biff [Child_Age_1] => 7 [Child_Name_2] => Bob [Child_Age_2] => 17 [Child_Name_3] => Randy [Child_Age_3] => 19 [Child_Name_4] => Mabel [Child_Age_4] => 10 [email_address] => myemailwashere [Delivering_Yes] => ON [B1] => Submit [a31f04835dc80ca2ecfeed2b9c607de5] => 1 )
   6. $_FILES Array: Array ( )
   7. Form passed the plugins step (if enabled) OK
   8. Debug End

But when I ENABLE the email address - I get nothing. The page seems to go into the submission process - but the progress bar never advances and the process seems to stall until I close the window.

Should I wait for 4C2? Or am I facing an altogether different issue?

Thanks!

We have made progress but still need answers.

With email enabled - the page still cycles endlessly but DOES now send the email.

The page just does not redirect to the confirmation page listed in the redirect URL window.

Any help? Any thoughts?

Hi cb1,

What URL do you have in the ReDirect window?
[sendfb][/sendfb]
BobL

Hi cb1,

I got your email but couldn't check there yet because I was very busy with the new release, please try to upgrade to RC5 and tell me if the problem still exists!

Regards
Max

To update:

1 - Upgraded to RC5 this weekend.

2 - While it hasn't really improved the situation it has presented some new results.

3 - When I SUBMIT a form - the page attempts to reload.

4 - And attempts for approximately 1 minute (my last test was close to 60 seconds exactly)

5 - After this period of time - the page DOES NOT go to the confirmation page - but goes to a page that shows the email that was generate AND the debug information.

6 - However - I DO receive the email.

So the problems that are presenting are as follows:
1 - Inordinately LONG processing time from the time SUBMIT is pushed.
2 - Still NOT FORWARDING to the confirmation page.

This seems like we are really close. I am sending this thread to the client also to take a look.

New Result:

With Debug OFF - the site NOW proceeds to the Confirmation page.

The approx. 1 minute delay is STILL there.

What logs can be looked at to help track this down?

Mind if I ask which email settings you are using (phpmail, sendmail, or smtp)?
Also, does any other email services on that site work properly (user registration confirmation, etc)?

/Fredrik

PHP mail Function with SMTP turned OFF.

Just ran another test - WITH EMAIL TURNED OFF - And the page cycled normally and quickly.

However we need the email.

When turned ON - it cycles for almost 60 seconds exactly - I've done this a number of times now. And each times it is 60 seconds.

What about other email sources in your joomla installation? (such as user registration, etc) Do they suffer from the same delay?

Also, have you tried the other options, such as sendmail or SMTP mailer?

As I recall, all CF does is call the JUtility::sendMail() class-method after rendering the email content. Only reason for JUtility::sendMail() to halt execution would be if the MTA blocks. Other than that, there'd have to be an infinite loop within the email generation. However, since you did recieve the email, that would suggest the script made it all the way to sending the email.. once again suggesting the MTA...

Or do you have some custom onSubmit (after email) code in your form?

/Fredrik

I have tried setting it to SMTP Mail Server - but every time I "apply" or "save" - it reverts back to PHP Mail Function.

Thoughts?

Hi, I think this maybe a problem with your joomla install ? or the mail servers them selves ? try to check the Joomla forums for this issue!

Regards
Max

epilogue...

It took a friend 5 minutes with a script to narrow the problem down to missing code in the php.ini file. It was not queuing the emails properly.

So it was found and fixed within an hour a couple weeks ago. I've just been scrambling on other things - but wanted to get back and say thanks for taking the time to help - all those involved.

Thank you, if you can post the real fix you made in the ini file then this would be great, assuming it doesn't show any private data!

Cheers
Max