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]
