I created an Attribute called “Materials” that is a drop down list featuring the materials available when creating a product. When I try to add a new material, I receive the following error:
SQLSTATE[21000]: Cardinality violation: 1241 Operand should contain 1 column(s)
Hosting Setup:
MediaTemple Grid Server
PHP 5.2.5
MySQL 4.1.11
Odd thing indeed...I just created a similar type of attribute and received the same error. Mine went away by deleting /var/cache. From reading in other threads it seems that this can happen. Don’t know if you have cache enabled. I didn’t and this still did the trick.
I just cleared & disabled my cache (through Admin, not by deleting directory /var/cache), logged out of my Admin (did not close my browser), and I still can not update Attributes or Polls (Polls Problem I am having)
UPDATE: Just tried disabled cache in the Admin, removing var/cache and var/session completely, logged out of browser and I’m still getting the the same error.
Anybody else able to update the attributes?
ON THE POSITIVE NOTE, with the cache disabled, the entire Admin section seems MUCH snappier.
