problems after installing ACA

[Guest]

i am a newbie so sorry if this is a newbie problem.

 

After I installed ACA and the Mod packs I am getting a few errors.

All from admin:

 

When I get to my product listings, before each products is listed:

 

1054 - Unknown column 'products_cost' in 'field list'

 

SELECT products_cost FROM products WHERE products_id = '31'

 

[TEP STOP]

 

Then when I try to edit a product i get:

 

1054 - Unknown column 'products_bundle' in 'field list'

 

select products_bundle from products where products_id = '31'

 

[TEP STOP]

 

Also when I go into ACA for Products I get this at the top:

 

Warning: main(includes/functions/categories_description.php) [function.main]: failed to open stream: No such file or directory in /home/wwwbuyt/public_html/admin/includes/modules/categories/category_description.php on line 14

 

Warning: main() [function.include]: Failed opening 'includes/functions/categories_description.php' for inclusion (include_path='.:/usr/lib/php') in /home/wwwbuyt/public_html/admin/includes/modules/categories/category_description.php on line 14

 

 

I appreciate your help... In Advance....

 

Milo

[Guest]

Any help would be apreciated.... :D

[Guest]

If you've used the bundled products add on then you'll need to change the table structure. run the following sql on your database (via phpMyAdmin or whatever you use).

ALTER TABLE `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`));