Hello, I have problem with editing documents with the new WYSIWYG editor (page syntax – XWiki 2.0) - on attempt to create a link to existing documents I get a message “There was an error loading the data” – it looks like the select from the xwikidoc table doesn’t work properly.

Log file: “Exception while searching documents with sql select distinct doc from XWikiDocument doc where 1=1 and doc.author='XWiki.Admin' order by doc.date desc” and Oracle error “ORA-00932 inconsistent datatypes”. The full log files attached.

Even so, if I switch to tab “All pages”, I can see the list of all existing pages, but cannot select any of them.

Hi Marius, thanks for your reply. I haven't tested all features yet, but on the first view it looks pretty well - I can administrate Wiki, create new groups and users and edit dokuments. AllDocs works fine too.

I'm not sure, but could it be due to the basic problem with our installalation, exactly speaking - with the filling tables while importing .xar archiv. We had some error messages in JBoss and xwiki log files - - Exception while reading document XWiki.XWikiPreferences Wrapped Exception: a different object with the same identifier value was already associated with the session: [com.xpn.xwiki.doc.XWikiDocument#104408758] and - ORA-01400: ORA-01400: cannot insert NULL into in ("XWIKI"."XWIKILARGESTRINGS"."XWL_ID") I reproduced this today again (S. attached). Despite of these errors it looked like as all documents from xar archiv were imported and I could open and edit existing pages - except of creating links using new WYSIWYG editor. Best Regards, Alla http://n2.nabble.com/file/n4561415/xwiki.log xwiki.log http://n2.nabble.com/file/n4561415/server.log server.log

Hi Marius, I tried to reproduce this situation with the new installation of the last version of XE (2.2 stable) + Oracle 10g + Tomcat. Installation and .xar import were OK – no errors. Insertion a new link in a page – the same message –“There was an error loading the data”. As I understood this message concerns not AllDocs, but the tab “My Recent Changes”, that comes as first by default while inserting link. http://n2.nabble.com/file/n4587113/wysiwyg_insert_link_myrecentchanges.jpg xwiki.log: 2010-02-17 14:10:30,125 [http://localhost:8080/xwiki/resources/js/xwiki/wysiwyg/xwe/WikiService.gwtr…] ERROR server.DefaultWikiService - Error number 3223 in 3: Exception while searching documents with sql select distinct doc from XWikiDocument doc where 1=1 and doc.author='XWiki.Admin' order by doc.date desc localhost.log: Exception while dispatching incoming RPC call com.google.gwt.user.server.rpc.UnexpectedException: Service method 'public abstract java.util.List com.xpn.xwiki.wysiwyg.client.WikiService.getRecentlyModifiedPages(int,int)' threw an unexpected exception: java.lang.RuntimeException: Failed to retrieve the lists of recently modified pages. --- However Main.RecentChanges and Panels.MyRecentModifications show the pages changed by Admin. --- Marius Dumitru Florea wrote: The both queries work fine --- I think the problem is either in “order by” or in “distinct” (Or in the combination of both of them…) I executed the similar query like in xwiki.log (select distinct doc from XWikiDocument doc where 1=1 and doc.author='XWiki.Admin' order by doc.date desc) against the xwiki-Oracle db select distinct doc.XWD_FULLNAME from xwikidoc doc where 1=1 and doc.XWD_AUTHOR='XWiki.Admin' order by doc.XWD_DATE desc and got an error ORA-01791: not a SELECTed expression, which means that "order by"- column should be selected as well (?) At the same time the query with order by expression but without distinct works fine... I have only 4 Docs, created by Admin, they are all unique and can't see any difference in the output with and without distinct... The next query with subquery works too. - select distinct XWD_FULLNAME from (select doc.XWD_FULLNAME, doc.XWD_DATE from xwikidoc doc where 1=1 and doc.XWD_AUTHOR='XWiki.Admin' order by doc.XWD_DATE desc) --- I tried also {{velocity}} $xwiki.search("select doc from XWikiDocument doc where doc.author='XWiki.Admin' order by doc.date",3,0).size() {{/velocity}} - works OK too. $xwiki.search("select distinct doc from XWikiDocument doc where doc.author='XWiki.Admin' order by doc.date",2,0) produces error “Failed to execute macro: velocity”: org.xwiki.rendering.macro.MacroExecutionException: Failed to evaluate Velocity Macro for content [ $xwiki.search("select distinct doc from XWikiDocument doc where doc.author='XWiki.Admin'").size() ] --- --- Tab “All Pages” - works fine. --- Switch to tab “Search” – arrears the same message –“There was an error loading the data” with the ORA-00932 error in the xwiki.log: 2010-02-17 15:36:49,453 [http://localhost:8080/xwiki/resources/js/xwiki/wysiwyg/xwe/WikiService.gwtr…] WARN util.JDBCExceptionReporter - SQL Error: 932, SQLState: 42000 2010-02-17 15:36:49,453 [http://localhost:8080/xwiki/resources/js/xwiki/wysiwyg/xwe/WikiService.gwtr…] ERROR util.JDBCExceptionReporter - ORA-00932: Inkonsistente Datentypen: - erwartet, CLOB erhalten 2010-02-17 15:36:49,453 [http://localhost:8080/xwiki/resources/js/xwiki/wysiwyg/xwe/WikiService.gwtr…] ERROR server.DefaultWikiService - Error number 3223 in 3: Exception while searching documents with sql select distinct doc from XWikiDocument as doc where (lower(doc.title) like '%%' or lower(doc.fullName) like '%%') Wrapped Exception: could not execute query I have no clue why it happens, because the query: select distinct XWD_FULLNAME from xwikidoc doc where (lower(doc.XWD_TITLE) like '%%' or lower(doc.XWD_FULLNAME) like '%%'); works in Oracle well. Best Regards, Alla http://n2.nabble.com/file/n4587113/localhost.2010-02-17.log localhost.2010-02-17.log http://n2.nabble.com/file/n4587113/xwiki.log xwiki.log