Hi,
I have a little problem, i sometimes have 500 errors due to a "lock wait
timeout"
Unable to execute UPDATE statement. [wrapped: Could not execute update
[Native Error: Lock wait timeout exceeded; try restarting transaction]
[User Info: UPDATE products SET COUNT_ORDERS = 1,UPDATED_AT =
'2007-12-03 10:39:21' WHERE products.ID=1184]]
What is quiet weird, is that it is a very basic query as you can see.
>>>>>>>>>>>>>>>>>
I think i have found the problem while writing this email, i was lauchung thi
query without retrieving the ongoing transaction.
$this->getShopOrder()->getOrder($con)->getState()->update($con);
$this->updateProductsStats(); /// ** NO CON ***
$con->commit();
If it can helps.
COil.
_____________________________________________________________________________
Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers Yahoo! Mail
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"symfony users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
-~----------~----~----~----~------~----~------~--~---
