close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Problem with Insert New Form Wizard

Thread began 11/14/2018 11:57 am by administration282761 | Last modified 11/20/2018 4:24 pm by Ray Borduin | 229 views | 13 replies |

administration282761

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

Sign in to reply to this post

Ray BorduinWebAssist

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.

Sign in to reply to this post

administration282761

Dear Ray

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

Regards

Sign in to reply to this post

Ray BorduinWebAssist

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.

Sign in to reply to this post

administration282761

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.

Sign in to reply to this post

Ray BorduinWebAssist

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.

Sign in to reply to this post

administration282761

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.

Sign in to reply to this post

Ray BorduinWebAssist

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.

Sign in to reply to this post

administration282761

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.

Sign in to reply to this post

Ray BorduinWebAssist

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.

Sign in to reply to this post
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...