Problem with Insert New Form Wizard

Hi

Although I have successfully used the DataBridge Email Form wizard previously with the Beta version, I am having some problems with the new version when creating a Simple Contact form:

1. In the Mail configuration settings for smtp after entering all of my server details, password, port, etc the generated code mixes up the fields i.e. the password is set to 1 and the Port is set to something like tls.
I can correct this by clicking on the server behaviour and re-entering the required info which then generates correctly.

2.After removing the security question, I installed the page on the server and it sends me the email, but if I input the wrong captcha I don't get the expected pop-up warning notice and the page redirects to the front page of site.

As I have this working perfectly on another website, I am wondering if there is a bug somewhere.

Thanks
PS I will send a link to the contact page with PM

Can I get FTP access to the site? I'll have to take a look at #2.

#1 definitely appears to be a bug. I've logged it and I'll get it fixed.

Dear Ray

Thanks for taking a look. The FTP details are in the PM.

Regards

It seems to have created the failed redirect url in the Server Validations server behaviors incorrectly. I think this was an issue that I fixed in an earlier build. I've manually corrected it on your page for now, but try reinstalling the latest version of the extension and I don't think it would happen anymore.

Dear Ray

Many thanks.

As you suggested, I downloaded and installed the newest DB build 2.33 - (which BTW installed with Project 7 extension manager!)

Then on a fresh new website I generated a new Contact Form - removed the Security Question and it worked successfully.
The bug that mixes up the e-mail configuration is still there but it is easily fixed by accessing the Server Behavior again.
That was good.

Then I tried to generate a new Contact Form on a new page where the e-mail address is dynamically generated i.e the e-mail "To." address comes from a database such as:

$Email->addTo("".($rsMarket->getColumnVal("email")) ."");

But, unfortunately this did not work and no e-mail was sent.

To test the form, I changed this to a static address:

$Email->addTo("email@domainname.com");

And this worked. So I know the form was working and the smtp configuration was in order.

After much testing, I decided to generate the CC e-mail function from the database.
$Email->addCC("".($rsMarket->getColumnVal("email")) ."");

and, using a static "To" e-mail address, this worked which shows that getting an e-mail from the database does indeed function.
But changing the "CC" to " To" in the same dynamic string did not solve the problem.

Also this did not work either:

$Email->addTo("".($rsMarket->getColumnVal("email")) ."");
$Email->addCC("".($rsMarket->getColumnVal("email")) ."");


Any ideas?

Thanks again for your time.

Site info in PM.

The rsMarket recordset requires a url parameter: class_ad_id in order to return a result. Which one were you using in your testing? I'll try to reproduce the problem, but it will need that parameter to work if you were testing without it. Your code looks correct as long as the recordset is returning an email address it should work. My guess is that the problem is with the recordset.

Dear Ray

Here is the recordset on the page with the contact form:

<?php
$rsMarket = new WA_MySQLi_RS("rsMarket",$mysqli2,1);
$rsMarket->setQuery("SELECT * FROM class_ad WHERE class_ad_id = ?");
$rsMarket->bindParam("i", "".(isset($_GET['class_ad_id'])?$_GET['class_ad_id']:"") ."", "-1"); //colname
$rsMarket->execute();?>


Here are a few examples from the previous page which deliver the class_id that you can test with, also see my PM:

class_ad_id=28
or
class_ad_id=19

as mentioned in my previous message,
the e-mail address was successfully inserted into the CC function, thus I think the recordset was working properly.

See PM for more precise details.

Thanks again.

It looks like you have the email coming FROM the entered email address in the form. SMTP authenticated emails often won't send emails FROM an unrecognized email address. Instead set the FROM address to a valid email address from the server and use the REPLY TO field to set the reply address to the email from the form so that it can be replied to but still delivered properly.

Dear Ray

It doesn't seem to me that FROM is the problem. I have an identical Contact Form on another similar site and I installed a recordset with one e-mail address, then configured the form's mail functions to insert the email address from the database and successfully sent the mail using smtp from there. The FROM address inputted via the contact form was a Gmail account.

On the new site, when I use a static TO email address in the configuration, it sends the mail but it doesn't send the mail when the address come from the recordset although it redirects to the Thank You page.

The contact form needs to be installed in two areas on my new site where my users info appears. Here the recordsets are a bit more complicated and this may indeed be the problem. Actually this works on the old site I am renovating but using the older WA Globals and co.

Question: What are the advantages of using SMTP over Sendmail - and would that make this easier?

It looks like I will need a Premier Support ticket to get this solved.

Thanks.

I've gone back to test your page, but when I make changes to the pages they don't seem to be reflected on the site? I'll need a test page to debug. Maybe my ftp access is to another directory or server?

The email doesn't know if you typed in the FROM address or if it came from the database... so that can't be the issue. The issue has to be something else. I'll have to debug more, but the page appears to be gone for me to test.