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

XF 1.2 Post prune for import

Discussion in 'Installation, Upgrade, and Import Support' started by Earl, Jan 11, 2014.

  1. Earl

    Earl Member

    Hi, I am importing large vbulletin 3.8 to xenforo 1.2

    There are about 2million posts which only contains the word "thanks" in my forum. I want to delete them and import a clean and small DB or clean the DB after importing to xenforo.

    I want to delete posts which only contain the word "thanks" without any other words.
    that means not deleting "thanks i made it work" or posts which has "thanks" in them as some part.
  2. Brogan

    Brogan XenForo Moderator Staff Member

    There is no easy way of mass deleting posts based on content after the import.

    It may be possible to run an SQL query and delete them in the vB source database before importing.
    I can't guarantee it would work though so you would need to take a backup and do a test import.

    Something like this might work:
    DELETE * FROM <post_table> WHERE <content> LIKE 'Thanks'
    You will need to enter the correct post table and field names.
  3. Earl

    Earl Member

    Hi @Brogan , Thanks for the response.

    1. but deleting like that will delete visible and invisible (soft deleted) posts from the database, so deleting all types of posts like that will make any issues after the import?
    do I have to change anything in thread or any other tables to complete the process?

    2. Could you please give me a sql query to delete the word "Thanks" with few other characters only,
    Example: Thankyy, Thanks, wow thanks

    so basically need to delete posts with five other character from beginning or end or something like ????thank???
  4. Jeremy

    Jeremy XenForo Moderator Staff Member

    We cannot provide support for vBulletin. Their support forums may be a better place to find out how to do it and properly clean it up.

Share This Page