Hi Frits, which database are you using? I cannot reproduce this, neither with mySQL or with HSQL. It seems one of the fields in the DB is a bit too short by default. Clemens

Hi List,

I just upgraded to XWiki enterprise 5.2.1 and have trouble installing some extensions. When I try to install for instance the "Highlight Macro" extension I'm getting errors during the "install":

Applying INSTALL for extension [Highlight Macro 1.3<http://wiki.hosts.itris.nl/xwiki/bin/admin/XWiki/XWikiPreferences?extensionId=vincentmassol%3Ahighlight%2Dmacro&extensionVersion=1.3&extensionNamespace=wiki%3Axwiki&xback=%2Fxwiki%2Fbin%2Fget%2FXWiki%2FInstalledExtensions%3Fsection%3DXWiki.InstalledExtensions§ion=XWiki.InstalledExtensions>] on namespace [xwiki <http://wiki.hosts.itris.nl/xwiki/bin/view/Main/WebHome> ] Importing document [Macros.Highlight<http://wiki.hosts.itris.nl/xwiki/bin/view/Macros/Highlight>] in language [en]... SQL Error: 0, SQLState: 22001 ERROR: value too long for type character varying(60000) ERROR: value too long for type character varying(60000) Failed to import document [Macros.Highlight<http://wiki.hosts.itris.nl/xwiki/bin/view/Macros/Highlight>] in language [en] Successfully applied INSTALL for extension [Highlight Macro 1.3<http://wiki.hosts.itris.nl/xwiki/bin/admin/XWiki/XWikiPreferences?extensionId=vincentmassol%3Ahighlight%2Dmacro&extensionVersion=1.3&extensionNamespace=wiki%3Axwiki&xback=%2Fxwiki%2Fbin%2Fget%2FXWiki%2FInstalledExtensions%3Fsection%3DXWiki.InstalledExtensions§ion=XWiki.InstalledExtensions>] on namespace [xwiki <http://wiki.hosts.itris.nl/xwiki/bin/view/Main/WebHome> ]

Anyone any idea what's wrong?

Thanks,

Frits _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users

You can view the database schema here http://platform.xwiki.org/xwiki/bin/view/DevGuide/DatabaseSchema . I think the problem is that the extension author has pasted the code of a large JavaScript library in the 'code' property (of type TextArea) of a JSX object, instead of attaching the JavaScript files to one of the wiki pages from the extension. TextArea properties are saved in xwikilargestrings which has the XWL_VALUE column limited to 60000 length in xwiki.hbm.xml . Hope this helps, Marius On Thu, Dec 5, 2013 at 3:12 PM, Frits Jalvingh <[email protected]> wrote:

I'm using Postgresql and the database has been created a long time ago. The error message does not tell what column is in trouble nor which table it's in, and there seem to be several 8-/ Is there any formal schema for xwiki's database that I can compare with? Or a way to get more detailed logging where the error occurs?

Thanks, Frits

-- View this message in context: http://xwiki.475771.n2.nabble.com/Problem-installing-extensions-value-too-lo... Sent from the XWiki- Users mailing list archive at Nabble.com. _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users