Hi,
Ludovic and me worked on the documentation of the API. I haven't
finish the documentation of Document.
here is the link :
http://build.xpertnet.biz/latestdoc/api/
jeremi
Hi, Brian,
Thanks a lot.
My site is on Xwiki.com, can I do all these steps?
Is there a way just to stop showing comments right now?
Wei-hsing
-------------- Original message ----------------------
From: "THOMAS, BRIAN M (SBCSI)" <bt0008(a)att.com>
> Direct database time...
>
> First, BACK UP your database.
>
> No. First, if you are not an SQL hack, get someone who is.
>
> Now, BACK UP your database.
>
> Next, you must delete all rows connected with spam comments.
>
> I'm going to derive the process whereby you do this, because I'm a
> little rusty on the XWiki database schemas, and because I'm an
> inveterate pedant. You can skip some of these steps that exist for
> information only if you wish, especially if you already know how to do
> them.
>
> First, it's necessary to know which rows constitute comments. XWiki's
> dynamic typing is a great boon to users and an equally great bane to
> administrators, as you will soon see. The xwikiclasses table describes
> user-defined classes (well, actually it doesn't; it names them, and
> describes server-defined custom classes if there are any, which
> fortunately there aren't, because I couldn't tell you what to do if
> there were). The class that defines XWiki comments is named
> XWiki.XWikiComments. The xwikiclassesprop table contains the list of
> fields for a given class, which is identified not by its name but by the
> unique ID from the xwikiclasses table. So you need to get the ID of the
> row in the xwikiclasses table whose name field is 'XWiki.XWikiComments',
> and retrieve the field name and type from all rows of the
> xwikiclassesprop table that have that ID. The following SQL does this
> less verbosely:
>
> select xwp_name, xwp_classtype
> from xwikiclassesprop p, xwikiclasses c
> where xwo_name = 'XWiki.XWikiComments'
> and p.xwp_id = c.xwo_id
>
> The results of this should be:
> +-----------+---------------------------------------------+
> | xwp_name | xwp_classtype |
> +-----------+---------------------------------------------+
> | author | com.xpn.xwiki.objects.classes.StringClass |
> | comment | com.xpn.xwiki.objects.classes.TextAreaClass |
> | date | com.xpn.xwiki.objects.classes.DateClass |
> | highlight | com.xpn.xwiki.objects.classes.TextAreaClass |
> | replyto | com.xpn.xwiki.objects.classes.NumberClass |
> +-----------+---------------------------------------------+
> 5 rows in set (0.00 sec)
>
> You'd have to go into the XWiki source (more specifically, the Hibernate
> configuration, I believe) to see how the xwp_classtype field above links
> to what I'm doing below; I leave that as an exercise for the reader.
> All that's really needed is to know the types of the fields and which
> tables they're stored in.
>
> I've actually misled you somewhat: this is not the actual schema of
> existing comment objects but the prototype for the creation of new
> comments. I've done this ostensibly to give you a fuller understanding
> of how XWiki allows one to change the definition of a user-defined class
> without breaking existing instances, but it's really because I got
> tripped up on it myself, and I wanted to share my misery with you.
>
> To get the actual schema for existing comments you have to look at the
> xwikiobjects table, which defines actual XWiki object instances in terms
> of their class names and the document to which they belong. The xwo_id
> field is the field that ties all of the tables together.
>
> So the following query:
>
> select distinct(xwp_name), xwp_classtype
> from xwikiobjects o, xwikiproperties p
> where xwo_classname='XWiki.XWikiComments'
> and xwo_id = xwp_id
>
> yields a similar-looking result (in my database, anyway), because the
> XWiki.XWikiComments class hasn't changed since these comments were
> added:
> +-----------+-------------------------------------------+
> | xwp_name | xwp_classtype |
> +-----------+-------------------------------------------+
> | author | com.xpn.xwiki.objects.StringProperty |
> | date | com.xpn.xwiki.objects.DateProperty |
> | comment | com.xpn.xwiki.objects.LargeStringProperty |
> | replyto | com.xpn.xwiki.objects.IntegerProperty |
> | highlight | com.xpn.xwiki.objects.LargeStringProperty |
> +-----------+-------------------------------------------+
> 5 rows in set (0.05 sec)
>
> So now we know (without explaining how) that (for example) the contents
> of the "author" field of an instance of the class named
> XWiki.XWikiComments is in the xwikistrings table, in a row whose xws_id
> field matches the xwo_id field of an xwikiobjects row whose
> xwo_classname file is "XWiki.XWikiComments". All the field values can
> be found thus:
>
> field name table name field value
> author xwikistrings xws_value
> date xwikidates xws_value
> comment xwikilargestrings xwl_value
> replyto xwikiintegers xwi_value
> highlight xwikilargestrings xwl_value
>
> So all the fields of a comment would be retrieved, given its ID, by the
> following query:
>
> select s.xws_value, /* author name */
> d.xws_value, /* comment date */
> l.xws_value, /* comment text */
> i.xwi_value, /* reply-to field */
> h.xwl_value /* highlight field */
> from xwikistrings s,
> xwikidates d,
> xwikilargestrings l,
> xwikiintegers i,
> xwikilargestrings h
> where s.xws_id = <comment ID> and s.xws_name = 'author'
> and d.xws_id = s.xws_id and d.xws_name = 'date'
> and l.xws_id = s.xws_id and l.xws_name = 'comment'
> and i.xwi_value = s.xws_id and i.xwi_name = 'replyto'
> and h.xwl_value = s.xws_id and h.xwl_name = 'highlight'
>
> Of course, the job is much simpler than this, for several reasons.
> First, the replyto and highlight fields are not populated by XWiki's
> default templates, so they're always null anyway; second, of the
> remaining values, each one is uniquely identified by the object's ID
> field anyway, so the respective name fields don't need to be specified.
>
> To get a list of all comments in the database, with only their object ID
> field, author name, and date (which produces a fairly neat display) this
> query should do it.
>
> select o.xwo_id,
> s.xws_value,
> d.xws_value
> from xwikiobjects o,
> xwikistrings s,
> xwikidates d
> where xwo_classname='XWiki.XWikiComments'
> and s.xws_id = o.xwo_id
> and d.xws_id = o.xwo_id
> order by xwo_id
>
>
>
> With all that as background, what you need to do is:
>
> 1. Identify the offending comments (by their object IDs).
>
> If the comments were all from bogus registrations, then the above query
> with an added qualifier something like:
>
> where s.xws_value in ('XWiki.spammer1', 'XWiki.spammer2'[,...])
>
> will give you the object IDs you need.
>
> If you have allowed anonymous users to comment, then other criteria must
> be used, although of course "s.xws_value = 'XWiki.XWikiGuest'" should be
> in your WHERE clause. Most likely, you could probably nail most of them
> by saying
>
> select o.xwo_id from xwikiobjects o, xwikilargestrings l
> where o.classname = 'XWiki.XWikiComments' and l.xwl_id = o.xwo_id
> and l.xwl_value like "%Viagra%"
> or l.xwl_value like "%sex"
> or l.xwl_value like "%stock%"
> or ...
>
> you get the idea.
>
> The best idea, of course, is to keep running and refining your query
> until you are sure that you've identified all of the offending comments
> and only the offending comments.
>
> 2. After you've built a query that identifies the set of records you
> want to remove, you must delete them from each table where they appear.
> The easiest way to do this is to modify your query to return only the
> xwikiobjects.xwo_id field in the SELECT clause and put it into a
> temporary table:
>
> create temporary table badcomments (comment_id integer);
>
> insert into badcomments select o.xwo_id from xwikiobjects o [... where,
> etc...];
>
> Then delete every row from xwikistrings, xwikilargestrings, xwikidates,
> and xwikiintegers where the respective ID fields (xws_id, xwl_id,
> xws_id, and xwi_id, respectively) match the comment_id field from your
> badcomments table.
>
>
> You can also do it using the $xwiki.search() method, but there you have
> to tie the XWiki objects together using HQL. The advantage is that you
> don't have to have server access; the disadvantage is that it's
> miserable to get it right (my opinion).
>
> brain[sic]
>
> > -----Original Message-----
> > From: wangwh(a)att.net [mailto:wangwh@att.net]
> > Sent: Tuesday, October 17, 2006 12:32 AM
> > To: xwiki-users(a)objectweb.org
> > Subject: [xwiki-users] delete spam comments
> >
> >
> > Hi,
> > My wiki site got over a thousand spam comments, anyone know
> > how can I delete them quickly (better than edit object, then
> > delete one by one).
> > Wei-hsing
> >
> >
>
>
If your Wiki is getting some traffic, you can be the next target also, someone can put in lots of spam comments with nothing but links to his/her sites to promote the sites. If possible, you might want to allow only certain people to leave comments.
*** I assume people reading this email do not do this, but...
To some *ill-minded* Wiki users, please stop doing that to others!
(the sites you are advertising will get bad names...)
-------------- Original message ----------------------
From: wangwh(a)att.net
> Hi,
> My wiki site got over a thousand spam comments, anyone know how can I delete
> them quickly (better than edit object, then delete one by one).
> Wei-hsing
>
Hi,
My wiki site got over a thousand spam comments, anyone know how can I delete them quickly (better than edit object, then delete one by one).
Wei-hsing
Dear xwiki-users,
We are getting a Java exception when saving a 7MB attachment. The
attachment appears to be attached properly, since it appears in the
attachment list and can be downloaded after the error. However, after
attaching four or five files the server becomes so unresponsive that a
restart is required. Configuration Info:
OS: Windows 2000 Server
RAM: 1GB
JDK: 1.5.0_8
App Server: JBoss 4.0.4
Database: MySQL 4.1.21
Note that JBoss is run with -Xmx 512M, and increasing that to -Xmx 1024M
has no effect.
I've gone through the attachment documentation and mailing list archives
and didn't see any references to a similar problem. Any help would be
appreciated - I plan to checkout the code and see what's happening!
Here is the stack trace:
A problem occured while trying to service your request. Please contact
the support if this happens again.
Detailed information:
Error number 0 in 11: Uncaught exception
Wrapped Exception: Java heap space
com.xpn.xwiki.XWikiException: Error number 0 in 11: Uncaught exception
Wrapped Exception: Java heap space
at
com.xpn.xwiki.web.ViewEditAction.execute(ViewEditAction.java:224)
at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestPr
ocessor.java:421)
at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:
226)
at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
at
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:173)
at
com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodi
ngFilter.java:127)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:173)
at
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilte
r.java:96)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
e.java:178)
at
org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAs
sociationValve.java:175)
at
org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.j
ava:74)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
:126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
:105)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
java:107)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:1
48)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:86
9)
at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.proc
essConnection(Http11BaseProtocol.java:664)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint
.java:527)
at
org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorker
Thread.java:112)
at java.lang.Thread.run(Thread.java:595)
Wrapped Exception:
java.lang.OutOfMemoryError: Java heap space
Thanks,
Nathan Smith
I've read about the possibility of creating arbitrary types in
XWikiObject fields, though I haven't found how to do that. One way of
doing it would, of course, be to allow another XWiki class as a type.
I'm not certain of the advisability of such an approach, but putting
that aside, would it require changing the XWiki server code to allow
such a thing to happen?
brain[sic]
Hi,
I'd like to use the Chart Wizard and was trying to create a timeline but
always get a
* Charting exception: Error number 0 in 5: Unparseable date:
How do I have to format the date?
Thanks!
Sascha
Hello!
I am trying to add the lucene plugin
http://www.xwiki.org/xwiki/bin/view/Dev/XWikiLucenePlugin
to my 0.9.1252 XWiki install, but only ever get "No Results".
My boss wants pdf/excel/word search capabilites.
I followed the instructions and also had it once running on a 0.840.
Lucene now seems not to return any results.
Is the plugin compatible with the new versions?
Are changes in XWIKI the reason or could it be that I use the Jetty
windows version?
Thanks and Regards,
Sascha
Hi,
you are faster:-) I have exact the same problem.
>Hi,
>
>My user registration screen is broken and returns a -1 error whenever I try to
>register a new user.
>
>It is on my own xwiki server, not on the farm. I've tried enabling the
>superadmin user, editing, and re-saving the RegisterNewUser document but I
>still get the same problem.
>
>I have two wikis running on this server, with 'virtual' switched on in
>xwiki.cfg; the registration works fine in the default wiki but not in the new
>one I have created.
>
>I'm an utter newbie to xwiki so it's possible I'm missing something obvious...
>if someone could post step-by-step instructions as to what is normally done to
>solve this problem, I'd be grateful.
>
>Many thanks
>Jonathan Essex.
>
>
>
>--
>You receive this message as a subscriber of the xwiki-users(a)objectweb.org
>mailing list.
>To unsubscribe: mailto:xwiki-users-unsubscribe@objectweb.org
>For general help: mailto:sympa@objectweb.org?subject=help
>ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
