Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

X-Sell error TABLE_PRODUCTS_XSELL' doesn't exist


smart

Recommended Posts

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

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

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;

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...