date:20090817

Re: [xwiki-users] TODO list small bug

2009-08-17 Thread Nikos Georgosopoulos

Well, as I was waiting for your reply, I posted it to my blog, is it in good
faith if I make a link from the page of the app to it?
http://code.xwiki.org/xwiki/bin/view/Applications/TodoApplication?


On Mon, Aug 17, 2009 at 4:44 PM, Guillaume Lerouge guilla...@xwiki.comwrote:

 Hi Nikos,

 On Mon, Aug 17, 2009 at 4:30 PM, Nikos Georgosopoulos georg...@gmail.com
 wrote:

  I would be honored to do so, I just don't know if I have the right to
  post/edit other people work in there.


 It's a wiki, feel free to edit and add information to it as long as you do
 so in good faith and bring relevant information :-)


Thanks for clarifying this, it is formed as a wiki but it could have access
rights reserved (XWiki gives the option).




  I am sorry but I not familiar yet with
  the names of people in XWiki and I don't know if you are one of them.


 I'm definitely one of them - as every member of this community is. I
 simply happen to be posting a bit more often than most other people around
 here ;-)

 hmmm, where do you find the time? someone pays you to do that? can they pay
others too?


  I also
  have no idea where to place this, just as a comment in the page you give
 me
  or there is a more specific space/page for TODO list?


 Well, if your code works for all databases the best thing to do would be to
 update the application's XAR on the website. To do so you would need to
 export the application from your wiki and replace the current one with
 yours.

I have not tested all databases, there is the possibility that the two
changes I made have to be like this only for Oracle since not so many
Databases use CLOBS for larg strings (other use text)


 You can use
 http://code.xwiki.org/xwiki/bin/view/Applications/ImportExportApplicationto
 export the updated TODO application from your current wiki. You'll need to
 include all the pages from the original XAR file.

 You can then upload it here:

 http://code.xwiki.org/xwiki/bin/view/Applications/TodoApplicationDownloads#Attachmentsonce
 you've made sure it works fine (by installing it on a local wiki for
 instance).


Well, I am intrigued, I will try to find some time to test around and see
but it will be a slow process. In the meantime, others could try it, isn't
there anyone else using TODO list app?


 Please let me know if you need additional help.

 Looking forward your first contribution,

 Guillaume


  On Mon, Aug 17, 2009 at 2:31 PM, Guillaume Lerouge guilla...@xwiki.com
  wrote:
 
   Hi Nikos,
  
   On Mon, Aug 17, 2009 at 1:58 PM, Nikos Georgosopoulos 
  georg...@gmail.com
   wrote:
  
Hi all,
   
I have been trying for the last day to put the TODO app in my wiki
 and
  it
kept on failing to show the mytodo list in the panel. I use Oracle
 for
backend so I thought it was that the problem. Here is the panel's
 code
corrected to work in my case (XWiki 1.9.3, Tomacat 6, Oracle XE 11):
#panelheader('My Todos')
   
#set ($hql = , BaseObject as obj, StringProperty as prop1,
LargeStringProperty as prop2 where obj.name=doc.fullName and
obj.className='XWiki.TodoClass' and obj.name 
   'XWiki.TodoClassTemplate'
and obj.id=prop1.id.id and prop1.id.name='Status'
and prop1.value  'Finished' and obj.id=prop2.id.id
and prop2.id.name ='Assignee' and prop2.value like '$context.user'
 order by doc.date desc)
   
#foreach ($todo in $xwiki.searchDocuments($hql, 5, 0))
* [$todo]
#end
#panelfooter()
   
The big difference is the LargeStringProperty (Instead of
  StringProperty
used in the XAR) and the like instead of = used to match the value.
   
For the LargeStringProperty it is strange for me that someone chose a
   CLOB
to store user names but... maybe because of the class hierarchy
  involved
   in
the user name. Then again, how can this work even without oracle?
   
For the like, well, oracle atleast will not even bother checking a
  string
against a stream. Yes the words are phonetically close but oracle
doesn't care about phonetics.
   
