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

Data Bridge Beta V2

Thread began 8/01/2018 5:18 pm by JBWebWorks | Last modified 8/03/2018 7:17 pm by Ray Borduin | 325 views | 18 replies |

JBWebWorks

Data Bridge Beta V2

Just downloaded the Data Bridge Beta V2 and the data assist pages work fine. Recordset and connection works fine.
I am having a problem with Send Email (used to be Create an email) In the other version, when it gets to mail body, you could not use a file and edit directly in DW. In the new version, you must use a file template and that doesn't work for me. Not sure what I am doing wrong. It gets to the success redirect but no email is delivered.
On firefox I get this error message:
Warning: require(webassist/email/templates/basic-simple/Basic_2.php) [function.require]: failed to open stream: No such file or directory in /home/bigchick/public_html/webassist/email/WA_Email.php on line 263

Warning: require(webassist/email/templates/basic-simple/Basic_2.php) [function.require]: failed to open stream: No such file or directory in /home/bigchick/public_html/webassist/email/WA_Email.php on line 263

Fatal error: require() [function.require]: Failed opening required 'webassist/email/templates/basic-simple/Basic_2.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/bigchick/public_html/webassist/email/WA_Email.php on line 263

Here is my code on the Send Email page

<?php 
error_reporting(E_ALL);
ini_set('display_errors',on);
?>
<?php require_once('webassist/mysqli/authentication.php'); ?>
<?php require_once('webassist/mysqli/rsobj.php'); ?>
<?php
if ("" == "") {
$RestrictAccess = new WA_MySQLi_Auth();
$RestrictAccess->Action = "restrict";
$RestrictAccess->Name = "authenticate";
$RestricAccessRedirect = "admin_login.php";
if (function_exists("rel2abs")) $RestricAccessRedirect = $RestricAccessRedirect?rel2abs($RestricAccessRedirect,dirname(__FILE__)):"";
$RestrictAccess->FailRedirect = $RestricAccessRedirect;
$RestrictAccess->execute();
}?>
<?php require_once('Connections/connmysqli.php'); ?>
<?php
$rs_kshoc = new WA_MySQLi_RS("rs_kshoc",$connmysqli,1);
$rs_kshoc->setQuery("SELECT * FROM ksforum_users");
$rs_kshoc->execute();
?>
<?php require_once("webassist/email/WA_Email.php"); ?>
<?php
if (($_SERVER["REQUEST_METHOD"] == "POST") && (isset($_SERVER["HTTP_REFERER"]) && strpos(urldecode($_SERVER["HTTP_REFERER"]), urldecode($_SERVER["SERVER_NAME"].$_SERVER["PHP_SELF"])) > 0) && isset($_POST)) { //WA Universal Email
$Email = new WA_Email("emailgroup_2");
$Email->Redirect = "?success=true";
$Email->From = "KSHOC <kshoc@jbwebworks.com>";
$Email->ReplyTo = "".((isset($_POST["from1"]))?$_POST["from1"]:"") ."";
$Email->ReturnPath = "jb@jbwebworks.com";
$Email->BurstSize = "200";
$Email->BurstTime = "1";
$Email->WaitTime = "1";
$Email->addToFromRS("rs_kshoc","user_email");
$Email->addAttachment("".((isset($_FILES["attach"]))?$_FILES["attach"]["name"]:"") ."");
$Email->BodyFile = "webassist/email/templates/basic-simple/Basic_2.php";
if (function_exists("rel2abs") && $Email->Redirect) $Email->Redirect = $Email->Redirect?rel2abs($Email->Redirect,dirname(__FILE__)):"";
for ($emailGroup=0; $emailGroup<sizeof($Email->To); $emailGroup++) {
$Email->Subject = "".((isset($_POST["subject1"]))?$_POST["subject1"]:"") ."";
$Email->send($emailGroup);
}
$Email->close();
}
?>
Sign in to reply to this post

Ray BorduinWebAssist

The code looks ok. Try changing the trigger for the email to use the button press instead of current form submit trigger.

The attachment code looks wrong. It is just referencing the name of the attachment and not the location where it is saved. That could be an issue as well.

Sign in to reply to this post

JBWebWorks

Ray,
I changed the trigger with no results. It goes to the success page but no emails are being sent. This is a form sending to a Fraternity group and there are 179 email addresses. It goes to the success page in seconds instead of 179 seconds. I have used this with an older version of UE and it works there. Not sure how to use the email template to get the subject and message from the form to send as the email body. When I downloaded Databridge Beta V2, I guess I received the newer version of UE. I must be doing something wrong setting up the Send Email.

Sign in to reply to this post

JBWebWorks

I received this error which may be the problem.
Fatal error: require() [function.require]: Failed opening required '/webassist/email/templates/WebAssist-Block/Block.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/bigchick/public_html/webassist/email/WA_Email.php on line 263

Sign in to reply to this post

Ray BorduinWebAssist

Yes, you will need to upload that file.

Sign in to reply to this post

JBWebWorks

Upload to the server? Yes, I had manually done that.
http://www.jbwebworks.com/webassist/email/templates/WebAssist-Block/Block.php

Sign in to reply to this post

JBWebWorks

This post has been deleted.

Ray BorduinWebAssist

It shouldn't give that error if the file was uploaded. Are you still getting the same error. If you give me FTP access and steps to reproduce I can debug it for you and let you know what is wrong.

Sign in to reply to this post

JBWebWorks

FTP info in PM
I am not getting the error but the template page was always uploaded.
It is not sending emails but it is going to the successful redirect? There are 154 emails in the recordset that should be sending.
I remember in the older versions of UE, you had to put in your mail server and port. I didn't see anywhere to do that on this version?

Sign in to reply to this post

Ray BorduinWebAssist

I think the only issue is that the recordset was only returning one result. I updated line 7 from:

$kshoc = new WA_MySQLi_RS("kshoc",$connmysqli,1);


to:

$kshoc = new WA_MySQLi_RS("kshoc",$connmysqli,0);



That should make it return all results instead of just the first row.

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...