HEADER

H I there

A couple of problems with ChronoEngine on a Joomla 1.5.2 install on contact form from my site at simonshah.co.uk

I have created the form, customized the look, used validation and created the page redirect but have problems with email not working and data not populating the table.

Looking through the FAQ and forums, I did the following:

EMAIL
Tested email works fine from the site by placing a mailto HTML tag to test and that worked ok (now removed the mailto tag as I only used it for testing)

Tried to complete a form fill with Debug On and Verification Off but couldn’t see any debug messages for the email.

Check my own spam box but nothing came in there

FORM
Used phpmyadmin to delete the existing table jos_chronoforms1 and I deleted the code from the autogenerated tab and recreated the table within Chr0onoforms
Retested the form but still no data population into the table at the back end

Settings on man page of chronoengine are as follows:

Form name: contact_form
Email results? Yes
Email Address: I have put a correct email address here
Email Subject: Contact Form Submission
Form method: Post
Record and Send Users IP: Yes
From Email: I have out a correct email address here
From Name: Simon Shah
IN which format to send the results: Field titles
Debug: on
MYSQL Statement; ENGINE
Enable Mambots: No






Regards

Hi simonshah,

Please remove the Redirect URL temporarily to see the DeBug info.

Thanks

Bob

Got the debug to work now by turning off the redirect and this is the message:

_POST: Array ( [firstname] => Simon [lastname] => Shah [email] => email address [comments] => hello world )
Case 2: Use template
E-mail: 'Yes' custom
Email sent
E-mail message
From: Simon Shah [email address]
To: email address
Subject: Contact Form Submission - Simon Web

Submitted by 89.243.228.75

Reading this information, it all looks correct to me, so unsure next steps..

Hi simonshah,

As you say that all looks fine. The 'Email sent' message says that Joomla sent the message off to whatever mailserver you have configured for your site - so the mail problem is somewhere after that. You have the same email in 'to' and 'from' so quite possibly it got dropped in a spam filter somewhere. Try using two different emails here.

It also looks as though there is no body to your email. Do you have anything in the 'Email template' box on the Form HTML tab?

I can't tell anything about the database save from this - what code is in the Autogenerated code tab for this form?

Bob

Hi Greyhead

Taking your suggests

EMAIL:

I reverted to 'Fields Titles' to format the send email as I didnt actually have a template made up, thinking that might be the problem.

I then used the form to send to my gmail account and received tis debug message:

PHPMAILER_EXECUTE/usr/sbin/sendmail
_POST: Array ( [firstname] => simon [lastname] => shah [email] => email address[comments] => test )
Case 1: Use table layout
E-mail: 'Yes' custom
Email sent
E-mail message
From: Simon Shah [email address]
To: email address
Subject: Contact Form Submission - Simon Web

firstname simon
lastname shah
email email address
comments test

But the email was not received at my gmail account either. I also checked the spam box too

Then I played around with Joomla mail settings, switching and testing between phpmail and sendmail but neither seemed to rectify the problem. Remember that I tested the mail functionality earlier using the mailto command and the email worked (using phpmail setting in Joomla)

The form is up at http://simonshah.co.uk/index.php/component/option,com_chronocontact/Itemid,49/


DATABASE TABLE:
Here is the code in the autogenerated tab:

<?php
$database =& JFactory::getDBO();
srand((double)microtime()*10000);
$inum = "I" . substr(base64_encode(md5(rand())), 0, 16);

$database->setQuery( "INSERT INTO #__chronoforms_1 VALUES (
'' , '".$inum."','". date('Y-m-d')." - ".date("H:i:s")."', '".$_SERVER['REMOTE_ADDR']."' , '".JRequest::getVar('firstname','', 'post', 'string', '' )."' , '".JRequest::getVar('lastname','', 'post', 'string', '' )."' , '".JRequest::getVar('email','', 'post', 'string', '' )."' , '".JRequest::getVar('comments','', 'post', 'string', '' )."');" );
if (!$database->query()) {
echo "<script> alert('".$database->getErrorMsg()."'); window.history.go(-1); </script>
";
}
?>


Many thanks for your advice

Simon

Hi Simon,

The "PHPMAILER_EXECUTE/usr/sbin/sendmail" message isn't from ChronoForms it's a site message about a problem with the PHP Mailer . . . It translates into "PHP could not execute /usr/sbin/sendmail"

The database code looks OK _ it may be that the mailer problem is interrupting the code before it gets to that stage.

Bob