I hope others out there will enjoy this helpful app.
  
  
   Glad you liked it :-)
  
   It would be cool if you updated the page on code.xwiki.org explaining
  how
   you made the app work under Oracle.
  
   Thanks,
  
   Guillaume
  
  
   
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
   
  
  
  
   --
   Guillaume Lerouge
   Product Manager - XWiki
   Skype: wikibc
   Twitter: glerouge
   http://guillaumelerouge.com/
   ___
   users mailing list
   users@xwiki.org
   http://lists.xwiki.org/mailman/listinfo/users
  
  ___
  users mailing list
  users@xwiki.org
  http://lists.xwiki.org/mailman/listinfo/users
 



 --
 Guillaume Lerouge
 Product Manager - XWiki
 Skype: wikibc
 Twitter: glerouge
 http://guillaumelerouge.com/

Re: [xwiki-users] Configuring XWiki as ROOT webapp

2009-08-17 Thread Trevor

On Mon, 17 Aug 2009 17:30:13 +0300 Sergiu Dumitriu wrote:

 Can you try with Context path= instead of path=/?

Same result.
http://127.0.0.1:9080/xwiki/bin/Main/ThisWikiDoesNotExist

What about privileged ?  Should that be false or true ?  allowLinking ?

Trevor
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] TODO list small bug

2009-08-17 Thread Guillaume Lerouge

Hi Nikos,

On Mon, Aug 17, 2009 at 4:59 PM, Nikos Georgosopoulos georg...@gmail.comwrote:

 Well, as I was waiting for your reply, I posted it to my blog, is it in
 good
 faith if I make a link from the page of the app to it?
 http://code.xwiki.org/xwiki/bin/view/Applications/TodoApplication?


That's a good start :-)

However, as Vincent stated it it's even better if you post it right on
XWiki.org




 On Mon, Aug 17, 2009 at 4:44 PM, Guillaume Lerouge guilla...@xwiki.com
 wrote:

  Hi Nikos,
 
  On Mon, Aug 17, 2009 at 4:30 PM, Nikos Georgosopoulos 
 georg...@gmail.com
  wrote:
 
   I would be honored to do so, I just don't know if I have the right to
   post/edit other people work in there.
 
 
  It's a wiki, feel free to edit and add information to it as long as you
 do
  so in good faith and bring relevant information :-)
 

 Thanks for clarifying this, it is formed as a wiki but it could have access
 rights reserved (XWiki gives the option).


 
 
   I am sorry but I not familiar yet with
   the names of people in XWiki and I don't know if you are one of them.
 
 
  I'm definitely one of them - as every member of this community is. I
  simply happen to be posting a bit more often than most other people
 around
  here ;-)
 
  hmmm, where do you find the time? someone pays you to do that? can they
 pay
 others too?


I'm an employee of XWiki SAS, the company that finances continuing
development of the project (see http://www.xwiki.com/)

In the past we've hired committers on the project to work at the company.
XWiki SAS is currently looking for a system administrator, feel free to
apply: http://www.xwiki.com/xwiki/bin/view/About/SysadminOpenPosition ;-)

However please note that this doesn't give me special status in the
community per se - one can become a committer without being an XWiki SAS
employee and all employees are not committers either - it's a meritocracy.
That's one of the great parts of working on Open-Source software :-)



 
   I also
   have no idea where to place this, just as a comment in the page you
 give
  me
   or there is a more specific space/page for TODO list?
 
 
  Well, if your code works for all databases the best thing to do would be
 to
  update the application's XAR on the website. To do so you would need to
  export the application from your wiki and replace the current one with
  yours.
 
 I have not tested all databases, there is the possibility that the two
 changes I made have to be like this only for Oracle since not so many
 Databases use CLOBS for larg strings (other use text)

 
  You can use
 
 http://code.xwiki.org/xwiki/bin/view/Applications/ImportExportApplicationto
  export the updated TODO application from your current wiki. You'll need
 to
  include all the pages from the original XAR file.
 
  You can then upload it here:
 
 
 http://code.xwiki.org/xwiki/bin/view/Applications/TodoApplicationDownloads#Attachmentsonce
  you've made sure it works fine (by installing it on a local wiki for
  instance).
 

 Well, I am intrigued, I will try to find some time to test around and see
 but it will be a slow process. In the meantime, others could try it, isn't
 there anyone else using TODO list app?


Great, thanks.

Guillaume




 
  Please let me know if you need additional help.
 
  Looking forward your first contribution,
 
  Guillaume
 
 
   On Mon, Aug 17, 2009 at 2:31 PM, Guillaume Lerouge 
 guilla...@xwiki.com
   wrote:
  
