Oh, my bad. I think I created the tables manually rather than ecart creating them. SQL of the both of them below:
CREATE TABLE `shop_order_summary` (
`orderid` int(11) NOT NULL auto_increment,
`ofderreferenceid` int(11) default NULL,
`orderuserid` int(11) default NULL,
`ordershipping` varchar(24) default NULL,
`ordertax` varchar(24) default NULL,
`ordersubtotal` varchar(24) default NULL,
`ordertotal` varchar(24) default NULL,
`orderdate` date default NULL,
`orderstatus` varchar(80) default NULL,
`billingname` varchar(250) default NULL,
`billingaddress` varchar(250) default NULL,
`billingphone` varchar(40) default NULL,
`billingemail` varchar(250) default NULL,
`shippingname` varchar(250) default NULL,
`shippingaddress` varchar(250) default NULL,
`shippingphone` varchar(40) default NULL,
`shippingemail` varchar(250) default NULL,
PRIMARY KEY (`orderid`)
)
CREATE TABLE `shop_order_details` (
`orderdetailsid` int(12) NOT NULL auto_increment,
`orderid` int(12) NOT NULL default '0',
`productid` int(12) NOT NULL default '0',
`productname` varchar(250) NOT NULL default '',
`productdescription` varchar(250) default NULL,
`quantity` int(4) NOT NULL default '0',
`price` varchar(24) NOT NULL default '0.00',
PRIMARY KEY (`orderdetailsid`)
)
I'm running some tests to see if changing some of the field types fixes my problem
Bruce