Announcement

Collapse
No announcement yet.

Deleted Users' Messages

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts
    Steve Machol
    Former Customer Support Manager

  • Steve Machol
    replied
    The most likely cause of this error is that the info in your config.php file is wrong or your db user does not have full permissions to this database. Please read this for all the known causes of this error:

    http://www.vbulletin.com/forum/showthread.php?t=194542

    Leave a comment:

  • aynadaki
    New Member

  • aynadaki
    replied
    Cagonni gave me this sql query on a turkish webmaster forum.At first i tried on a demo board on my localhost and i got this error.I want to delete these users' messages.Can you help me Steve Machol?

    Leave a comment:


  • Cagonni
    replied
    he will write here.

    Leave a comment:

  • Steve Machol
    Former Customer Support Manager

  • Steve Machol
    replied
    Your friend will need to post this question in his own thread.

    Leave a comment:


  • Cagonni
    replied
    thanks Jake but the users have already been deleted.
    one of my friend cant reach his forum after this query.

    mysql_connect() [function.mysql-connect]: Access denied for user <<>> (using password: YES)
    C:\AppServ\www\forum\includes\class_core.php on line 274
    forum was running before the query.

    Leave a comment:

  • Jake Bunce
    Senior Member

  • Jake Bunce
    replied
    That will probably work, but you will end up with orphaned records in other tables (attachments, threads, subscriptions, etc). You can probably run similar queries to cleanup the orphans, but it could be a mess. Ideally you want to use the mass prune feature in the Admin CP, but you have to do that before deleting the user.

    On the other hand, the orphaned records probably won't do any harm.

    Leave a comment:


  • Cagonni
    started a topic Deleted Users' Messages

    Deleted Users' Messages

    Deleted users messages seen as



    can i use the sql query

    Code:
    DELETE FROM post WHERE userid = 0
    for delete all the messages of deleted users?

Related Topics

Collapse

Working...
X