Hi Nikos,
   
On Mon, Aug 17, 2009 at 1:58 PM, Nikos Georgosopoulos 
   georg...@gmail.com
wrote:
   
 Hi all,

 I have been trying for the last day to put the TODO app in my wiki
  and
   it
 kept on failing to show the mytodo list in the panel. I use Oracle
  for
 backend so I thought it was that the problem. Here is the panel's
  code
 corrected to work in my case (XWiki 1.9.3, Tomacat 6, Oracle XE
 11):
 #panelheader('My Todos')

 #set ($hql = , BaseObject as obj, StringProperty as prop1,
 LargeStringProperty as prop2 where obj.name=doc.fullName and
 obj.className='XWiki.TodoClass' and obj.name 
'XWiki.TodoClassTemplate'
 and obj.id=prop1.id.id and prop1.id.name='Status'
 and prop1.value  'Finished' and obj.id=prop2.id.id
 and prop2.id.name ='Assignee' and prop2.value like '$context.user'
  order by doc.date desc)

 #foreach ($todo in $xwiki.searchDocuments($hql, 5, 0))
 * [$todo]
 #end
 #panelfooter()

 The big difference is the LargeStringProperty (Instead of
   StringProperty
 used in the XAR) and the like instead of = used to match the value.

 For the LargeStringProperty it is strange for me that someone chose
 a
CLOB
 to store user names but... maybe because of the class hierarchy
   involved
in
 the user name. Then again, how can this work even without oracle?

 For the like, well, oracle atleast will not even bother checking a
   string
 against a stream. Yes the words are phonetically

Re: [xwiki-users] Different versions of xwiki in one tomcat

2009-08-17 Thread michael . comes

Hello Nikolaos,

thanx for your reply (and also thanx to Jonas Almfeldt)! It's working now!
I wasn't sure how to search for... all keywords I tried didn't lead me to your 
answer! ;-))


- Original Nachricht 
Von: Nikos Georgosopoulos georg...@gmail.com
An:  XWiki Users users@xwiki.org
Datum:   17.08.2009 16:52
Betreff: Re: [xwiki-users] Different versions of xwiki in one tomcat

 I had the same question two days ago. go to xwiki.cfg of the second XWiki
 installation and FORCE your second user's name as the DB name (there is a
 line about it).
 
 On Mon, Aug 17, 2009 at 4:08 PM, michael.co...@arcor.de wrote:
 
  Hello!
 
  I want to run different xwiki-versions (currently 1.7.2 and new 1.9.3) on
  one host in one tomcat-container (but different folders: webapps/xwiki172
  and webapps/xwiki193) against one Oracle-DB (but different users: xwiki
 and
  xwiki2).
 
  The user xwiki is used by version 1.7.2 and is running fine, the version
  1.9.3 is configured to use the DB-User xwiki2.
 
  It seems not to be possible, when I point to http://[...]:8081/xwiki193,
 I
  get:
 
  2009-08-17 15:17:46,757 [http://[...]:8081/xwiki193/bin/view/Main/]
  [http-8081-Processor23] ERROR store.XWikiHibernateBaseStore
  java.sql.SQLException: ORA-00955: name is already used by an existing
  object
 
 at
 
 oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
 at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
 at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
 at
  oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:957)
 at
 
 oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java
 :1170)
 at
 
 oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.jav
 a:1623)
 at
 
 oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1588)
 at
 
 org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatemen
 t.java:225)
 at
 
 org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatemen
 t.java:225)
 at
 
 com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHibernateBaseS
 tore.java:492)
 at
 
 com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHibernateBaseS
 tore.java:308)
 at
 
 com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHibernateBaseS
 tore.java:254)
 at
 
 com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernate(XWikiHibernateBas
 eStore.java:563)
 at
 
 com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.
 java:1024)
 at
 
 com.xpn.xwiki.store.XWikiHibernateBaseStore.executeRead(XWikiHibernateBaseSt
 ore.java:1068)
 at
 
 com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager.getDB
 Version(XWikiHibernateMigrationManager.java:
 at
 
 com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.init(AbstractX
 WikiMigrationManager.java:68)
 at
 
 com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager.init
 (XWikiHibernateMigrationManager.java:51)
  [...]
 at
  org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(Unknown
  Source)
 at java.lang.Thread.run(Thread.java:619)
  2009-08-17 15:17:46,809 [http://[...]:8081/xwiki193/bin/view/Main/]
  [http-8081-Processor23] WARN  util.JDBCExceptionReporter
  2009-08-17 15:17:46,809 [http://[...]:8081/xwiki193/bin/view/Main/]
  [http-8081-Processor23] ERROR util.JDBCExceptionReporter
 
  com.xpn.xwiki.XWikiException: Error number 3001 in 3: Cannot load class
  com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigra
  Wrapped Exception: Error number 0 in 3: Exception while hibernate execute
  Wrapped Exception: could not execute query
 at com.xpn.xwiki.XWiki.createClassFromConfig(XWiki.java:1005)
 at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:728)
 at com.xpn.xwiki.XWiki.init(XWiki.java:670)
 at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:317)
 at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:388)
 at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:135)
 at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:115)
 at
 
 org.apache.struts.action.RequestProcessor.processActionPerform(RequestProces
 sor.java:431)
 at
 
 org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
 
 at
  org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
 at
  org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
   [...]
 
  It looks a little bit like jira-XWIKI-2009 which is noticed to be fixed.
 
  Is this possible? How to do?
 
  hp-ux 11.23
  java 1.6.0.03
  tomcat 5.5.20
  oracle 10.2.0.3

