Forums

No data or emails sent - tried to find answer on forum

sitebuildernow 09 Aug, 2009
Hi there - My form was working fine for sending emails then I created a table for it and then nothing - the form looks good and passes the dbug I can fill it out and submit it but no emails and no data in table. Form is located at http://asnwonline.com/2009/index.php?option=com_chronocontact&chronoformname=request2
debug:
I can't post the html here because of character limit - let me know if you need it and/or I would be happy to pm you access to my admin.
Thanks,
Harmony
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 ( [rfname] => Harmony [rlname] => Coburn [rcompany] => Any Company [remail] => [email]harmony@sitebuildernow.net[/email] [dcname] => Suzy Q [onsitename] => Bob Smith [onsitephone] => 3607211017 [onsitestreet1] => 1122 E Wherever [onsitebldg] => 1 [onsiteroom] => 3 [onsitecity] => Vancouver [onsitestate] => WA [onsitezip] => 98685 [onsiteother] => [startdate] => 13/08/2009 [starttime] => 1:10A [endtime] => 1:25A [enddate] => 13/08/2009 [multidaydetails] => [purpose] => Attorney / Client [check0] => Array ( [0] => ASL/Sign Language [1] => Tactile (Deaf/Blind) ) [preferreds] => [bfirst] => Harmony [blast] => Coburn [bphone] => 3607211017 [bdepartment] => AP [bemail] => [email]harmony@sitebuildernow.net[/email] [baddress1] => 1122 W Somewhere [baddress2] => [bcity] => Vancouver [bstate] => WA [bzip] => 98685 [chrono_verification] => nt9K3 [button_60] => Submit [dd1c798a68c59b56d4813bed9d428d74] => 1 [1cf1] => c6f8259a90b0a419b45a43c40a87d9d3 [chronoformname] => request2 )
6. $_FILES Array: Array ( )
7. Form passed the plugins step (if enabled) OK
GreyHead 09 Aug, 2009
Hi sitebuildnow,

It looks as though emails aren't enabled - not sure about the database save though.

Bob
sitebuildernow 09 Aug, 2009
I've checked and double checked and emails are enabled in global as well as each email for the form (says enabled 2 next to the form on my list).

I did a test with just the basic demo form, creating and attaching to a db and all works well so it has to be something I've done to my code? (not that I've done much because I'm not a programmer and try to avoid that). Here is the autogenerated code:
<?php
$MyForm =& CFChronoForm::getInstance("request3");
if($MyForm->formparams("dbconnection") == "Yes"){
$user = JFactory::getUser();
$row =& JTable::getInstance("chronoforms_request3", "Table");
srand((double)microtime()*10000);
$inum = "I" . substr(base64_encode(md5(rand())), 0, 16).md5(uniqid(mt_rand(), true));
JRequest::setVar( "recordtime", JRequest::getVar( "recordtime", date("Y-m-d")." - ".date("H:i:s"), "post", "string", "" ));
JRequest::setVar( "ipaddress", JRequest::getVar( "ipaddress", $_SERVER["REMOTE_ADDR"], "post", "string", "" ));
JRequest::setVar( "uid", JRequest::getVar( "uid", $inum, "post", "string", "" ));
JRequest::setVar( "cf_user_id", JRequest::getVar( "cf_user_id", $user->id, "post", "int", "" ));
$post = JRequest::get( "post" , JREQUEST_ALLOWRAW );
if (!$row->bind( $post )) {
JError::raiseWarning(100, $row->getError());
}
if (!$row->store()) {
JError::raiseWarning(100, $row->getError());
}
$MyForm->tablerow["jos_chronoforms_request3"] = $row;
}
?>

Does that give any clues?
GreyHead 09 Aug, 2009
Hi sitebuildernow,

That all looks perfectly normal. If the form is on-line and it's OK with you please PM or Email me a SuperAdmin logon and I'll take a look.

Bob
sitebuildernow 10 Aug, 2009
Thanks - I sent the PM. Totally boggled at this point.
Harmony
nml375 10 Aug, 2009
Hi,
Think I saw a similar post maybe a week back; emails suddenly stopped being processed after upgrading to 5.5, yet the main page says emails are "good". I think they solved it by re-creating the form from scratch, but I'd have to search for the thread to double-check.

/Fredrik
sitebuildernow 10 Aug, 2009
Hi, already tried that - interestingly enough the basicDemo form works like a dream. My form contains alot more fields but, as of yet, I have not added any code directly to this newly created version.
sitebuildernow 10 Aug, 2009
Bob, thanks for finding that the confirm plugin was causing some of my issues. Now that it is disabled the emails are indeed working. I am sharing your other comments here for other newbies that may make my mistakes. I am also going to make a new post with my newest - question (not a technical issue with chronoforms but something I don't know how to deal with.
Thanks again for resolving the mail issue. Onto the database!
Harmony
*************from Bob*********************
A few little problems - the bigget one was the Confirmation Page plugin - that just doesn't seem to be working with the latest release of ChronoForms (or possibly it wasn't configured correctly). I've turned that off in the Plugins tab and the enails now send.

I made some changes to your email setup.

In the first one you had a non-Dynamic To with a field name in it, I've switched this to a Dynamic To.

In the second one you had Dynamic From & From Email, these can be troublesome so I've used Dynamic ReplyTo fields instead.
******************************
GreyHead 10 Aug, 2009
Hi Harmony,

I PM'd you - the main problem seems to be the Confirmation Page plugin -I turned it off and cleaned up a few other small things and the email seem to be sending now. At least the debug display looks correct.

Bob
sitebuildernow 12 Aug, 2009
Hi Bob, yes, I did get your PM and thank you very much - my follow up post here was simply for others to see in case they had simiar issues. However, I neglected to ask you when you think there will be a bug fix for the fact that the redirect plugin is not working? I have been trying several things but I keep landing on a page that shows both html emails after I submit the form - I did manage to set up a redirect but it only comes up after the page with the 2 emails has shown for a few minutes.

What I really want is a Thank you page with their unique request ID (which works GREAT! thanks to you and this thread: http://chronoengine.com/forums/index.php?option=com_chronoforums&cont=posts&f=7&t=7355&p=8065&hilit=include+unique+id+in+email#p8065).

Any help on the redirect problem would be greatly appreciated. What I want it to do is come back to a page like this:

Thank you! Your request Number {jobid} has been submitted. You should receive an email with the details of your request shortly. Please make sure to include [email]scheduling@asnwonline.com[/email] in your email approved senders lists.

If you do not receive an email within 1 hour please call 503 447 5000 to make sure we got your request.

Your ASNW Scheduling Team
GreyHead 12 Aug, 2009
Hi Harmony,

If you are seeing the two emails - then you almost certainly have Debug turned on for your form; turn it off on the General Tab (or possibly in the plugin configuration).

Debug should suppress the redirect - otherwise you can't see the debug results - until you click a link to continue. (I say 'should' because different versions of ChronoForms have it implemented in slightly different ways.)

As far as I am aware there is no problem with the ReDirect plugin itself???

Bob
sitebuildernow 12 Aug, 2009
Thanks - I was confusing the confirmation plugin with the redirect plugin. And, yes I had debug on... I'm learning :-).
Harmony
This topic is locked and no more replies can be posted.