Prune Comments

tommyxv · June 2nd, 2006, 09:42 AM

I deleted some users form my vBulletin, but now all thier comment in the gallery show no name, just an IP to admins. How do i remove these comments?

None of them had images in the gallery, just comments. I pruned all their threads and posts in the forums, then deleted them.

Chuck S · June 2nd, 2006, 10:05 AM

Well there is no specific prune comments by user utility in Photopost. In a standalone install of photopost we prune all pics and comments of the user when user is deleted but in a forum integration this is not the case.

You can try running a query in phpmyadmin is your comfortable with that program

DELETE FROM pp_comments WHERE userid = 0

tommyxv · June 2nd, 2006, 10:33 AM

Quote:

Originally Posted by Chuck S

Well there is no specific prune comments by user utility in Photopost. In a standalone install of photopost we prune all pics and comments of the user when user is deleted but in a forum integration this is not the case.

You can try running a query in phpmyadmin is your comfortable with that program

DELETE FROM pp_comments WHERE userid = 0

Am i changing that 0 to something? Becuase I have no way of knowing what the id numbers where for the deletd users.

Chuck S · June 2nd, 2006, 10:40 AM

Right but you can run in Admin => Scan Database the resync username tool and then run this query I noted because the scan database tool will set orphaned photos and commnets to userid 0 and username anonymous. The query I posted should then work fine to remove all orphaned comments.

tommyxv · June 2nd, 2006, 11:27 AM

Phpmysql is asking me to choose at least one column to display when I try to submit the query.

Field
Sort
Show
Criteria

Any suggestions?

Chuck S · June 2nd, 2006, 12:47 PM

If you issue the query I gave there should be no issue in phpmyadmin I dont know about this phpmysql program so cant say. The query posted if your table prefix in photopost is pp_ will delete all comments from userid 0

tommyxv · June 2nd, 2006, 01:31 PM

Ok, all fixed.

Sal Collaziano · July 27th, 2006, 05:15 PM

How about comments from "unregistered". In fact, I'd like to delete ALL comments altogether and turn off the option. Too much spam. Please help before Google bans my site for all the links. There are thousands and I can't keep clicking the single remove link all day and night.

Michael P · July 27th, 2006, 05:30 PM

I believe unregistered are added with a userid of 0, so Chuck's query above would remove them.

Sal Collaziano · July 27th, 2006, 06:09 PM

Thank you!!

pengrus · December 28th, 2006, 06:22 PM

Can we take this resync -orphan photo, and modify the query to remove orphan photos?

Chuck S · December 28th, 2006, 09:26 PM

There is no resync thing for this as you can allow guests to upload photos and they will always be userid 0 so how is one suppose to know what is orphan and what is not?

pengrus · December 28th, 2006, 10:43 PM

Ok, then is there a query to delete photos whose userid is 0?

Thanks for your help!

Chuck S · December 29th, 2006, 08:37 AM

query is easy but how are the files being deleted? You can use the query above just change the table names

pengrus · January 2nd, 2007, 04:14 PM

Hi Chuck, I do not know the code, so I am replying your developer/support team on this request. We need a way to delete photos uploaded by anonymous users (or more importantly, after the members were deleted, the photos left behind which you say they then become of owner id 0 same as anonymous).

We simply cannot let this grow out of hand and slow down the system and consume the resources.

I cannot believe that there is no such a function to delete photos by anonymous users. Not even from the admin edit function? for example, search photo page, and userid# 0? I tried put 0 in Search page, and it brings up all kinds of photos with correct owners, so userid 0 in search page does not work.

If there is not such a function, please consider this as a top priority request for its reasoning behind, and introduce this function. Even if it means the admin needs to delete the photos one by one, we still need to do it in whatever means.

Please... bring this request to the development team.

Thank you!

Chuck S · January 2nd, 2007, 08:52 PM

You can delete the photos one by one as there is no function in the program for what you wish to do but will pass your thoughts along

pengrus · January 4th, 2007, 01:26 PM

Chuck, thanks for passing the request along.

I can do deleting one by one, but from all the interfaces, I do not find any way that let me "find" those photos.