Re: [xwiki-users] xwql join query

[afrey]

It doesn't have to be an xwql query. It could be sql, hql, anything that
would work ;)
-- 
View this message in context: 
http://xwiki.475771.n2.nabble.com/xwql-join-query-tp5762763p5763606.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] xwql join query

[afrey]

I tried the query and it doesn't work. It seems that "member of" causes the
query to fail to execute.
Unfortunately I cannot use "Database tree" as the data type for "Supplier"
property of Fruit.



-- 
View this message in context: 
http://xwiki.475771.n2.nabble.com/xwql-join-query-tp5762763p5763517.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] xwql join query

[Marius Dumitru Florea]

On 11/22/2010 04:27 PM, afrey wrote:
>
> I tried the following query but I didn't get anything :(
> #set($fruits = $services.query.xwql("from doc.object(Fruit.FruitClass) as
> fru, doc.object(Supplier.SupplierClass) as sup where
> fru.Supplier.Name=sup.Name and sup.City='Melbourne'").execute())

On 
http://platform.xwiki.org/xwiki/bin/view/DevGuide/QueryGuide#HQueryLanguageExamples
 
there is a query described as "Search blogs per category". Blog category 
is a database tree but "member of" might work with database lists also. 
Can you try:

#set($fruits = $services.query.xwql("from doc.object(Fruit.FruitClass) 
as fru, doc.object(Supplier.SupplierClass) as sup where sup member of 
fru.Supplier and sup.City='Melbourne'").execute())

Hope this helps,
Marius
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] xwql join query

[afrey]

Yes, sorry I forgot to mention.

Supplier property is a Database List (it allows to select one Supplier from
all of the Supplier objects created). Therefore I cannot have it set as
string. It needs to be a selection from Supplier objects.
Please check the previous post to see the join query that I tried.

Alina.
-- 
View this message in context: 
http://xwiki.475771.n2.nabble.com/xwql-join-query-tp5762763p5763031.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] xwql join query

[Marius Dumitru Florea]

Hi Alina,

On 11/22/2010 04:12 PM, afrey wrote:
>
> Hi all,
>
> I'm struggling creating a xwql query that joins two tables.
>
> Let's say I have two classes: Fruit and Supplier.

> Fruit has the following properties: Name, Supplier.

What's the type of the "Supplier" property? Is it a database list? Have 
you tried using a string property instead (e.g. supplier name) and a 
join condition like fruit.Supplier = supplier.Name ?

Hope this helps,
Marius

> Supplier has the following properties: Name, City.
>
> I need the query that returns:
> All Fruit that has Supplier with City='Melbourne'.
>
> I can get all the Fruit objects:
> #set($fruits = $services.query.xwql("from doc.object(Fruit.FruitClass) as
> fru").execute())
>
> And separately I can get all the Supplier objects that have city='Melbourne'
> #set($suppliers = $services.query.xwql("where
> doc.object(Supplier.SupplierClass).City='Melbourne'").execute())
>
> But I can't combine them. Please advise.
>
> Alina.
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] Unknown macro: html after fresh install

[Scardino, Leonard R Jr ERDC-ITL-MS Contractor]

Hah, duh.  I have no idea why I didn't think to check the Tomcat logs.  Maybe
just a long day.

Well, I'll continue to research this on my own, but since I've already put
out this email on the mailing list, I'll continue it.



1. "What version of XWiki Enterprise did you install?"

XWiki Enterprise 2.5.1.32531


2. "Does this happen only with the HTML macro? Are the rest of the macros
(e.g. velocity, groovy, info etc.) working fine?"

They seem to be.  I don't see any other boxes other than the "! Unknown
macro: html"

3. "Are there any exceptions logged when you start the wiki or when you
render a wiki page that includes an HTML macro?"

Hah, yes, quite a few.  As I stated before, I'm not sure why it didn't occur
to me to check for this.  I won't list the entire stack trace, but here are
the main exception names.