[xwiki-users] Documents failing to save. Mysql table crash

2009-08-17 Thread John T. Carroll


Hi

I have a problem where creating and saving/editing documents fails.
I am using xwiki version 1.1.1  Here are some errors shown from the detailed
information page. 

   Error number 3201 in 3: Exception while saving document AVL.test
   Wrapped Exception: Error number 3211 in 3: Exception while updating
archive AVL.test
   Wrapped Exception: Error number 3212 in 3: Exception while loading
archive 1,473,480,338
   Wrapped Exception: Error number 0 in 3: Exception while hibernate execute
   Wrapped Exception: could not execute query

Also in the same Detailed information report:
   Wrapped Exception:

   java.sql.SQLException: Table './macomtech/xwikircs' is marked as crashed
and should be repaired
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3256)

I havent come across this problem before in xwiki or mysql.
I could use repair table xwikircs in mysql.  What else needs to be done to
fix problem or is there a better way to fix it?

Thanks

John








-- 
View this message in context: 
http://n2.nabble.com/Documents-failing-to-save.-Mysql-table-crash-tp3459900p3459900.html
Sent from the XWiki- Users mailing list archive at Nabble.com.
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] Configuring XWiki as ROOT webapp

2009-08-17 Thread Trevor

Ok, I found out a little more.
It works fine when I browse to localhost:8180 from the machine that's running 
XWiki.
However, if I try it from another PC on the local network using 
192.168.1.196:8180 I get the Connection Interrupted error.

Do I have to bind something somewhere?

If requested I can attach a (large) log file with the exception.

Thanks again,
Trevor
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] Configuring XWiki as ROOT webapp

2009-08-17 Thread Sergiu Dumitriu

Trevor wrote:
 Ok, I found out a little more.
 It works fine when I browse to localhost:8180 from the machine that's running 
 XWiki.
 However, if I try it from another PC on the local network using 
 192.168.1.196:8180 I get the Connection Interrupted error.
 
 Do I have to bind something somewhere?

Are you running in virtual mode? (xwiki.virtual=1)

 If requested I can attach a (large) log file with the exception.

You should put it on a pastebin and mail just the link to it.

-- 
Sergiu Dumitriu
http://purl.org/net/sergiu/
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] Documents failing to save. Mysql table crash

2009-08-17 Thread Sergiu Dumitriu

John T. Carroll wrote:
 Hi
 
 I have a problem where creating and saving/editing documents fails.
 I am using xwiki version 1.1.1  Here are some errors shown from the detailed
 information page. 
 
Error number 3201 in 3: Exception while saving document AVL.test
Wrapped Exception: Error number 3211 in 3: Exception while updating
 archive AVL.test
Wrapped Exception: Error number 3212 in 3: Exception while loading
 archive 1,473,480,338
Wrapped Exception: Error number 0 in 3: Exception while hibernate execute
Wrapped Exception: could not execute query
 
 Also in the same Detailed information report:
Wrapped Exception:
 
