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

Stopped working

Thread began 7/27/2018 10:49 am by J7HNW | Last modified 9/11/2018 12:22 pm by anonymous | 225 views | 9 replies |

J7HNW

Stopped working

We have moved webservers today . All was fine on this site yesterday on the old server

weeride cart no longer working

We can add to cart - and then go to checkout page

http://www.weerideuk.co.uk/confirm.php

When submit the form we get Field 'OrderUserID' doesn't have a default value

I have attached the file - please can you advise ?

New server is running Plesk = on Windows 2016.

Attached Files
confirm.php
Sign in to reply to this post

J7HNW

Sorry also another strange issue

We have quote forms - which send out e mail quotes to our customers ( Using Universal e mail ) - and copy us in

Customers are getting them but since yesterday - we dont get a copy

What can be stopping the forms mailing to other accounts on the same server ?

<?php
$MailAttachments = "";
$MailBCC = "";
$MailCC = "";
$MailTo = "";
$MailBodyFormat = "";
$MailBody = "";
$MailImportance = "";
$MailFrom = "sales@interpak.ltd.uk";
$MailSubject = "Interpak E Quotation";
$_SERVER["QUERY_STRING"] = "";

//Global Variables

$WA_MailObject = WAUE_Definition("","25","Interpak Ltd","","","UTF-8");

if ($RecipientEmail) {
$WA_MailObject = WAUE_AddRecipient($WA_MailObject,$RecipientEmail);
}
else {
//To Entries
}

//Additional Headers

//Attachment Entries

//BCC Entries
$WA_MailObject = WAUE_AddBCC($WA_MailObject,"sales@interpak.ltd.uk");
$WA_MailObject = WAUE_AddBCC($WA_MailObject,"vicky@interpak.ltd.uk");
//CC Entries

Sign in to reply to this post

Ray BorduinWebAssist

It looks like this should work.

Are the email addresses working in general:
sales@interpak.ltd.uk and sales@interpak.ltd.uk

Maybe it is a spam blocker keeping you from viewing it.

Sign in to reply to this post

J7HNW

Hi Ray

Thanks for your assistance

Yes all e mail addresses work perfectly. We set the form to send to the customer - and to copy in sales@ and vicky@

All was working fine. Now it doesnt send to any address in CC or BCC if site is on our server

I have tested with BCC to my icloud address and it works.

Any ideas ?

Sign in to reply to this post

J7HNW

E Mail has stopped working on forms. Using version 5.6.37 php in the new Plesk

Please can you advise any known issues

Sign in to reply to this post

Ray BorduinWebAssist

This is an issue with the MySQL database when you moved servers the auto-number attribute didn't get set in the orders table for the OrderUserID column.

Most likely this issue exists on all of your tables if it is on this one, so you may need to re-import the database to the new site using the correct settings.

Sign in to reply to this post

J7HNW

Hi Ray

Please see attached - the OrderUserID has never been utilised by the looks of this table

Is there a workaround ? I have also attached the table structure where OrderID is the key column

John

Sign in to reply to this post

J7HNW

I have also attached the table structure where OrderID is the key column

Please can you give me a quick fix as the site has been down since Friday

Sign in to reply to this post

J7HNW

E MAIL

Hi Ray

Very odd - all forms on the new server work perfectly if they are sent to an e mail address hosted on our server - but the minute you try to send to an e mail address not hosted on our server - the forms don't send the mail through

Any ideas on this one. Clearly the mailing script is working as I can send forms to another of my accounts on same server and they work

Regards

John

Sign in to reply to this post

anonymous

This post has been deleted.

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