Forums / Setting Up Categories, Products, Attributes / Funny Attribute Error Showing up.....

Funny Attribute Error Showing up.....

Locked

Views: 915

Results 1 to 4 of 4
This thread is locked. New replies are disabled.
27 Jul 2009, 5:17 PM
#1
canvas101 avatar

canvas101

New Zenner

Join Date:
Apr 2007
Posts:
41
Plugin Contributions:
0

Funny Attribute Error Showing up.....

Hi Guys,

Ive recently setup my first zen store and have been using zen for a number of years.....

Ive manage to get everything done fairly how i want to and things look great....

I started adding product categories to my store and then actual products which worked fine.....as soon as I started adding attributes and testing attributes I was faced with the following error,

1146 Table 'bowwowC_artsupplies.TABLE_PRODUCT_ATTR_COMBS' doesn't exist
in:
[ SELECT pac.option_name_id, pac.option_value_id FROM TABLE_PRODUCT_ATTR_COMBS pac WHERE pac.product_id = '10' ORDER BY pac.option_name_id;]

Please see the following link to view error;

http://colour-banners.com/index.php?main_page=product_info&cPath=2&products_id=10

Has anyone got any idea why his is happening....?? If i add a produc with no attribute it works fine....

27 Jul 2009, 5:45 PM
#2
bunyip avatar

bunyip

Totally Zenned

Join Date:
Sep 2004
Location:
Western Massachusetts
Posts:
2,361
Plugin Contributions:
1

Re: Funny Attribute Error Showing up.....

You've obviously got an add-on module that does something with attributes...but it hasn't been installed correctly

Neville
An assumption is what you arrive at when you get tired of thinking...

27 Jul 2009, 6:34 PM
#3
canvas101 avatar

canvas101

New Zenner

Join Date:
Apr 2007
Posts:
41
Plugin Contributions:
0

Re: Funny Attribute Error Showing up.....

This is a totally standard zen install......I havent added any attribute modules....only modules running on the site are sagepay protx and the advance shipper module by ceon.....everything else is totally standard

Anyone else got any ideas.....what does the error mean

27 Jul 2009, 10:16 PM
#4
bunyip avatar

bunyip

Totally Zenned

Join Date:
Sep 2004
Location:
Western Massachusetts
Posts:
2,361
Plugin Contributions:
1

Re: Funny Attribute Error Showing up.....

From Admin > Tools > Developers Tool Kit, enter TABLE_PRODUCT_ATTR_COMBS in the bottom left box, select All Files - Catalog in the dropdown to the right of it, and then click the bottom right Search button. That should tell you what file contains the code that is looking for that table. My guess is that you will probably find that the file is includes/modules/attributes.php or includes/modules/pure_blue/attributes.php

If it's the first one, simply replace it with the same file from your original installation package. If it's the second one, delete it from your server.

Neville
An assumption is what you arrive at when you get tired of thinking...