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.

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

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.

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 ?

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

Please can you advise any known issues

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.

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

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

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

This post has been deleted.