Erreur de la base de données WordPress : [Deadlock found when trying to get lock; try restarting transaction]
CREATE OR REPLACE VIEW glmontpellier_wsm_monthWiseVisitors AS SELECT DATE_FORMAT(CONVERT_TZ(visitLastActionTime,'+00:00','+02:00'),'%Y-%m') as recordMonth, COUNT(*) as visitors FROM glmontpellier_wsm_logUniqueVisit GROUP BY DATE_FORMAT(CONVERT_TZ(visitLastActionTime,'+00:00','+02:00'),'%Y-%m')
Erreur de la base de données WordPress : [Deadlock found when trying to get lock; try restarting transaction]
CREATE OR REPLACE VIEW glmontpellier_wsm_monthWisePageViews AS SELECT DATE_FORMAT(CONVERT_TZ(visitLastActionTime,'+00:00','+02:00'),'%Y-%m') as recordMonth, SUM(totalViews) as pageViews FROM glmontpellier_wsm_pageViews GROUP BY DATE_FORMAT(CONVERT_TZ(visitLastActionTime,'+00:00','+02:00'),'%Y-%m')