I've solved the problem I asked about yesterday: Column length too big for
column 'XXX' (max = 21845); use BLOB or TEXT instead
There is a useful option in MySQL Migration Tool to change the SQL code for
table creation, so I've just used LONGTEXT instead of VARCHAR(60000) and
alike which are not valid for MySQL.
Additionally I needed to fix several dates in XWIKIDATES like 2222-04-16
00:00:00 into 2012... - no idea why they were treated as invalid...
Could someone also hint about consequences of several errors I wasn't able
to solve? May be they can be solved as well?
1. For XWIKIATTACHMENT_ARCHIVE I got 0 of 20 entries transferred, with
an error "Unknown column '0x' in 'field list'". Indeed in .script file I
see them like this: INSERT INTO XWIKIATTACHMENT_ARCHIVE
VALUES(-2145604653,''). I believe it's safe to ignore this? But how did it
happen?
2. Same error for XWIKIATTACHMENT_CONTENT, but there only one row should
have been deleted - may I got problems because of this?
Will community benefit from description of such HSQLDB->MySQL migration or
was it a non-trivial thing for me only (I only faced databases during
university course)? :) If yes where can I add it?
Andrey
Hi,
i want to have our wiki categorized, since it's used as a intranet for a
company with a few different work groups. So it would be the best if
every group gets its own "category", but every coworker is able to see
(and possibly edit) every page. But i'm not sure what's the best way to
do this, i think the two possibilities are to use different spaces or to
use parent pages.
Can you tell me what the main differences are to help me with this
decision? Is it only the rights management or are there any other
advantages/disadvantages?
Thanks again,
resi.
Hello,
for our company intranet wiki i'd like to have a page where all
coworkers are listed with their names and pictures. I found a velocity
code to give out the useravatar (e.g. #largeUserAvatar('XWiki.username')
), but is there a way to automatically generate a page where all the
users are listed with names and pictures (perhaps in 2 columns and with
links to their profile pages)? I only found a way to list all editors or
page creators.
And second, i would like to add information to the profile pages of the
coworkers, e.g. their specialities or responsibilities. How can i do that?
Thanks in advance,
resi.
Hi,
I want to apply a specicific set of rules to password policy in xwiki so
that that if any new user/existing user(in case he want to change the
existing password)
adhere to this policy. Some of the rules are like :-
1)Password should have following charectics
A minimum password length of fourteen (12) characters
Contain at least one alpha characters (a-z, A-Z).
Contain at least one Upper Case Alpha character (A-Z).
Contain at least one numeric character (0-9).
Contain at least one “special” character, such as the following:~ ` ! @ #
$ % ’
The maximum number of failed login attempts shall be set to 3.
2)Passwords are required to be changed every 30 days
3)A password history of last 13 passwords must be maintained so that new
password is not among last 13 passwords
4)Where any user account has been locked out, admin should be subject to
reset the password
My first question is about point 1 . I can see one way to modify
registration password matching regex at
http://wikiURL/myWiki/bin/edit/XWiki/Registration?editor=wiki
so that i can change default policy from 6 character to customized policy
as per point 1. Is there any other way to from user interface ?
Second point is i don't see any configuration setting to fulfil the
requirements 2,3 and 4. Does xwiki support this kind of configuration too?
The XWiki development team is proud to announce the availability of
XWiki Commons, XWiki Rendering, XWiki Platform, XWiki Enterprise and
XWiki Enterprise Manager 3.4.
XWiki Enterprise 3.4 is a stabilization release as we're approaching
the end of the 3.x cycle so its main goal was to improve the Extension
Manager and App Within Minutes features. However, this release also
comes with a new look and a new default wiki page syntax. The
highlights of this release are:
* New color themes
* XWiki 2.1 is the default page syntax
* Improved Extension Manager UI
* Delete space menu
* Simple space templates
* Special characters in attachment file names
* Minimized action menu
* Display macro
See the full release notes at
http://www.xwiki.org/xwiki/bin/view/ReleaseNotes/ReleaseNotesXWikiEnterpris…
for more details.
Thanks
-The XWiki dev team
Hi guys.
Let met describe you my problem.
I get the rendered content of a document on a velocity script :
#set($newsletterContent = $newsletterContentDoc.getRenderedContent())
But I would like to specify the language I want ('fr' or 'en') because my
document contains translation keys.
Of course, I tried to use Document.getTranslatedDocument() before rendering
it, but it doesn't work, maybe because my translated content is inside a
velocity script of the document.
The best way would be having a language parameter into getRenderedContent()
function but since we can't, is there an easy way to do it?
--
I also tried to do this :
#set($newsletterContent =
$xwiki.getURLContent($newsletterContentDoc.getExternalURL('get','outputSyntax=plain&language=fr')))
but it is very dirty and doesn't work since the wiki ask for credentials
when I do getURLContent().
--
Thx a lot.
Guillaume
I got a new computer and want to move my old Xwiki instance. I've exported
an .xar file on the old system and downloaded the installer and run it on
the new computer, but when I attempt to launch it I get a console window
that appears very briefly with three Access denied lines and a stack trace
that closes before I can see much more than that.
So first, does that suggest an obvious problem that's already well-known?
And if not, does the startup process generate a logfile somewhere that I
could analyze?
My system is a 64-bit Windows 7 Enterprise i5-2400 CPU with 16.0 GB of
memory.
Any assistance would be much appreciated. I use my Xwiki all the time and
don't want to lose all my history.
Thanks,
Matthew
Thanks for all who replied to my initial request. I've followed the advice
and tried MySQL.
I have heard about problems with xar export/import and would like to avoid
it if naked DB migration is possible. I've googled up what seems a
righteous way using MySQL Migration Toolkit (here are 2 links:
http://confluence.atlassian.com/display/DOC/Migrating+from+HSQLDB+to+MySQL,
http://wiki.alfresco.com/wiki/Migrating_from_HSQL).
After some exercises to make jdbc driver work I've got database exported
but run into problems with particular columns because of which complete
tables are not copied to MySQL. Below is an excerpt from report where for
problematic tables evil columns are mentioned:
`PUBLIC`.`XWIKICLASSES`
Column length too big for column 'XWO_CUSTOM_MAPPING' (max = 21845); use
BLOB or TEXT instead
`PUBLIC`.`XWIKICLASSESPROP`
Column length too big for column 'XWP_CUSTOMDISPLAY' (max = 21845); use
BLOB or TEXT instead
`PUBLIC`.`XWIKICOMMENTS`
Column length too big for column 'XWC_HIGHLIGHT' (max = 21845); use BLOB or
TEXT instead
`PUBLIC`.`XWIKIDOC`
Column length too big for column 'XWD_CONTENT' (max = 21845); use BLOB or
TEXT instead
`PUBLIC`.`XWIKILARGESTRINGS`
Column length too big for column 'XWL_VALUE' (max = 21845); use BLOB or
TEXT instead
`PUBLIC`.`XWIKIPREFERENCES`
Column length too big for column 'XWP_MENU' (max = 21845); use BLOB or TEXT
instead
Is there a way to cope with this or the only way is export/import with
Large Wiki Export extension?
Thx,
Andrey
Here: http://dev.xwiki.org/xwiki/bin/view/Community/Building
As in ..
"Checking out the sources
Use your favorite Subversion client to check out the sources.
You can check out the whole source tree or only a single module you wish to
build. Maven2 is powerful enough in that it'll always try to download the
required dependencies from the remote repositories you have defined, so that
you don't have to build the whole project from sources."
-----Original Message-----
From: users-bounces(a)xwiki.org [mailto:users-bounces@xwiki.org] On Behalf Of
goldring, richard
Sent: 06 February 2012 17:15
To: 'XWiki Users'
Subject: Re: [xwiki-users] Linking
Thankyou Marius - I'll have a look at this when I find some free time - I'm
a little snowed under at work at the moment!
-----Original Message-----
From: users-bounces(a)xwiki.org [mailto:users-bounces@xwiki.org] On Behalf Of
Marius Dumitru Florea
Sent: 06 February 2012 17:08
To: XWiki Users
Subject: Re: [xwiki-users] Linking
On Fri, Feb 3, 2012 at 4:36 PM, Hamster <teunham(a)hotmail.com> wrote:
> +1
I've created
https://github.com/xwiki/xwiki-platform/tree/feature-alfresco-link
. Checkout
https://github.com/xwiki/xwiki-platform/blob/feature-alfresco-link/xwiki-pla
tform-core/xwiki-platform-wysiwyg/README.txt
and the
https://github.com/xwiki/xwiki-platform/blob/feature-alfresco-link/xwiki-pla
tform-core/xwiki-platform-wysiwyg/xwiki-platform-wysiwyg-server/src/main/jav
a/org/xwiki/wysiwyg/server/internal/plugin/alfresco/XWikiAlfrescoService.jav
a
as an example implementation of the service that is used to browse the tree
structure (e.g. file system).
You could start by cloning xwiki-platform GitHub repo, checkout the
feature-alfresco-link branch, change XWikiAlfrescoService to return
information about the network file system, build the WYSIWYG editor modules
and update the WYSIWYG editor of your XE instance.
Updating the WYSIWYG editor usually means:
* overwrite the server and shared jar in WEB-INF/lib
* delete resources/js/xwiki/wysiwyg/xwe folder and copy the same folder from
the wysiwyg war
>
> I think this should be part of the "Link" WYSIWYG editor!
>
> I don't have the knowledge to modify the source-code, but I do the
> advantage to modify the source-code (or implement a copy). We have
> developed several ClickOnce Applications for internal company use,
> which accept URL-parameters. I would love to extend the "Link" menu,
> so people can choose "Link to ClickOnceApp", supply the
> URL-parameter(s) and XWiki will generate the correct link!
>
> Is there a step-by-step tutorial on how to modify the
> WYSIWYG-editor??? (I know, whishful thinking!)
Unfortunately no.
Hope this helps,
Marius
>
> --
> View this message in context:
> http://xwiki.475771.n2.nabble.com/Linking-tp7247202p7250922.html
> 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
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users