close ad
Help us test the new Databridge BETA with MySQLi support
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Email code not working.

Thread began 10/25/2012 3:10 am by enquiry272230 | Last modified 10/26/2012 11:12 am by Jason Byrnes | 479 views | 3 replies |

enquiry272230

Email code not working.

I am using DM CS6 on Mac and Data Bridge 1.0.9

I am updating an existing website created with previous Webassist extensions.

I have used Universal email in the past on previous versions

Am having a major problem with a simple email setup to email an order to the client.

I have set up a template in the cart folder to use for the Create Email extension.

On checkout, I have a new page (checkout - pay by bank deposit) selected from the "Confirm" page to enable the customer to simply send the order through by email. (Payment will be by bank transfer separately.)

The "Confirm" page has already written the order to the database, so the following page (checkout - pay by bank deposit) sources the order information from the database.
(unusual I know, but client likes this step as the customer information is stored prior to payment)

I have set up Create Email (Universal Email) on this page checkout - "pay by bank deposit" - page link is "checkoutBtf.php".
The page works fine on load, all data is there, but as above, sourced from the database rather than the previous pages "eCart" sessions.

When adding "Create Email (Universal Email)" behaviour to this page, as a template I used the page "BtfPrint_UE_Template.php" that I created for this purpose.

This page tests OK when tested separately on the server.

The email behaviour writes a new folder "webassist" to the site with the webassist email PHP pages and a copy of the email template (cart_2.php) which must be the one used derive the email content.

After upload to the server, the attempt to send the order by email results in a blank page and the following error in the log file in "webassist/email/templates".

[25-Oct-2012 15:28:40] PHP Warning: require_once(../Connections/CatalogConn.php) [<a href='plugins/function.require-once'>function.require-once</a>]: failed to open stream: No such file or directory in /home/eggdec/public_html/webassist/email/templates/cart_2.php on line 1
[25-Oct-2012 15:28:40] PHP Fatal error: require_once() [<a href='plugins/function.require'>function.require</a>]: Failed opening required '../Connections/CatalogConn.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/eggdec/public_html/webassist/email/templates/cart_2.php on line 1

The cart_2.php page incorrectly references the database connection file, the create email behaviour did not extend the link, so had to add ../../ to the existing <?php require_once('../Connections/CatalogConn.php'); ?>

After adding this correction, I tested the webassist/email/templates/cart_2.php page by linking directly from the browser, and the page works fine, displays the order and the customer details.

However, when trying again to send the order, a blank page results and the above error has disappeared, but a new error appears in the log:

[25-Oct-2012 15:50:28] PHP Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /home/eggdec/public_html/webassist/email/templates/cart_2.php on line 41
[25-Oct-2012 15:50:29] PHP Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/eggdec/public_html/webassist/email/templates/cart_2.php on line 43

To Sum up, the Webassist Email code does not appear to read the recordset correctly for some reason.

Perhaps there is another link error I am missing.

I have attached the relevant pages.
So far a 30 minute job as become a six hour trial and I am at a loss.

I hope I have explained my problem clearly enough.

Incidentally, I see one of the webassist email scripts references the file database_management/wa_appbuider_php.php

This folder and file is not present in the webassist folder.

Attached Files
part website.zip
Sign in to reply to this post

Jason ByrnesWebAssist

I have created a support ticket so we can look into this issue further.

To view and edit your support ticket, please log into your support history:
supporthistory.php

If anyone else is experiencing this same issue, please append to this thread.

Sign in to reply to this post

enquiry272230

My problem solved!

There is obviously a problem with "Create Email" in Data Bridge 1.0.9 when creating an email from a working template file sourced from the database.

I have solved my problem by going back to Dreamweaver CS5.5 which luckily still had Universal Email 4 installed.

Within 10 minutes I had it all working correctly.

So you have some work to do on Data Bridge 1.0.9 > Create Email Message!!!!

Sign in to reply to this post

Jason ByrnesWebAssist

I have logged a bug in our system so it can be corrected in a future update.

Sign in to reply to this post

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