smart Posted February 17, 2005 Share Posted February 17, 2005 I have installed X-Sell-v2-2 and get this error at admin 1146 - Table 'jewel.TABLE_PRODUCTS_XSELL' doesn't exist select p.products_id, p.products_model, pd.products_name, p.products_id, x.products_id, x.xsell_id, x.sort_order, x.ID from products p, products_description pd, TABLE_PRODUCTS_XSELL x where x.xsell_id = p.products_id and x.products_id = "32" and p.products_id = pd.products_id and pd.language_id = "1" order by x.sort_order asc When viewing the website you can see below product the -we recommend- I have not linked any products yet. Thankyou Link to comment Share on other sites More sharing options...
sashaben Posted February 18, 2005 Share Posted February 18, 2005 Have you run the database statement? DROP TABLE IF EXISTS products_xsell; CREATE TABLE products_xsell ( ID int(10) NOT NULL auto_increment, products_id int(10) unsigned NOT NULL default '1', xsell_id int(10) unsigned NOT NULL default '1', sort_order int(10) unsigned NOT NULL default '1', PRIMARY KEY (ID) ) TYPE=MyISAM; Link to comment Share on other sites More sharing options...
smart Posted February 18, 2005 Author Share Posted February 18, 2005 Yes I have RUN the data base statement. Have you run the database statement? any other ideas - thanks DROP TABLE IF EXISTS products_xsell; CREATE TABLE products_xsell ( ID int(10) NOT NULL auto_increment, products_id int(10) unsigned NOT NULL default '1', xsell_id int(10) unsigned NOT NULL default '1', sort_order int(10) unsigned NOT NULL default '1', PRIMARY KEY (ID) ) TYPE=MyISAM; <{POST_SNAPBACK}> Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.