Place Your Ad Here

Bug MySQL query error: Deadlock found when trying to get lock in UPDATE xf_user

There is a bug in this version
T

tlamprecht

Guest
I've seen a few similar posts, not sure how related this is with them though.
And FWIW, I never saw this error in the last decade running XenForo, but now got it once a day after finally upgrading from v2.2 to v2.3.4.

Code:

Code: 
                    UPDATE xf_user
                    SET message_count = GREATEST(0, CAST(message_count AS SIGNED) - ?)
                    WHERE user_id = ?
               
------------

#0 src/XF/Db/Mysqli/Statement.php(207)...

Read more

Continue reading...
 
You must log in or register to reply here.

Similar threads

N
Solved MySQL query error [1062]: Duplicate entry 'hasan69' for key 'xf_user.username'
Replies
0
Views
44
XenForo General Discussions
Nirjonadda
N
C
Solved XF\Db\Exception: MySQL query error [1366]: Incorrect string value:
Replies
0
Views
72
XenForo General Discussions
craigForo
C
H
Solved XF\Db\Exception: MySQL query error [1364]: Field 'ap_ss_ignored_user_style' doesn't have a default value src/XF/Db/AbstractStatement.php
Replies
0
Views
88
XenForo General Discussions
HomieHunter
H
C
Bug XF\Db\Exception: MySQL query error [1366]: Incorrect string value:
Replies
0
Views
84
XenForo General Discussions
craigForo
C
C
XenForo MySQL query error [126]: Incorrect key file for table '.
Replies
0
Views
150
XenForo Development & Modifications
CedricV
C
Top Bottom
Back