- xwiki-users@xwiki.org - lists.xwiki.org

XWiki Api Documentation
by jeremi joslin 17 Oct '06

17 Oct '06

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

1 0

RE: [xwiki-users] delete spam comments
by wangwh＠att.net 17 Oct '06

17 Oct '06

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:[email protected]] > > 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 > > > > > >

5 11

Re: [xwiki-users] delete spam comments
by wangwh＠att.net 17 Oct '06

17 Oct '06

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 >

1 0

delete spam comments
by wangwh＠att.net 17 Oct '06

17 Oct '06

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

2 1

Java Stack Tracing Saving 7MB Attachment
by Smith, Nathan 16 Oct '06

16 Oct '06

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

4 3

Nested XWikiObject classes?
by THOMAS, BRIAN M (SBCSI) 16 Oct '06

16 Oct '06

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]

1 0

Chart Wizard
by Sascha Österle 16 Oct '06

16 Oct '06

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

1 0

[xwiki-users] IRC for the xwiki community
by Robin Fernandes 13 Oct '06

13 Oct '06

Hi, Passing this on to the user list after discussion with Vincent. Join us on IRC to discuss XWiki: Server: irc.freenode.net Port: 6667 Channel #xwiki Cheers, Robin. On 13/10/06, Vincent Massol <vincent(a)massol.net> wrote: > Hi everyone, > > I've noticed that this project doesn't have an IRC channel yet. I think it's > extremely valuable for those who are developing on xwiki to be able to share > ideas, do design, etc with a communication channel that is faster than mail. > > This is what we done on the Maven project (irc.codehaus.org, channel > #maven), Cargo and lots of other projects. > > Of course any important decision should also result in an email to the list > so that everyone can follow what's happening. > > I suggest using Freenode. I have set up a channel for us: > > Server: irc.freenode.net > Port: 6667 > Channel #xwiki > > In order to connect there you can use any IRC client: > - mIRC > - Trillian > - or any of the other hundreds of clients: > http://www.ircreviews.org/clients/ > > WDYT? > > Join me there! > > Thanks > -Vincent > > > > > > > ___________________________________________________________________________ > Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! > Demandez à ceux qui savent sur Yahoo! Questions/Réponses > http://fr.answers.yahoo.com > > > > > -- > You receive this message as a subscriber of the xwiki-dev(a)objectweb.org mailing list. > To unsubscribe: mailto:[email protected] > For general help: mailto:[email protected]?subject=help > ObjectWeb mailing lists service home page: http://www.objectweb.org/wws > > >

1 0

Lucene Plugin
by Sascha Österle 12 Oct '06

12 Oct '06

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

1 0

AW: [xwiki-users] Register user broken (but tried the obvious...)
by Frank Häfemeier 11 Oct '06

11 Oct '06

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:[email protected] >For general help: mailto:[email protected]?subject=help >ObjectWeb mailing lists service home page: http://www.objectweb.org/wws

4 6