java.sql.SQLException: Table './macomtech/xwikircs' is marked as crashed
 and should be repaired
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
   at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
   at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
   at com.mysql.jdbc.Connection.execSQL(Connection.java:3256)
 
 I havent come across this problem before in xwiki or mysql.
 I could use repair table xwikircs in mysql.  What else needs to be done to
 fix problem or is there a better way to fix it?

XWiki should in no way cause a table to crash, since it uses just SQL to 
talk to the database. This is usually a hardware-related problem, so the 
mysql documentation can provide more help.

-- 
Sergiu Dumitriu
http://purl.org/net/sergiu/
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] TODO list small bug

2009-08-17 Thread Sergiu Dumitriu

Guillaume Lerouge wrote:
 Hi Nikos,
 
 On Mon, Aug 17, 2009 at 4:59 PM, Nikos Georgosopoulos 
 georg...@gmail.comwrote:
 

 I am sorry but I not familiar yet with
 the names of people in XWiki and I don't know if you are one of them.

 I'm definitely one of them - as every member of this community is. I
 simply happen to be posting a bit more often than most other people
 around
 here ;-)

 hmmm, where do you find the time? someone pays you to do that? can they
 pay
 others too?

 
 I'm an employee of XWiki SAS, the company that finances continuing
 development of the project (see http://www.xwiki.com/)
 
 In the past we've hired committers on the project to work at the company.
 XWiki SAS is currently looking for a system administrator, feel free to
 apply: http://www.xwiki.com/xwiki/bin/view/About/SysadminOpenPosition ;-)
 
 However please note that this doesn't give me special status in the
 community per se - one can become a committer without being an XWiki SAS
 employee and all employees are not committers either - it's a meritocracy.
 That's one of the great parts of working on Open-Source software :-)

By the way, Guillaume himself is not a committer.

-- 
Sergiu Dumitriu
http://purl.org/net/sergiu/
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] TODO list small bug

2009-08-17 Thread Vincent Massol


On Aug 17, 2009, at 6:31 PM, Sergiu Dumitriu wrote:

 Guillaume Lerouge wrote:
 Hi Nikos,

 On Mon, Aug 17, 2009 at 4:59 PM, Nikos Georgosopoulos georg...@gmail.com 
 wrote:


 I am sorry but I not familiar yet with
 the names of people in XWiki and I don't know if you are one of  
 them.

 I'm definitely one of them - as every member of this community  
 is. I
 simply happen to be posting a bit more often than most other people
 around
 here ;-)

 hmmm, where do you find the time? someone pays you to do that?  
 can they
 pay
 others too?


 I'm an employee of XWiki SAS, the company that finances continuing
 development of the project (see http://www.xwiki.com/)

 In the past we've hired committers on the project to work at the  
 company.
 XWiki SAS is currently looking for a system administrator, feel  
 free to
 apply: http://www.xwiki.com/xwiki/bin/view/About/ 
 SysadminOpenPosition ;-)

 However please note that this doesn't give me special status in the
 community per se - one can become a committer without being an  
 XWiki SAS
 employee and all employees are not committers either - it's a  
 meritocracy.
 That's one of the great parts of working on Open-Source software :-)

 By the way, Guillaume himself is not a committer.

and the XWiki project's governance rules are available here:
http://dev.xwiki.org/

Thanks
-Vincent
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] TODO list small bug

2009-08-17 Thread Nikos Georgosopoulos

I find this absolutely reasonable justification. I will create a page then
and put it there. Then I will link the TODOs page with the new one. How does
that sound?

On Mon, Aug 17, 2009 at 5:14 PM, Vincent Massol vinc...@massol.net wrote:

On Aug 17, 2009, at 4:59 PM, Nikos Georgosopoulos wrote:

Well, as I was waiting for your reply, I posted it to my blog, is it
in good
faith if I make a link from the page of the app to it?
http://code.xwiki.org/xwiki/bin/view/Applications/TodoApplication?

Well it's easier if people can find all the information they need on
the xwiki.org wiki. Also if your blog disappears for any reason (you
switch blogs, etc) then the link will be broken.

Thanks
-Vincent

On Mon, Aug 17, 2009 at 4:44 PM, Guillaume Lerouge guilla...@xwiki.com
wrote:

Hi Nikos,

