PhotoPost Photo Gallery Sales PhotoPost Sales Toll Free Phone Number
Mon-Fri 9am-4pm EST
  PhotoPost Photo Sharing Photo Gallery    Visualize community tm
| | | | | | | | |
Old October 3rd, 2005, 07:28 PM   #1 (permalink)
Member
Verified Customer
 
Join Date: Feb 2005
Posts: 62
Remove posts after deleting user

I deleted some users and now I have posts hanging in the gallery that have no author. Any simple way to remove all posts that have no author?

The problem here is that I removed all users with 0 posts from my database, but their replies appear in the gallery (I don't count posts in there as posts).

Thanks.
Mijae is offline   Reply With Quote
Old October 4th, 2005, 01:50 PM   #2 (permalink)
Brian
Guest
 
Posts: n/a
Re: Remove posts after deleting user

You could do it with a query..

DELETE FROM adv_gallery_posts WHERE userid = X;

Then just use the 'Update Counters' option in the Maintenance link afterwards.
  Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
User posts wesley Installs and Upgrade - vBulletin 3.5.X 2 September 3rd, 2005 11:09 AM
search for user posts Da GoTTi Bugs From 1.0.0 6 June 17th, 2005 01:12 PM
Validating user posts. jarosciak How Do I? - vBulletin 3.0.X 2 April 22nd, 2005 12:57 PM
Delete All User Posts sifuhall Classifieds Bug Reports 2 February 14th, 2005 10:48 AM


All times are GMT -5. The time now is 02:45 PM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0