Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

problems after installing ACA


Guest

Recommended Posts

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

Link to comment
Share on other sites

  • 11 months later...

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

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...