On Mon, Aug 17, 2009 at 4:30 PM, Nikos Georgosopoulos
georg...@gmail.com
wrote:

I would be honored to do so, I just don't know if I have the right
to
post/edit other people work in there.

It's a wiki, feel free to edit and add information to it as long as
you do
so in good faith and bring relevant information :-)

Thanks for clarifying this, it is formed as a wiki but it could have
access
rights reserved (XWiki gives the option).

I am sorry but I not familiar yet with
the names of people in XWiki and I don't know if you are one of
them.

I'm definitely one of them - as every member of this community
is. I
simply happen to be posting a bit more often than most other people
around
here ;-)

hmmm, where do you find the time? someone pays you to do that? can
they pay
others too?

I also
have no idea where to place this, just as a comment in the page
you give
me
or there is a more specific space/page for TODO list?

Well, if your code works for all databases the best thing to do
would be to
update the application's XAR on the website. To do so you would
need to
export the application from your wiki and replace the current one
with
yours.

I have not tested all databases, there is the possibility that the two
changes I made have to be like this only for Oracle since not so many
Databases use CLOBS for larg strings (other use text)

You can use

http://code.xwiki.org/xwiki/bin/view/Applications/ImportExportApplicationto
export the updated TODO application from your current wiki. You'll
need to
include all the pages from the original XAR file.

You can then upload it here:

http://code.xwiki.org/xwiki/bin/view/Applications/TodoApplicationDownloads#Attachmentsonce
you've made sure it works fine (by installing it on a local wiki for
instance).

Well, I am intrigued, I will try to find some time to test around
and see
but it will be a slow process. In the meantime, others could try it,
isn't
there anyone else using TODO list app?

Please let me know if you need additional help.

Looking forward your first contribution,

Guillaume

On Mon, Aug 17, 2009 at 2:31 PM, Guillaume Lerouge
guilla...@xwiki.com
wrote:

Hi Nikos,

On Mon, Aug 17, 2009 at 1:58 PM, Nikos Georgosopoulos
georg...@gmail.com
wrote:

Hi all,

I have been trying for the last day to put the TODO app in my wiki
and
it
kept on failing to show the mytodo list in the panel. I use Oracle
for
backend so I thought it was that the problem. Here is the panel's
code
corrected to work in my case (XWiki 1.9.3, Tomacat 6, Oracle XE
11):
#panelheader('My Todos')

#set ($hql = , BaseObject as obj, StringProperty as prop1,
LargeStringProperty as prop2 where obj.name=doc.fullName and
obj.className='XWiki.TodoClass' and obj.name
'XWiki.TodoClassTemplate'
and obj.id=prop1.id.id and prop1.id.name='Status'
and prop1.value 'Finished' and obj.id=prop2.id.id
and prop2.id.name ='Assignee' and prop2.value like '$context.user'
order by doc.date desc)

#foreach ($todo in $xwiki.searchDocuments($hql, 5, 0))
* [$todo]
#end
#panelfooter()

The big difference is the LargeStringProperty (Instead of
StringProperty
used in the XAR) and the like instead of = used to match the
value.

For the LargeStringProperty it is strange for me that someone
chose a
CLOB
to store user names but... maybe because of the class hierarchy
involved
in
the user name. Then again, how can this work even without oracle?

For the like, well, oracle atleast will not even bother checking a
string
against a stream. Yes the words are phonetically close but
oracle
doesn't care about phonetics.

I hope others out there will enjoy this helpful app.

Glad you liked it :-)

It would be cool if you updated the page on code.xwiki.org
explaining
how
you made the app work under Oracle.

Thanks,

Guillaume

___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] TODO list small bug

2009-08-17 Thread Vincent Massol

On Aug 17, 2009, at 6:52 PM, Nikos Georgosopoulos wrote:

I find this absolutely reasonable justification. I will create a
page then
and put it there. Then I will link the TODOs page with the new one.
How does
that sound?

You could use the existing page at
http://code.xwiki.org/xwiki/bin/view/Applications/TodoApplication

You could mention that the first version was done for a TSS article
and link it and then add your new version.

BTW you can join us on IRC if you want direct interactions
see http://dev.xwiki.org/xwiki/bin/view/Community/IRC

Thanks
-Vincent

On Mon, Aug 17, 2009 at 5:14 PM, Vincent Massol vinc...@massol.net
wrote: