Adding Attibutes resulting WARNING: An Error occurred, please refresh the page and tr

Hi,

If I add attributes to a product and want to access to the product detail page , I get 'WARNING: An Error occurred, please refresh the page and try again.' If I remove the attributes, I am able to see product details page. This error is only on the product details page.

I am unable to fine the problem. Can anyone please assist ?

Product it self has following:

Product Priced by Attributes: No
Product is Call for Price:No
Always Free Shipping:YES
Products Quantity Box Shows:NO
Product Qty Minimum: 1
Product Qty Maximum: 0
Product Qty Units: 1
Product Qty Min/Unit Mix: No
Products Quantity: 6

Log file says:
[28-Nov-2013 17:57:04 America/Chicago] PHP Fatal error: 1146:Table 'silkauro_zenc181.products_with_attributes_stock' doesn't exist :: SELECT pas.quantity
FROM products_with_attributes_stock pas
WHERE pas.products_id = '208'
AND pas.stock_attributes = '181' in /home/silkauro/public_html/includes/classes/db/mysql/query_factory.php on line 120

That error usually means a database issue of some kind. The log file error suggests that you may have installed a stock by attributes plugin without remembering to run the SQL patch that came with the mod.

stevesh:

That error usually means a database issue of some kind. The log file error suggests that you may have installed a stock by attributes plugin without remembering to run the SQL patch that came with the mod.

Or have deleted the table or have attempted to unistall, but did not do so completely. Just some other reasons why might have received that error.

Thanks guys , You are correct. I did installed 'stock by attributes plugin' and then uninstalled. So do anyone how to fix it? Should I re install stock by attributes plugin again then uninstall it? or is there an easier option ?

oavs:

Thanks guys , You are correct. I did installed 'stock by attributes plugin' and then uninstalled. So do anyone how to fix it? Should I re install stock by attributes plugin again then uninstall it? or is there an easier option ?

Depends, what do you want? To have stock by attributes installed or not?
If not, then you haven't fully uninstalled the software. Perhaps you have uninstalled the SQL, but there are file remnants (in particular part of a SQL statement). Basically recommend comparing a new install of SBA with a clean install of your ZC version, whatever is different basically needs to be changed back to the original.