What version of Magento are you running? David Neilsen | 07 834 3366 | PANmedia ®
On Tue, Jul 26, 2011 at 2:18 PM, Bob Brown <[email protected]> wrote: > Yep, we've got the logging on ... > > The SQL in particular that is throwing this is: > > SQL: INSERT INTO `catalog_product_entity` (`entity_type_id`, > `created_at`, `updated_at`) VALUES (?, ?, ?) > BIND: Array > ( > [0] => 4 > [1] => 2011-07-19 06:34:46 > [2] => 2011-07-19 06:34:46 > ) > > And the exception is: > > SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or > update a child row: a foreign key constraint fails > (`magento/catalog_product_entity`, CONSTRAINT > `FK_CATALOG_PRODUCT_ENTITY_ATTRIBUTE_SET_ID` FOREIGN KEY > (`attribute_set_id`) REFERENCES `eav_attribute_set` > (`attribute_set_id`) ON DELETE C) > > Followed by a nice stack trace. > > I'm not sure why Magento wants to create another product entity with > an entity_type_id of 4 because it already exists, hence the exception. > > There are custom built modules in use here which is where my current > suspicions lie but the inability to reproduce this issue is > frustrating. > > I don't want to trawl this out onto a public list at this stage but > will happily report back the outcome when we get there. > > Cheers, > > - Bob - > > On 26 July 2011 10:55, David Neilsen <[email protected]> wrote: > > Hi, > > > > Are you logging the error messages and debugging information? If so what > is > > the error message you are getting? > > > > > > David Neilsen | 07 834 3366 | PANmedia ® > > > > > > On Tue, Jul 26, 2011 at 10:45 AM, Bob Brown <[email protected]> wrote: > >> > >> Hi All, > >> > >> We have a Magento installation that is giving us some grief. We are > >> looking to find the right person to help us troubleshoot this. What we > >> don't want is someone who claims they can solve Magento problems > >> because they've installed Magento or applied a CSS skin to it, instead > >> we're looking for someone who groks the Magento core and can help > >> track through to find and resolve this issue. > >> > >> The problem we have is that during the final step of the one page > >> checkout sometimes a database exception is thrown which effectively > >> cancels the checkout process. Customer appear to be able to generate > >> these three times in a row (+1 for persistence) but it does not happen > >> for all customers and we've not been able to reproduce it on a local > >> VM (which is a rsync'd copy of the live server). > >> > >> If you (or someone you know) can help us, please get in touch. > >> > >> Cheers, > >> > >> - Bob - > >> > >> -- > >> Bob Brown, [L|W]AMP Web Developer > >> [email protected], http://www.guru.net.nz > >> > >> -- > >> NZ PHP Users Group: http://groups.google.com/group/nzphpug > >> To post, send email to [email protected] > >> To unsubscribe, send email to > >> [email protected] > > > > -- > > NZ PHP Users Group: http://groups.google.com/group/nzphpug > > To post, send email to [email protected] > > To unsubscribe, send email to > > [email protected] > > > > -- > Bob Brown, [L|W]AMP Web Developer > [email protected], http://www.guru.net.nz > > -- > NZ PHP Users Group: http://groups.google.com/group/nzphpug > To post, send email to [email protected] > To unsubscribe, send email to > [email protected] > -- NZ PHP Users Group: http://groups.google.com/group/nzphpug To post, send email to [email protected] To unsubscribe, send email to [email protected]
