[xwiki-users] Problem installing extensions: value too long for type character varying(60000)
3 Dec
2013
3 Dec
'13
9:01 p.m.
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
4 Dec
4 Dec
4:04 p.m.
New subject: [xwiki-users] Problem installing extensions: value too long for type character varying(60000)
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
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
5 Dec
5 Dec
2:12 p.m.
New subject: [xwiki-users] Problem installing extensions: value too long for type character varying(60000)
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-l…
Sent from the XWiki- Users mailing list archive at Nabble.com.
9 Dec
9 Dec
9:59 a.m.
New subject: [xwiki-users] Problem installing extensions: value too long for type character varying(60000)
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 <jal(a)etc.to> 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-l…
Sent from the XWiki- Users mailing list archive at Nabble.com.
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
3937
days inactive
3943
days old
3 comments
3 participants
participants (3)
-
Clemens Klein-Robbenhaar -
Frits Jalvingh -
Marius Dumitru Florea