Okay, installing this contrib on a OSC that already has products in it. followed the instructions and double checked (good instructions I might add) but I am getting some errors.
Firstly let me point out that I have not configured the CP account details yet, but I don't think that is causing the problem. I have also installed the Ultra Pics contrib and I believe that is where the problems are coming from.
So now lets look at the errors:
1) Front End - > shopping_cart.php (Immediately after clicking add to cart). Under the product list box I get the following error:
Sub-Total: 1054 - Unknown column 'p.products_length' in 'field list'
select p.products_id, pd.products_name, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_length, p.products_width, p.products_height, p.products_ready_to_ship, p.products_tax_class_id from products p, products_description pd where p.products_id = '110' and pd.products_id = p.products_id and pd.language_id = '0'
[TEP STOP]
2)Back End -> Adding Product > Preview Product > Insert. (All part of the admin/categories.php page) When inserting a new product the additional fields appear in the for the CP tariffs, length, weight. But after previewing it and pressing Insert it produces this error:
1054 - Unknown column 'products_length' in 'field list'
insert into products (products_quantity, products_description_short, products_tariff, products_model, products_price, products_date_available, products_weight, products_length, products_height, products_width, products_ready_to_ship, products_status, products_tax_class_id, manufacturers_id, products_image, products_image_med, products_image_sm_1, products_image_xl_1, products_image_sm_2, products_image_xl_2, products_date_added) values ('100', 'CanPost MOD', 'NONE', '', '3', null, '2.5', '6', '1', '5', '1', '1', '1', '0', '120_bv_M.jpg', '120_bv_M.jpg', '121_bv_M.jpg', '121_bv_M.jpg', '121_fv_M.jpg', '121_fv_M.jpg', now())
[TEP STOP]
3)Back End - > Editing a product (Again admin/categories.php). You receive this error:
1054 - Unknown column 'p.products_length' in 'field list'
select pd.products_name, pd.products_description, p.products_description_short, p.products_tariff , 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_length, p.products_width, p.products_height, p.products_ready_to_ship, 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 from products p, products_description pd where p.products_id = '154' and p.products_id = pd.products_id and pd.language_id = '1'
[TEP STOP]
Now I have two guesses at what the problem could be. All of these segments of code, which were amended from the UltraPic contrib already, are not as they should be. What I did is I compared the code from the instructions with the modified code of UltraPic From what I gathered is that UltraPic interjected a bunch of things between p.products_image and p.products_price. So I interject the weight, length, width, height and ready to ship between the p.products_price and p.products_date_added - effectively keeping things the same (or so I assumed).
the other guess is that the p.products_length was not set up in the database correctly. Though I have very limited experience with this, so I am not even sure how to check/debug this.
I hope that provides sufficient info for someone to help me out.
thanks
Rob