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

Prune all likes (queries)

An example of SQL-queries to prune all likes.

  1. GliX
    Compatible XF Versions:
    • 1.0
    • 1.1
    • 1.2
    • 1.3
    • 1.4
    Description: an example of SQL-queries to prune all likes.

    Before you perform any action with the database, don't forget to backup!

    Queries are executed sequentially:
    PHP:
    DELETE FROM xf_liked_content;
    PHP:
    UPDATE xf_user AS u
    SET like_count 
    = (
       
    SELECT COUNT(*)
       
    FROM xf_liked_content AS lc...
    You do not have permission to view the full content of this resource.
    sinucello likes this.