Optional Related Products 3.3

[Guest]

I installed Optional Related Products 3.3 on to a clean osCommerce 2.2 Milestone 2 Update 060817

I am receiving this error........

 

1146 - Table 'justink_justink.TABLE_PRODUCTS_OPTIONS_PRODUCTS' doesn't exist

select pop_products_id_slave, products_name, products_price, products_tax_class_id, products_image from TABLE_PRODUCTS_OPTIONS_PRODUCTS, products_description pa, products pb WHERE pop_products_id_slave = pa.products_id and pa.products_id = pb.products_id and language_id = '1' and pop_products_id_master = '13' and products_status='1' order by pop_order_id, pop_id

 

I have looked in My database table and TABLE_PRODUCTS_OPTIONS_PRODUCTS is not there, but PRODUCTS_OPTIONS_PRODUCTS is.

 

web address is: justink.co.nz/product_info.php?cPath=3_10&products_id=13

 

Any help would be wonderful :)

[Duende1]

I installed Optional Related Products 3.3 on to a clean osCommerce 2.2 Milestone 2 Update 060817

I am receiving this error........

 

1146 - Table 'justink_justink.TABLE_PRODUCTS_OPTIONS_PRODUCTS' doesn't exist

select pop_products_id_slave, products_name, products_price, products_tax_class_id, products_image from TABLE_PRODUCTS_OPTIONS_PRODUCTS, products_description pa, products pb WHERE pop_products_id_slave = pa.products_id and pa.products_id = pb.products_id and language_id = '1' and pop_products_id_master = '13' and products_status='1' order by pop_order_id, pop_id

 

I have looked in My database table and TABLE_PRODUCTS_OPTIONS_PRODUCTS is not there, but PRODUCTS_OPTIONS_PRODUCTS is.

 

web address is: justink.co.nz/product_info.php?cPath=3_10&products_id=13

 

Any help would be wonderful :)

 

I could use this contribution and this is what I found there ... [the new contribution should be accepted shortly I assume]

 

This is just the current (and correct) related_product.sql file. The complete package, with screenshots, is in the system and waiting for approval.

 

In the meantime, if you want to install the latest iteration of version 3.3, replace the included sql file with this one, and you shouldn't have any trouble with the install.

 

This version of the contribution is being discussed on the forum at: http://www.oscommerce.com/forums/index.php?showtopic=217953.

Edited October 6, 2006 by Duende1