[ShishaPipeUK]

What errors ?

Here is the code in my daily CRON mysql backup:

 
--
-- Table structure for table `xcart_email_for_changed_products`
--
DROP TABLE IF EXISTS xcart_email_for_changed_products;
CREATE TABLE xcart_email_for_changed_products (
productid int(11) NOT NULL default '0',
email varchar(128) NOT NULL default '',
descr text NOT NULL,
fulldescr text NOT NULL,
price decimal(12,2) NOT NULL default '0.00',
avail int(11) NOT NULL default '0',
PRIMARY KEY (productid,email)
) TYPE=MyISAM;
--
-- Dumping data for table `xcart_email_for_changed_products`
--
INSERT INTO xcart_email_for_changed_products VALUES (16582,'paul@shishapipe.net','Dubai Tobacco molasses is made in United Arab Emirates, package in a 115 mm square, 75mm depth box with a plastic 250 gram container inside. Dubai Tobacco uses the best quality essences and has a real flavor and is being produced with more than ten different flavors. \r\n\r\n','Dubai Tobacco molasses is made in United Arab Emirates, package in a 115 mm square, 75mm depth box with a plastic 250 gram container inside. Dubai Tobacco uses the best quality essences and has a real flavor and is being produced with more than ten different flavors. ',"25.00",0);

Just add this into your mysql patch in admin area:

 
DROP TABLE IF EXISTS xcart_email_for_changed_products;
CREATE TABLE xcart_email_for_changed_products (
productid int(11) NOT NULL default '0',
email varchar(128) NOT NULL default '',
descr text NOT NULL,
fulldescr text NOT NULL,
price decimal(12,2) NOT NULL default '0.00',
avail int(11) NOT NULL default '0',
PRIMARY KEY (productid,email)
) TYPE=MyISAM;