Magento

Please replace the files listed below with the attached ones

If you are familiar with patch shell command you can apply the patch.txt instead.

You can also uncompress the attached archive files.zip and copy its content to you Magento folder.

Thank you,
Michael.

Attribute.php  (File Size: 5KB - Downloads: 88)

AttributeController.php  (File Size: 10KB - Downloads: 71)

Indexer.php  (File Size: 16KB - Downloads: 73)

files.zip  (File Size: 9KB - Downloads: 101)

patch.txt  (File Size: 3KB - Downloads: 77)

Thanks for this. I applied these new files but I still seem to be getting the same error when adding or editing an attribute. Any idea?

I also tried placing these files in my folders on my grid server account and recieved the following error when trying to add an attribute

SQLSTATE[21000]: Cardinality violation: 1241 Operand should contain 1 column(s)

I also get the same error after adding an attribute - even with files replaced. Any updates on this?

Actually, let me change that - it doesn’t look like I get the error on adding attributes anymore. However, I am still having difficulty editing attributes. This edit behavior is the same as pre-patch, which is what led me to believe the patch didn’t work.

When I try to save after an edit, the page perma-loads for around 25 minutes, and then Firefox times out. The only two settings I attempted to change are:

Values Required: No --> Yes
Visible on Catalog Pages on Front-end: No --> Yes

Any thoughts on this?

When I save after an edit, could it be trying to update all of my 6,000 SKU’s, hence the timeout? None of the SKU’s make use of the attribute yet, however.

Applying these files only makes Magento think I need to upgrade - I can’t get into the admin or frontend anymore unless I do the upgrade process.

Some more information that may help finding a solution.
I don’t know when it started but in the beginning it was no problem at all to insert/modify attributes. After a while of entering data into the system the well known SQL error occurs when changing an attribute in the admin panel.

Since that the layered navigation in the frontend is also not working correctly anymore. It only shows the categories together with the quantiy, but it does not show any of the other attributes anymore (it worked before for sure!).

Right now even if I open an attribute (e.g. price) and click immediately on the save-button, the error
SQLSTATE[21000]: Cardinality violation: 1241 Operand should contain 1 column(s)
occures.

I tried to export the not-working database and import it to another installation where the attribute thing was working. Just changed the dbname in the local.xml file and tried the same thing as above and - voila - the same error occurs.

Therefore I think that the problem is bound to the database content somehow.

If one of the magento-developers want a dump of the database, feel free to contact me at .

Simply changing hosts away from MediaTemple solved this SQL issue (and the speed issue)

sccr410. can you please let us know the new ISP you moved to, I am on MediaTemple and having same issue. Thanks

I moved the site to HostGator and it has no speed issues at all

The solutions seems to get rid of the cardinality error, but attributes seem to have disappeared from shopping options.
Any ideas
Thank you

I am on media temple and I manually patched the listed files. The fix worked for me!