[Using Sakai] How to delete wiki comments

[Matthew Jones]

This feature was never completed. You'd need to do it on the database.

It looks like the comments are in rwikiobject as
select * from rwikiobject where name like '%.000%';
and the name contains the siteid like
'/site/efe8cfd0-275b-4f52-8329-69ae1fc49c16/home.000.001'

name = /site/<site id>/<rwiki page>.<comment ids>

If you delete these, the comments go away, but should probably select the
ids and clean up the ids from other tables like rwikicurrentcontent (and
also rwikihistory is similar to rwikiobject and rwikihistorycontent and
needs to be cleaned or the comments will appear in the history)

Actually it's semi neat because you can "link" to a comment as a page like
[home.000] and it will show all of the comments. I'm not sure if this is
intentional or not. ;)

So if there was a way to delete pages, there would also be a way to delete
comments, but that functionality doesn't exist either.

I'd back these tables up first though for sure.

On Thu, Mar 29, 2012 at 3:59 PM, Rafael Morales
<rmorales at udgvirtual.udg.mx>wrote:

>  Hello,
>
> We have decided to restart a wiki in a site, so we would like to delete
> all comments made so far, but we have not found a way to do so. Do we need
> to go to the database? Could you point to the tables we need to change? Is
> there a better way to do it?
>
> Regards,
> Rafael
>
> ------------------------------
>
> *Dr. Rafael Morales. Researcher. IGCAAV @ UDGVirtual, Universidad de
> Guadalajara. Avenida de la Paz 2453, Colonia Arcos Vallarta, 44130
> Guadalajara, Jalisco, México. Tel +52 (33) 3540-3020 ext. 18823. Fax +52
> (33) 3630-0934. Email rmorales at udgvirtual.udg.mx. Web
> http://investigacion.​udgvirtual.​udg.​mx/​personal/​rmorales*
>
>
> _______________________________________________
> sakai-user mailing list
> sakai-user at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-user
>
> TO UNSUBSCRIBE: send email to
> sakai-user-unsubscribe at collab.sakaiproject.org with a subject of
> "unsubscribe"
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-user/attachments/20120329/8e2d06af/attachment.html