2010-11-22 09:00:55,636 [https://localhost/xwiki/bin/view/Main/] ERROR
rterVelocityContextInitializer  - Unrecoverable error, office importer will
not be available for velocity scripts. 
org.xwiki.officeimporter.OfficeImporterException: Error while initializing
office importer velocity bridge.
...
Caused by: org.xwiki.component.manager.ComponentLookupException: Failed to
lookup component [role = [org.xwiki.officeimporter.OfficeImporter] hint =
[default]]
...
Caused by: org.xwiki.component.manager.ComponentLookupException: Failed to
lookup component [role =
[org.xwiki.officeimporter.builder.XHTMLOfficeDocumentBuilder] hint =
[default]]
...
Caused by: org.xwiki.component.manager.ComponentLookupException: Failed to
lookup component [role = [org.xwiki.xml.html.HTMLCleaner] hint = [openoffice]
...
Caused by: org.xwiki.component.manager.ComponentLookupException: Failed to
lookup component [role = [org.xwiki.xml.html.HTMLCleaner] hint = [default]]
...
Caused by: java.lang.NullPointerException
at
org.apache.xerces.dom.ElementImpl.reconcileDefaultAttributes(ElementImpl.java
:962)

4. "You have xwiki-core-rendering-macro-html-x.y.jar in your WEB-INF/lib
right?"

Yes I do.


Thank you very much for your help.  If you have any more suggestions based on
the above, I'll be happy to hear them.  I will of course continue research on
my own now that I know the exceptions.  So if you feel you have done your due
diligence I definitely understand.

Thanks,

Lenny



-Original Message-
From: users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] On Behalf Of
Marius Dumitru Florea
Sent: Monday, November 22, 2010 2:19 AM
To: users@xwiki.org
Subject: Re: [xwiki-users] Unknown macro: html after fresh install

Hi Lenny,

On 11/20/2010 12:09 AM, Scardino, Leonard R Jr ERDC-ITL-MS Contractor wrote:
> I'm afraid I've searched as much as I can, and cannot find an answer to
this.
>

> I just did a fresh install of xwiki on Windows Server 2003, 
> Apache/Tomcat(5.5.28), MySQL Server 5.1.

What version of XWiki Enterprise did you install?

> I'm getting boxes with "! Unknown macro: html".

Does this happen only with the HTML macro? Are the rest of the macros (e.g.
velocity, groovy, info etc.) working fine?

>
> I've also installed xwiki on my laptop running XP, Tomcat(6.0.26), 
> MySQL Server 5.1, and had no problems.
>
> Can someone give me an idea of what might be causing this?  I'm a java 
> programmer, so I can get into nuts and bolts if necessary.  Hopefully 
> its not. If I have not provided enough information, please let me know 
> and I'll be happy to expound.

Are there any exceptions logged when you start the wiki or when you render a
wiki page that includes an HTML macro?

You have xwiki-core-rendering-macro-html-x.y.jar in your WEB-INF/lib right?

Hope this helps,
Marius

>
> Thanks,
>
> Lenny
> ___
> 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
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] [ANN] XWiki Enterprise and XWiki Enterprise Manager 2.6 Released

[Roman Muntyanu]

Thanks for the Icon/Emoticon Support at syntax level! It's about time :)

-Original Message-
From: users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] On Behalf Of 
Vincent Massol
Sent: Monday, November 22, 2010 12:30 PM
To: XWiki Users; XWiki Developers
Subject: [xwiki-users] [ANN] XWiki Enterprise and XWiki Enterprise Manager 2.6 
Released

The XWiki development team is pleased to announce the release of XWiki 
Enterprise and XWiki Enterprise Manager 2.6.

Go grab them at http://www.xwiki.org/xwiki/bin/view/Main/Download

Changes from XE 2.6:

* Revamped Recent Activity Dashboard, which is now called Activity Stream
* Share page by mail feature
* Icon/Emoticon Support
* Auto linking of WikiWords
* New Activity Macro

For more information see the Release notes at:
http://www.xwiki.org/xwiki/bin/view/Main/ReleaseNotesXWikiEnterprise26
And
http://www.xwiki.org/xwiki/bin/view/Main/ReleaseNotesXEM26

Thanks
-The XWiki dev team
___
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

Re: [xwiki-users] xwql join query

[afrey]

I tried the following query but I didn't get anything :(
#set($fruits = $services.query.xwql("from doc.object(Fruit.FruitClass) as
fru, doc.object(Supplier.SupplierClass) as sup where
fru.Supplier.Name=sup.Name and sup.City='Melbourne'").execute())
-- 
View this message in context: 
http://xwiki.475771.n2.nabble.com/xwql-join-query-tp5762763p5762809.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] [xwiki-devs] [Investigation] User Statuses

[Ricardo Rodriguez [eBioTIC.]]

