[xwiki-users] Import xwiki-1.0-beta-4.xar errors!

[Rudolf van der Leeden]

Hi Xin,

the main problem for using PostgreSQL and XWiki is the correct  
mapping of the data types of MySQL to Postgres.
This has been addressed in my posting on Feb.07 titled:
    XWiki 0.9 to 1.0Beta Postgres Database Upgrade using DATA only
I couldn't find it in the mail archive (don't know why) and therefore  
will repost it in a few minutes.

Regards,
Rudolf van der Leeden


On Mar 5, 2007, at 10:36 AM, Vincent Massol wrote:

>
> On Mar 5, 2007, at 10:30 AM, xin wu wrote:
>
>> Hi,
>>
>>  Thanks to all of you. The errors are due to limitation of the xml  
>> doc table
>> (I just do what Paul said: change the limitation of xwd_class_xml in
>> xml doc table from 20000 to 200000, I also change xwd_archive from
>> 200000 to 2000000). Then the installation seemed OK except that
>> preference page is locked by XWikiGuest(You can just edit it by
>> force). I think it will be better to mention the size limitation in
>> the guide.
>
> Yes that's a good idea. Can you do it?
>
> Thanks
> -Vincent
>
>> Many thanks again.
>>
>> On 3/5/07, Sergiu Dumitriu <sergiu.dumitriu at gmail.com> wrote:
>>>
>>> On 3/5/07, Vincent Massol <vincent at massol.net> wrote:
>>> >
>>> >
>>> >
>>> >
>>> > On Mar 5, 2007, at 8:46 AM, Sergiu Dumitriu wrote:
>>> >
>>> > I don't think it's related to XWIKI-530, since the import works  
>>> for most
>>> pages, except the specified 2.
>>> >
>>> > Indeed, importing the XWikiPreferences page causes an error.  
>>> The page is
>>> deleted, but not imported back.
>>> >
>>> >
>>> > Sergiu, is this a regression? I've never had this problem with the
>>> XWikiPreferences page. Do we have a jira for it? Is it fixed in  
>>> Beta 5?
>>>
>>> Here's the error I got (yesterday, so b5 doesn't fix it):
>>>
>>> 13:27:30,130 [TP-Processor6] WARN   
>>> util.JDBCExceptionReporter      - SQL
>>> Error: 1062, SQLState: 23000
>>> 13:27:30,132 [TP-Processor6] ERROR util.JDBCExceptionReporter      -
>>> Duplicate entry '-944455444-tags' for key 1
>>> 13:27:30,133 [TP-Processor6]  
>>> ERROR .AbstractFlushingEventListener  - Could
>>> not synchronize database state with session
>>> org.hibernate.exception.ConstraintViolationException :
>>> could not insert: [com.xpn.xwiki.objects.IntegerProperty]
>>>         at
>>> org.hibernate.exception.SQLStateConverter.convert 
>>> (SQLStateConverter.java:69)
>>>
>>>
>>> So it's a duplicate key issue.
>>>
>>>
>>>  --
>>> http://purl.org/net/sergiu
>>>
>>> --
>>> You receive this message as a subscriber of the xwiki- 
>>> users at objectweb.org
>>> mailing list.
>>> To unsubscribe:
>>> mailto:xwiki-users-unsubscribe at objectweb.org
>>> For general help: mailto:sympa at objectweb.org?subject=help
>>> ObjectWeb mailing lists service home page: http:// 
>>> www.objectweb.org/wws
>>>
>>>
>>
>>
>> -- 
>>
>>
>>                                    Best regards,
>>                                          Xin
>>
>>
>> --
>> You receive this message as a subscriber of the xwiki- 
>> users at objectweb.org mailing list.
>> To unsubscribe: mailto:xwiki-users-unsubscribe at objectweb.org
>> For general help: mailto:sympa at objectweb.org?subject=help
>> ObjectWeb mailing lists service home page: http:// 
>> www.objectweb.org/wws
>
>
>
> --
> You receive this message as a subscriber of the xwiki- 
> users at objectweb.org mailing list.
> To unsubscribe: mailto:xwiki-users-unsubscribe at objectweb.org
> For general help: mailto:sympa at objectweb.org?subject=help
> ObjectWeb mailing lists service home page: http://www.objectweb.org/ 
> wws

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.xwiki.org/pipermail/users/attachments/20070305/cea3ad4d/attachment-0001.html