Background:
Hi, have been running a stable version of dashCommerce 3.0.1.33775 for around a year now, yesterday moved hosting provider from one shared hosting environment to a new provider (also shared) and therefore new servers. 1) zipped site files and unzipped onto new host no problem 2) scripted database in SSMS and transferred data using DTSWizard no problem.
Problem:
I've run the site and all appeared to be working until I tried to add a product to the shopping cart. I can't add products to the cart and get the following error in a pop-up window.
Cannot insert the value NULL into column 'OrderID', table
'streetcocathysql7.dbo.dashCommerce_Store_Order'; column does not allow nulls.
INSERT fails.
Does any one have any idea what might be causing this and how I can resolve it? Nothing has been changed just moved the site and database to a new server. The only thing that was done prior to the move was running an sql script to delete the rows in the 'core_log' and 'store_browsing_log' tables as they were around 160,000 rows in total!!
I'm a designer not a programmer so if any technical tweaking is needed would need clear instructions :) Have Visual Web Developer 2008, SQL Server Management Studio 2005 and web-ready (compiled) code for the site - version 3.0.1.33775
Any help would appreciated lost my whole weekend trying to figure this out and now at a complete loss as the original site is working fine!
Many thanks