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

Create Email Message

Thread began 6/27/2022 2:58 am by john70964 | Last modified 7/05/2022 3:32 pm by Ray Borduin | 155 views | 25 replies |

john70964

Create Email Message

Hi Ray
I have a page in which I was inserting a Create Email Message extension.
Unfortunately we had a powwer cut and I am not sure if the extension was completed.
I have tried using the page on the web but it has not sent the email expected.
I wonder if you can see the Create Email Message page was completed.
File below.
Thanks
John

Sign in to reply to this post

Ray BorduinWebAssist

You are redirecting after the insert, so the email won't have a chance to send. You would need to remove the redirect from the insert server behavior in order for the email to work.

Sign in to reply to this post
Did this help? Tips are appreciated...

john70964

I removed "boat_insert_images_Free.php" from WebAssist MySQLi Insert Record.

When I generated the page this error was shown.

Parse error: syntax error, unexpected '' (T_ENCAPSED_AND_WHITESPACE), expecting identifier (T_STRING) or variable (T_VARIABLE) or number (T_NUM_STRING) in C:\xampp\htdocs\bfsnmysql57\BoatAdsFree\boats_Insert - Copy2.php on line 78

Image attached

Sign in to reply to this post

Ray BorduinWebAssist

I'd want to look at: boats_Insert - Copy2.php on line 78

Please attach that page.

Sign in to reply to this post
Did this help? Tips are appreciated...

john70964

Attached as required.
Thanks
John

Sign in to reply to this post

Ray BorduinWebAssist

A bunch of the bindings are in the wrong syntax. Most likely you did some hand edits and Dreamweaver didn't recognize them properly when you edited with the UI and it messed it up.

You can easily correct the issue in the code on lines 78,79,80,83 and 88

The lines have code like:
$InsertQuery->bindColumn("NeworUsed", "s", "\".($_POST['NeworUsed']) .\"", "WA_BLANK");

but it should be:
$InsertQuery->bindColumn("NeworUsed", "s", "".($_POST['NeworUsed']) ."", "WA_BLANK");

One important thing is to use a double space after the $_POST[] value before the double quotes. That is probably what was missing when you hand edited and that is maybe why it got mangled when you edited.

You can also go into the UI and re-set those values from the bindings tab to ensure proper syntax. That might be the better option to prevent any other minor typos.

Sign in to reply to this post
Did this help? Tips are appreciated...

john70964

Hi Ray,
I found one recordset had disappeared so I replaced that one, NeworUsed
I also remove the forward slashes as in
$InsertQuery->bindColumn("NeworUsed", "s", "".($_POST['NeworUsed']) ."", "WA_BLANK");

I could not see quite where there should be double a double space.
.($_POST['NeworUsed'])^^."",
Perhaps where the ^^ are as above?

Opening the recordsets in bindings did not seem to do any thing to the code, just showed results.
So I will wait for any comments before I proceed and will attach athe file.

Thanks for the help,
John

Sign in to reply to this post

Ray BorduinWebAssist

Yes. You have identified the double space location properly. You can also see the correct spacing on the other lines that weren't encoded improperly.

Sign in to reply to this post
Did this help? Tips are appreciated...

john70964

Hi Ray,
I tried the above text page on the remote server and receive this message'

Fatal error: require(): Failed opening required 'Welcome.php' (include_path='.:/usr/lib/php7.4') in /homepages/37/d415519235/htdocs/boatsforsalenow/webassist/email/WA_Email.php on line 314

Earlier I was trying to find the email I installed but could not see this, I could only see a new empty form "Create Email Message".I am attaching the files below.
I hope these are the correct files.
Thanks for your help

John

Sign in to reply to this post

Ray BorduinWebAssist

You have to upload the /webassist/emial folder... specifically this error means this file wasn't uploaded:
/webassist/email/templates/basic-welcome/Welcome.php

Sign in to reply to this post
Did this help? Tips are appreciated...
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...