-
Categories
-
- 09 visitor(s) online
- powered by WassUp
Last searched terms
Online Visitors
-
Recently Written
- Memory-foam Matresses – Not the Way Forward…
- Busyness Over the Last Few Weeks
- Get a FREE Review of Your Magento Website – By Us!
- PHP Objects, Patterns, & Practice 2nd Edition
- Pro Drupal Development 2nd Edition
- Php|architect’s Guide to Programming with Zend Framework
- Magento 1.3 Theme Design
- Php|architect’s Guide to Programming with Zend Framework
- Flowerbed Wildlife Magento Lined Journal
- The Definitive Guide to Magento
-
Admin
-
Stay Informed...
The “SQLSTATE[23000]: Integrity Constraint Violation” Error
 Add to Favourites
|   (No Ratings Yet) Loading ... |
Numerous people have been emailed in to me over the past week as they have been discovering an error when trying to Manage their Stores in the Magento Admin system. We’ve also been told that the error also appeared for one user on the front end, moments after they added products and moved some images via FTP.
The full error shows the text:
1 | SQLSTATE[23000]: Integrity constraint violation: 1052 Column ‘name’ in where clause is ambiguous |
This error is usually caused by one of your plugins which is causing a conflict with the Magento installation. In this situation you are advised to disable each plugin one by one, and see when the error disappears. Unfortunately, in Magento’s early stage, a lot of plugins seem to manage to being out the bugs in the software – and it is more than likely that it is one of these which is doing the damage.
about the author
This article was written by Sam Davis on January 7, 2009.
Computing over a glass of Grenache Shiraz... again! Sam is the Editor of Blasted Thing. Contact Us |
related articles
comments
One Response to “The “SQLSTATE[23000]: Integrity Constraint Violation” Error”
Leave a Reply
 Can’t Load Magento Page – The Error Report Feature |
-
Sponsored Ads
- vtiger: great article, thank you....
-
Recent Tweets
Magento Developer oDesk: chi flat iron on Looking for russianeast european PHP DEVELOPER oDesk · wholesale jordan ... http://bit.ly/9aWcB8
Flower Shop Premium Magento E-commerce Theme http://bit.ly/bgve6q
JM Purity Premium Magento Theme http://bit.ly/aUN2mC
RAC - Magento Install, Apply Design, Tweaks--By WhiteLabelSEO on Mar 22--Max Bid: $45: 1. Install Magento (or OSCo... http://bit.ly/9KPLk9
เริ่มสนุกกะ magento commerce
|
|
I guess we just have to rebuild search index.
I use to face such problem but after I rebuild search index, I cannot reproduce such problem anymore. Problem solved.
Regards,
Sukses