• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XF 1.4 SQL Query like_count


Active member
So in xf_user it shows the like_count for each user.

Does anyone know of an SQL query I can run to change a specific user's like_count to a different number?


Active member
Okay I think I got one figured out:

UPDATE  `xf_user` SET  `like_count` =  '659' WHERE  `user_id` =34
(an example of updating member #34 to have 659 likes)

.... Did I do that right?


Active member
Thanks @Solidus

Seems both do the job just fine. You could also throw your database name in there before the first `xf_user` (after the word "Update")