Bundled Products

[tec]

HI there, I am trying to install the Bundled Products

mod into a creloaded.

 

I had to add this to my 'products' TABLE in my DB

 

`yourdatabasenamehere`.`products` ADD `products_bundle` TINYTEXT NOT NULL

 

CREATE TABLE `products_bundles` (`bundle_id` SMALLINT NOT NULL, `subproduct_id` SMALLINT NOT NULL, `subproduct_qty` TINYINT NOT NULL , PRIMARY KEY (`bundle_id`, `subproduct_id`))

 

now i am getting this......

1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'p, products_description pd where p.products_id = '29' and p.pro

 

select pd.products_name, pd.products_description, pd.products_head_title_tag, pd.products_head_desc_tag, pd.products_head_keywords_tag, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_image_med, p.products_image_lrg, p.products_image_sm_1, p.products_image_xl_1, p.products_image_sm_2, p.products_image_xl_2, p.products_image_sm_3, p.products_image_xl_3, p.products_image_sm_4, p.products_image_xl_4, p.products_image_sm_5, p.products_image_xl_5, p.products_image_sm_6, p.products_image_xl_6, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.manufacturers_id, p.products_bundle fromproducts p, products_description pd where p.products_id = '29' and p.products_id = pd.products_id and pd.language_id = '1'

 

 

also, there is no place in the admin to attach individual products to a bundle

[tedmcdonald]

I am running it successfully on CRE 6.15. Didn't do anything special to set it up. Just followed the installation directions.

 

Best, Ted

Edited November 4, 2005 by tedmcdonald