Jerome Velociter wrote:
> Hello Caty,
>
> For me a key use case of this feature is link/page sharing.
>
> "Thoughts sharing" in enterprise context is not so key IMHO (some could even
> say it's not relevant, just noise).
>
> "Page sharing", or "Link sharing", in opposition are valuable features in my
> opinion.
>
> Key use cases :
> * I have finished a first draft of an important document, and want to ask
> for a fisrt set of reviews/comments ; but I don't want/need to write a
> lengthy blog post -> I post a short status update that link to my document.
> * I stumbled upon an interesting article/video/etc. on the net, and I want
> to share it with my team, I post the link together with a short update to
> describe it, and invite others to visit / view the video
>   
I do agree on this idea. We currently use some instant messaging system, 
email or even the phone here to get a fluent communication on what team 
members are currently doing. This feature will improve the "team 
feeling" without requiring extra-software. Usually is not a problem to 
get a chat client installed in your desktop computer or laptop, but we 
envision an ubiquitous work environment available simply by accessing 
our wiki farm by means of any kind of Internet browser devices.

Filtering shared item by type (I mean, ideas could also be shared, but 
users must be able to select if they want to receive them or not), 
topic, or author will be mostly welcome.

Thanks!
> So an item with strong value for the user status features as a whole would
> be a powerful link detection, a la facebook : possibly with previews of
> videos, images, extract/summary of articles, etc.
>
> Jerome.
>
> On Mon, Nov 22, 2010 at 2:19 PM, Ecaterina Moraru (Valica) <
> vali...@gmail.com> wrote:
>
>   
>> Hi,
>>
>> There are some features that need to be investigated during the XE 2.7
>> timeframe in order to be able to integrate them in XE 3.0.
>> One of them is **User Statuses** and a main definition for it is: "On top
>> of
>> activity stream > 
>>> ,
>>>   
>> create a User status & twitter integration feature"
>>
>> The question is what should we integrate and cover if we want to have user
>> statuses in XE.
>> In order to deploy mockups I need to have some clear requirements and uses
>> cases.
>> I create some pages on incubator that will gather this mail discussions at:
>> Requirements:
>>
>> http://incubator.myxwiki.org/xwiki/bin/view/Improvements/UserStatusRequirements
>> Use Cases:
>> http://incubator.myxwiki.org/xwiki/bin/view/Improvements/UserStatusUseCases
>>
>> While discussing Activity Stream design we had some design scraps for the
>> status casting part
>> http://incubator.myxwiki.org/xwiki/bin/view/Improvements/UserStatusScrap
>>
>> Please share your vision.
>> Thanks,
>> Caty
>> ___
>> devs mailing list
>> d...@xwiki.org
>> http://lists.xwiki.org/mailman/listinfo/devs
>>
>> 
> ___
> devs mailing list
> d...@xwiki.org
> http://lists.xwiki.org/mailman/listinfo/devs
>
>   

-- 
Ricardo Rodríguez
CTO
eBioTIC.
Life Sciences, Data Modeling and Information Management Systems

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

[xwiki-users] xwql join query

[afrey]

Hi all, 

I'm struggling creating a xwql query that joins two tables.

Let's say I have two classes: Fruit and Supplier.
Fruit has the following properties: Name, Supplier.
Supplier has the following properties: Name, City.

I need the query that returns:
All Fruit that has Supplier with City='Melbourne'.

I can get all the Fruit objects:
#set($fruits = $services.query.xwql("from doc.object(Fruit.FruitClass) as
fru").execute())

And separately I can get all the Supplier objects that have city='Melbourne'
#set($suppliers = $services.query.xwql("where
doc.object(Supplier.SupplierClass).City='Melbourne'").execute())

But I can't combine them. Please advise.

Alina.
-- 
View this message in context: 
http://xwiki.475771.n2.nabble.com/xwql-join-query-tp5762763p5762763.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] [xwiki-devs] [Investigation] User Statuses

[Jerome Velociter]

Hello Caty,

For me a key use case of this feature is link/page sharing.

"Thoughts sharing" in enterprise context is not so key IMHO (some could even
say it's not relevant, just noise).

"Page sharing", or "Link sharing", in opposition are valuable features in my
opinion.

Key use cases :
* I have finished a first draft of an important document, and want to ask
for a fisrt set of reviews/comments ; but I don't want/need to write a
lengthy blog post -> I post a short status update that link to my document.
* I stumbled upon an interesting article/video/etc. on the net, and I want
to share it with my team, I post the link together with a short update to
describe it, and invite others to visit / view the video

So an item with strong value for the user status features as a whole would
be a powerful link detection, a la facebook : possibly with previews of
videos, images, extract/summary of articles, etc.

Jerome.

On Mon, Nov 22, 2010 at 2:19 PM, Ecaterina Moraru (Valica) <
vali...@gmail.com> wrote:

> Hi,
>
> There are some features that need to be investigated during the XE 2.7
> timeframe in order to be able to integrate them in XE 3.0.
> One of them is **User Statuses** and a main definition for it is: "On top
> of
> activity stream  >,
> create a User status & twitter integration feature"
>
> The question is what should we integrate and cover if we want to have user
> statuses in XE.
> In order to deploy mockups I need to have some clear requirements and uses
> cases.
> I create some pages on incubator that will gather this mail discussions at:
> Requirements:
>
> http://incubator.myxwiki.org/xwiki/bin/view/Improvements/UserStatusRequirements
> Use Cases:
> http://incubator.myxwiki.org/xwiki/bin/view/Improvements/UserStatusUseCases
>
> While discussing Activity Stream design we had some design scraps for the
> status casting part
> http://incubator.myxwiki.org/xwiki/bin/view/Improvements/UserStatusScrap
>
> Please share your vision.
> Thanks,
> Caty
> ___
> devs mailing list
> d...@xwiki.org
> http://lists.xwiki.org/mailman/listinfo/devs
>
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] [Investigation] User Statuses

[Ecaterina Moraru (Valica)]

On Mon, Nov 22, 2010 at 15:19, Ecaterina Moraru (Valica)
wrote:

> Hi,
>
> There are some features that need to be investigated during the XE 2.7
> timeframe in order to be able to integrate them in XE 3.0.
> One of them is **User Statuses** and a main definition for it is: "On top
> of activity stream,
> create a User status & twitter integration feature"
>
> The question is what should we integrate and cover if we want to have user
> statuses in XE.
> In order to deploy mockups I need to have some clear requirements and uses
> cases.
> I create some pages on incubator that will gather this mail discussions at:
> Requirements:
> http://incubator.myxwiki.org/xwiki/bin/view/Improvements/UserStatusRequirements
> Use Cases:
> http://incubator.myxwiki.org/xwiki/bin/view/Improvements/UserStatusUseCases
>
> While discussing Activity Stream design we had some design scraps for the
> status casting part
> http://incubator.myxwiki.org/xwiki/bin/view/Improvements/UserStatusScrap
>
> Please share your vision.
>
>
Hi,

Some questions I have:
- is it worth it to make our own status casting or can we use directly the
Twitter API?
-- do we plan to integrate other services beside Twitter in the future?
-- if we have our own service, do we plan to display Twitter logo to
identify Twitter entries?
- what are the actions other users can make on a user status?
-- They can comment/respond to it? right away or in the status page?
-- Can they like it?
-- Can they attach something to it?
- what actions should the casting box have?
-- The user can enter just characters?
-- How many chars?
-- Can he upload a file?
- what is the visibility of user statuses?
-- are they available for anyone with view/edit right?
- what is the location where we display the status?
-- Home Activity Stream?
-- User Profile?
-- special gadget/macro?
-- future: his vcard?
http://incubator.myxwiki.org/xwiki/bin/download/Improvements/AvatarsProposal/vcard.png

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

[xwiki-users] [Investigation] User Statuses

[Ecaterina Moraru (Valica)]

Hi,

There are some features that need to be investigated during the XE 2.7
timeframe in order to be able to integrate them in XE 3.0.
One of them is **User Statuses** and a main definition for it is: "On top of
activity stream ,
create a User status & twitter integration feature"

The question is what should we integrate and cover if we want to have user
statuses in XE.
In order to deploy mockups I need to have some clear requirements and uses
cases.
I create some pages on incubator that will gather this mail discussions at:
Requirements:
http://incubator.myxwiki.org/xwiki/bin/view/Improvements/UserStatusRequirements
Use Cases:
http://incubator.myxwiki.org/xwiki/bin/view/Improvements/UserStatusUseCases

While discussing Activity Stream design we had some design scraps for the
status casting part
http://incubator.myxwiki.org/xwiki/bin/view/Improvements/UserStatusScrap

Please share your vision.
Thanks,
Caty
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] Attachments lost !

