Magento WizardNo joke, this website relaunches on 1st April. New look, new features!

Contact the site  Make Money

Home > Troubleshooting > the “SQLSTATE[23000]: Integrity Constraint Violation” Error

The “SQLSTATE[23000]: Integrity Constraint Violation” Error

 Add to Favourites  
(No Ratings Yet)
Loading ... 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.

  • Digg
  • del.icio.us
  • Facebook
  • Google
  • LinkedIn
  • Live
  • Reddit
  • StumbleUpon
  • Technorati
  • TwitThis

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

 Can't load Magento page - the Error Report feature

comments

One Response to “The “SQLSTATE[23000]: Integrity Constraint Violation” Error”

  1. Sukses on May 23rd, 2009

    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

Leave a Reply




Spam protection by WP Captcha-Free

Tags: , , , ,


Can’t Load Magento Page – The Error Report Feature


  • Sponsored Ads

    • Magento Themes
    • vtiger: great article, thank you....

  • Recent Tweets

    #seo #sem #ppc Magento Development: Ecommerce is one of the most viable online business opportunities on the Web t... http://bit.ly/cIU5TA

    @12cvisuals is het mogelijk om in te loggen als klant als je al als admin bent ingelogd? #magento

    Magento - Order Now - Valtrex stomach problem - Buy Valtrex Online ...: Order Now - What is the generic for valtre... http://bit.ly/cg8zbA

    RT @CursoDeEcommerc: Curso Como Montar Uma Loja Virtual - Rio de Janeiro 29/03 e Curso Magento 26/03 ganhe 300,00 bônus http://ow.ly/1fwna

    Curso Como Montar Uma Loja Virtual - Rio de Janeiro 29/03 e Curso Magento 26/03 ganhe 300,00 de bõnus google e buscapé http://ow.ly/1fwjJ