Erreur SQL !UPDATE `tbcodepromotion` AS Target INNER JOIN (SELECT idCodePromotion FROM `tbcodepromotion` TB1 INNER JOIN tbmarchands TB2 ON TB1.`IdMarchand` = TB2.`IdMarchand` WHERE TB1.twitterPost =1 AND TB1.rssPost =0 AND TB2.rssPost =1 AND TB1.permanent =0 AND TB2.valide =1 ORDER BY TB1.datefin LIMIT 1 ) AS source ON source.IdCodePromotion = Target.IdCodePromotion SET rssPost = 1, rssDate = NOW();
Deadlock found when trying to get lock; try restarting transaction