[Sergiu Dumitriu]

On 11/22/2010 11:20 AM, Piotr Dziubecki wrote:
> Hi Ricardo,
>
> W dniu 10-11-19 19:37, Ricardo Rodriguez [eBioTIC.] wrote:
>> Hi Piotr,
>>
>> Piotr Dziubecki wrote:
>>> Hi,
>>>
>>> today I've noticed that something bad had happen to some of the attachments 
>>> in my XWiki, here is a
>>> screenshot from one of the affected pages:
>>>
>>> http://i.imgur.com/p6Xs7.png
>>>
>>> Take a look, a couple of attachments have been uploaded but only one is 
>>> displayed in the attachment tab.
>>> Person who uploaded them claims that yesterday they were ok, but today 
>>> somehow they disappeared.
>>>
>>> It's weird that there is no trace of any operation on them after the 
>>> uploading phase.
>>>
>>> I'm using XWiki Enterprise 2.5.32127 with MySQL data base (Server version   
>>> 5.1.47).
>>>
>>> To add more context, last days my users started to add more attachements to 
>>> their pages. Currently the
>>> database after the dump is around 200 MB large.
>>>
>>> Also looked at the logs and found several interesting fragments ( all of 
>>> the log snippets are from the time
>>> this have been noticed ):
>>>
>>> 2010-11-18 09:03:09,355
>>> [http://apps.man.poznan.pl:28181/xwiki/bin/download/Documents/Proposals/2009AUGURISProposalBPartSubmission.pdf?width=1262]
>>> ERROR web.XWikiAction - Connection aborted
>>> Found a TextHeaderAtom not followed by a TextBytesAtom or TextCharsAtom: 
>>> Followed by 3999
>>> Found a TextHeaderAtom not followed by a TextBytesAtom or TextCharsAtom: 
>>> Followed by 3999
>>> Found a TextHeaderAtom not followed by a TextBytesAtom or TextCharsAtom: 
>>> Followed by 3999
>>> Found a TextHeaderAtom not followed by a TextBytesAtom or TextCharsAtom: 
>>> Followed by 3999
>>> 2010-11-18 13:23:53,118 
>>> [http://localhost:28181/xwiki/bin/view/Projects/Opinion+Mining] WARN
>>> xwiki.MyPersistentLoginManager  - Login cookie validation hash mismatch! 
>>> Cookies have been tampered with
>>> 2010-11-18 13:23:53,119 
>>> [http://localhost:28181/xwiki/bin/view/Projects/Opinion+Mining] WARN
>>> xwiki.MyPersistentLoginManager  - Login cookie validation hash mismatch! 
>>> Cookies have been tampered with
>>> Found a TextHeaderAtom not followed by a TextBytesAtom or TextCharsAtom: 
>>> Followed by 3999
>>> Found a TextHeaderAtom not followed by a TextBytesAtom or TextCharsAtom: 
>>> Followed by 3999
>>> Found a TextHeaderAtom not followed by a TextBytesAtom or TextCharsAtom: 
>>> Followed by 3999
>>> Found a TextHeaderAtom not followed by a TextBytesAtom or TextCharsAtom: 
>>> Followed by 3999
>>> 2010-11-18 13:57:55,471 [Lucene Index Updater] WARN  lucene.AttachmentData  
>>>  - error getting content
>>> of attachment [2009BEinGRIDwow2greenCONTEXTREVIEW.PPT] for document 
>>> [xwiki:Documents.Presentations]
>>> org.apache.tika.exception.TikaException: TIKA-198: Illegal IOException from
>>> org.apache.tika.parser.microsoft.officepar...@72be25d1
>>>at 
>>> org.apache.tika.parser.CompositeParser.parse(CompositeParser.java:138)
>>>at 
>>> org.apache.tika.parser.AutoDetectParser.parse(AutoDetectParser.java:99)
>>>at org.apache.tika.Tika.parseToString(Tika.java:267)
>>>at 
>>> com.xpn.xwiki.plugin.lucene.AttachmentData.getContentAsText(AttachmentData.java:161)
>>>at 
>>> com.xpn.xwiki.plugin.lucene.AttachmentData.getFullText(AttachmentData.java:136)
>>>at 
>>> com.xpn.xwiki.plugin.lucene.IndexData.getFullText(IndexData.java:190)
>>>at 
>>> com.xpn.xwiki.plugin.lucene.IndexData.addDataToLuceneDocument(IndexData.java:146)
>>>at 
>>> com.xpn.xwiki.plugin.lucene.AttachmentData.addDataToLuceneDocument(AttachmentData.java:65)
>>>at 
>>> com.xpn.xwiki.plugin.lucene.IndexUpdater.addToIndex(IndexUpdater.java:296)
>>>at 
>>> com.xpn.xwiki.plugin.lucene.IndexUpdater.updateIndex(IndexUpdater.java:237)
>>>at 
>>> com.xpn.xwiki.plugin.lucene.IndexUpdater.runMainLoop(IndexUpdater.java:171)
>>>at 
>>> com.xpn.xwiki.plugin.lucene.IndexUpdater.runInternal(IndexUpdater.java:153)
>>>at 
>>> com.xpn.xwiki.util.AbstractXWikiRunnable.run(AbstractXWikiRunnable.java:99)
>>>at java.lang.Thread.run(Thread.java:662)
>>> Caused by: java.io.IOException: Cannot remove block[ 4209 ]; out of range[ 
>>> 0 - 3804 ]
>>>at 
>>> org.apache.poi.poifs.storage.BlockListImpl.remove(BlockListImpl.java:98)
>>>at 
>>> org.apache.poi.poifs.storage.RawDataBlockList.remove(RawDataBlockList.java:32)
>>>at 
>>> org.apache.poi.poifs.storage.BlockAllocationTableReader.(BlockAllocationTableReader.java:99)
>>>at 
>>> org.apache.poi.poifs.filesystem.POIFSFileSystem.(POIFSFileSystem.java:164)
>>>at 
>>> org.apache.tika.parser.microsoft.OfficeParser.parse(OfficeParser.java:74)
>>>at 
>>> org.apache.tika.parser.CompositeParser.parse(CompositeParser.java:132)
>>>... 13 more
>>> Found a TextHeader

[xwiki-users] [ANN] XWiki Enterprise and XWiki Enterprise Manager 2.6 Released

[Vincent Massol]

The XWiki development team is pleased to announce the release of XWiki 
Enterprise and XWiki Enterprise Manager 2.6.

Go grab them at http://www.xwiki.org/xwiki/bin/view/Main/Download

Changes from XE 2.6:

* Revamped Recent Activity Dashboard, which is now called Activity Stream
* Share page by mail feature
* Icon/Emoticon Support
* Auto linking of WikiWords
* New Activity Macro

For more information see the Release notes at:
http://www.xwiki.org/xwiki/bin/view/Main/ReleaseNotesXWikiEnterprise26
And
http://www.xwiki.org/xwiki/bin/view/Main/ReleaseNotesXEM26

Thanks
-The XWiki dev team
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] Attachments lost !

[Piotr Dziubecki]

Hi Ricardo,

W dniu 10-11-19 19:37, Ricardo Rodriguez [eBioTIC.] wrote:
> Hi Piotr,
>
> Piotr Dziubecki wrote:
>> Hi,
>>
>> today I've noticed that something bad had happen to some of the attachments 
>> in my XWiki, here is a
>> screenshot from one of the affected pages:
>>
>> http://i.imgur.com/p6Xs7.png
>>
>> Take a look, a couple of attachments have been uploaded but only one is 
>> displayed in the attachment tab.
>> Person who uploaded them claims that yesterday they were ok, but today 
>> somehow they disappeared.
>>
>> It's weird that there is no trace of any operation on them after the 
>> uploading phase.
>>
>> I'm using XWiki Enterprise 2.5.32127 with MySQL data base (Server version
>> 5.1.47).
>>
>> To add more context, last days my users started to add more attachements to 
>> their pages. Currently the
>> database after the dump is around 200 MB large.
>>
>> Also looked at the logs and found several interesting fragments ( all of the 
>> log snippets are from the time
>> this have been noticed ):
>>
>> 2010-11-18 09:03:09,355
>> [http://apps.man.poznan.pl:28181/xwiki/bin/download/Documents/Proposals/2009AUGURISProposalBPartSubmission.pdf?width=1262]
>> ERROR web.XWikiAction - Connection aborted
>> Found a TextHeaderAtom not followed by a TextBytesAtom or TextCharsAtom: 
>> Followed by 3999
>> Found a TextHeaderAtom not followed by a TextBytesAtom or TextCharsAtom: 
>> Followed by 3999
>> Found a TextHeaderAtom not followed by a TextBytesAtom or TextCharsAtom: 
>> Followed by 3999
>> Found a TextHeaderAtom not followed by a TextBytesAtom or TextCharsAtom: 
>> Followed by 3999
>> 2010-11-18 13:23:53,118 
>> [http://localhost:28181/xwiki/bin/view/Projects/Opinion+Mining] WARN
>> xwiki.MyPersistentLoginManager  - Login cookie validation hash mismatch! 
>> Cookies have been tampered with
>> 2010-11-18 13:23:53,119 
>> [http://localhost:28181/xwiki/bin/view/Projects/Opinion+Mining] WARN
>> xwiki.MyPersistentLoginManager  - Login cookie validation hash mismatch! 
>> Cookies have been tampered with
>> Found a TextHeaderAtom not followed by a TextBytesAtom or TextCharsAtom: 
>> Followed by 3999
>> Found a TextHeaderAtom not followed by a TextBytesAtom or TextCharsAtom: 
>> Followed by 3999
>> Found a TextHeaderAtom not followed by a TextBytesAtom or TextCharsAtom: 
>> Followed by 3999
>> Found a TextHeaderAtom not followed by a TextBytesAtom or TextCharsAtom: 
>> Followed by 3999
>> 2010-11-18 13:57:55,471 [Lucene Index Updater] WARN  lucene.AttachmentData   
>> - error getting content
>> of attachment [2009BEinGRIDwow2greenCONTEXTREVIEW.PPT] for document 
>> [xwiki:Documents.Presentations]
>> org.apache.tika.exception.TikaException: TIKA-198: Illegal IOException from
>> org.apache.tika.parser.microsoft.officepar...@72be25d1
>>   at 
>> org.apache.tika.parser.CompositeParser.parse(CompositeParser.java:138)
>>   at 
>> org.apache.tika.parser.AutoDetectParser.parse(AutoDetectParser.java:99)
>>   at org.apache.tika.Tika.parseToString(Tika.java:267)
>>   at 
>> com.xpn.xwiki.plugin.lucene.AttachmentData.getContentAsText(AttachmentData.java:161)
>>   at 
>> com.xpn.xwiki.plugin.lucene.AttachmentData.getFullText(AttachmentData.java:136)
>>   at 
>> com.xpn.xwiki.plugin.lucene.IndexData.getFullText(IndexData.java:190)
>>   at 
>> com.xpn.xwiki.plugin.lucene.IndexData.addDataToLuceneDocument(IndexData.java:146)
>>   at 
>> com.xpn.xwiki.plugin.lucene.AttachmentData.addDataToLuceneDocument(AttachmentData.java:65)
>>   at 
>> com.xpn.xwiki.plugin.lucene.IndexUpdater.addToIndex(IndexUpdater.java:296)
>>   at 
>> com.xpn.xwiki.plugin.lucene.IndexUpdater.updateIndex(IndexUpdater.java:237)
>>   at 
>> com.xpn.xwiki.plugin.lucene.IndexUpdater.runMainLoop(IndexUpdater.java:171)
>>   at 
>> com.xpn.xwiki.plugin.lucene.IndexUpdater.runInternal(IndexUpdater.java:153)
>>   at 
>> com.xpn.xwiki.util.AbstractXWikiRunnable.run(AbstractXWikiRunnable.java:99)
>>   at java.lang.Thread.run(Thread.java:662)
>> Caused by: java.io.IOException: Cannot remove block[ 4209 ]; out of range[ 0 
>> - 3804 ]
>>   at 
>> org.apache.poi.poifs.storage.BlockListImpl.remove(BlockListImpl.java:98)
>>   at 
>> org.apache.poi.poifs.storage.RawDataBlockList.remove(RawDataBlockList.java:32)
>>   at 
>> org.apache.poi.poifs.storage.BlockAllocationTableReader.(BlockAllocationTableReader.java:99)
>>   at 
>> org.apache.poi.poifs.filesystem.POIFSFileSystem.(POIFSFileSystem.java:164)
>>   at 
>> org.apache.tika.parser.microsoft.OfficeParser.parse(OfficeParser.java:74)
>>   at 
>> org.apache.tika.parser.CompositeParser.parse(CompositeParser.java:132)
>>   ... 13 more
>> Found a TextHeaderAtom not followed by a TextBytesAtom or TextCharsAtom: 
>> Followed by 3999
>> Found a TextHeaderAtom not followed by a TextBytesAtom or TextCharsAtom: 
>> Followed by 3999
>> F

Re: [xwiki-users] Attachments lost !

[Piotr Dziubecki]

Hi Caleb,

here's the output according to your query, it's related with the maximum size 
of the attachement, I've fixed 
that ( in the mysql configuration ) one day before the accident.

2010-11-17 14:12:24,514 
[http://localhost:28181/xwiki/bin/upload/Documents/media_library] WARN 
util.JDBCExceptionReporter  - SQL Error: 0, SQLState: S1000
2010-11-17 14:12:24,514 
[http://localhost:28181/xwiki/bin/upload/Documents/media_library] ERROR 
util.JDBCExceptionReporter  - Packet for query is too large (39821190 > 
15728640). You can change this 
value on the server by setting the max_allowed_packet' variable.
2010-11-17 14:12:24,515 
[http://localhost:28181/xwiki/bin/upload/Documents/media_library] ERROR 
.AbstractFlushingEventListener  - Could not synchronize database state with 
session
2010-11-17 14:12:24,519 
[http://localhost:28181/xwiki/bin/upload/Documents/media_library] WARN 
web.UploadAction- Saving uploaded file failed
2010-11-17 14:12:24,522 
[http://localhost:28181/xwiki/bin/upload/Documents/media_library] ERROR 
lucene.IndexUpdater - invalid parameters given to add: 
Documents.media_library, null, 
{grouplist={xwiki:xwiki:xwiki.mag...@manpoznanpl=[xwiki:XWiki.XWikiAllGroup, 
xwiki:XWiki.Employees], 
xwiki:xwiki:XWiki.Employees=[], xwiki:xwiki:XWiki.XWikiAllGroup=[]}, 
msg=com.xpn.xwiki.web.xwikimessaget...@6a666cdc, 
fileuploadlist=[name=2007_Article_Vine_Toolkit_A_Java_framework_for_developing_Grid_Applications.pdf,
 
StoreLocation=/tmp/upload_685571e2_12bf824a150__8000_0145.tmp, 
size=19910552bytes, isFormField=false, 
FieldName=filepath], user=xwiki.mag...@manpoznanpl, language=en, 
originalWiki=xwiki, 
tdoc=Documents.media_library, locale=en, ajax=false, 
doc=Documents.media_library, mainxwiki=xwiki, 
fileuploadplugin=com.xpn.xwiki.plugin.fileupload.fileuploadplu...@6a751616, 
vcontext=org.apache.velocity.velocitycont...@2cfd34f4, wiki=xwiki}
2010-11-17 14:20:55,700 
[http://localhost:28181/xwiki/bin/upload/Documents/Articles] WARN 
util.JDBCExceptionReporter  - SQL Error: 0, SQLState: S1000
2010-11-17 14:20:55,701 
[http://localhost:28181/xwiki/bin/upload/Documents/Articles] ERROR 
util.JDBCExceptionReporter  - Packet for query is too large (39821191 > 
15728640). You can change this 
value on the server by setting the max_allowed_packet' variable.
2010-11-17 14:20:55,701 
[http://localhost:28181/xwiki/bin/upload/Documents/Articles] ERROR 
.AbstractFlushingEventListener  - Could not synchronize database state with 
session
2010-11-17 14:20:55,703 
[http://localhost:28181/xwiki/bin/upload/Documents/Articles] WARN  
web.UploadAction 
- Saving uploaded file failed
2010-11-17 14:21:53,933 
[http://localhost:28181/xwiki/bin/upload/Documents/Articles] WARN 
util.JDBCExceptionReporter  - SQL Error: 0, SQLState: S1000
2010-11-17 14:21:53,933 
[http://localhost:28181/xwiki/bin/upload/Documents/Articles] ERROR 
util.JDBCExceptionReporter  - Packet for query is too large (39821191 > 
15728640). You can change this 
value on the server by setting the max_allowed_packet' variable.
2010-11-17 14:21:53,933 
[http://localhost:28181/xwiki/bin/upload/Documents/Articles] ERROR 
.AbstractFlushingEventListener  - Could not synchronize database state with 
session
2010-11-17 14:21:53,936 
[http://localhost:28181/xwiki/bin/upload/Documents/Articles] WARN  
web.UploadAction 
- Saving uploaded file failed

W dniu 10-11-19 19:55, Caleb James DeLisle wrote:
> There had been an issue where attachments failed to save but the cache lied 
> and said they had. That
> should have been fixed for 2.5.
>
> I don't see anything in the log which helps. If you could:
> cat ./*.log | grep '/upload/'
> That might give us more information.
>
> To make sure an attachment has been stored, you have to make sure there are 2 
> components in the
> database. One is in the xwikiattachment table.
>
> Off the top of my head, here's an sql query which should return the id number 
> of the attachment and
> it's size in bytes.
>
> select attach.XWA_ID length(content.XWA_CONTENT) from xwikiattachment as 
> attach,
> xwikiattachment_content as content, xwikidocument as doc where 
> doc.XWD_FULLNAME = 'Your.Document'
> and attach.XWA_DOC_ID = doc.XWD_ID and conetne.XWA_ID = attach.XWA_ID;


We did more searches in the database looking for the corrupted attachments and 
found what follows.

There are tree tables:

xwikiattachment
xwikiattachment_archive
xwikiattachment_content

Document X that disappeared from the attachments left some traces in the db log 
( insert traces).

It seems that X is in the xwikiattachment_content  but not in  the  
xwikiattachment. In the 
xwikiattachment_content there is a foreign key to xwikiattachment  and in the 
case of corrupted files it is 
set to NULL.

Today I'll look at your sql query and search for any odd data.

Thanks,
Piotr
>
>
> Caleb
>
>
> On 11/19/2010 08:51 AM, Piotr Dziubecki wrote:
>> one more thing, we did some re

Re: [xwiki-users] Unknown macro: html after fresh install

[Marius Dumitru Florea]

Hi Lenny,

On 11/20/2010 12:09 AM, Scardino, Leonard R Jr ERDC-ITL-MS Contractor wrote:
> I'm afraid I've searched as much as I can, and cannot find an answer to this.
>

> I just did a fresh install of xwiki on Windows Server 2003,
> Apache/Tomcat(5.5.28), MySQL Server 5.1.

What version of XWiki Enterprise did you install?

> I'm getting boxes with "! Unknown macro: html".

Does this happen only with the HTML macro? Are the rest of the macros 
(e.g. velocity, groovy, info etc.) working fine?

>
> I've also installed xwiki on my laptop running XP, Tomcat(6.0.26), MySQL
> Server 5.1, and had no problems.
>
> Can someone give me an idea of what might be causing this?  I'm a java
> programmer, so I can get into nuts and bolts if necessary.  Hopefully its
> not. If I have not provided enough information, please let me know and I'll
> be happy to expound.

Are there any exceptions logged when you start the wiki or when you 
render a wiki page that includes an HTML macro?

You have xwiki-core-rendering-macro-html-x.y.jar in your WEB-INF/lib right?

Hope this helps,
Marius

>
> Thanks,
>
> Lenny
> ___
> 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