Re: [epf-dev] Re: Are there any file limit for EPF wiki?(RE: epf-dev Di

[Onno van der Straaten <onno.van.der.straaten@xxxxxxxxx>]

Hi,
If you can send me a piece of the content that I can use to reproduce the problem I'm willing to investigate it further and provide a workaround of some sort.
Best Regards,
Onno

On Mon, Nov 9, 2009 at 7:25 AM, <tashiroh@xxxxxxxxxxxxx> wrote:

Dear Onno

Thank you for your comments.

I tried your proposal.
However, we can't resolve our problem.

-Encoding issue
We use MySQL5.0 in our system.
However, MySQL5.0 dosen't seem to support "UTF-16".


-The length of the file path is too long
We confirmed thata as well.
However, actually our file path isn't so long.


Anyway, thanks a lot.


> -----Original Message-----
> From: epf-dev-bounces@xxxxxxxxxxx [mailto:epf-dev-bounces@xxxxxxxxxxx]
> On Behalf Of epf-dev-request@xxxxxxxxxxx
> Sent: Saturday, November 07, 2009 2:00 AM
> To: epf-dev@xxxxxxxxxxx
> Subject: epf-dev Digest, Vol 47, Issue 3
>
> Send epf-dev mailing list submissions to
>       epf-dev@xxxxxxxxxxx
>
> To subscribe or unsubscribe via the World Wide Web, visit
>       https://dev.eclipse.org/mailman/listinfo/epf-dev
> or, via email, send a message with subject or body 'help' to
>       epf-dev-request@xxxxxxxxxxx
>
> You can reach the person managing the list at
>       epf-dev-owner@xxxxxxxxxxx
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of epf-dev digest..."
>
>
> Today's Topics:
>
>    1. Re: Are there any file limit for EPF wiki? (Onno van der Straaten)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Thu, 5 Nov 2009 21:37:21 +0100
> From: Onno van der Straaten <onno.van.der.straaten@xxxxxxxxx>
> Subject: Re: [epf-dev] Are there any file limit for EPF wiki?
> To: Eclipse Process Framework Project Developers List
>       <epf-dev@xxxxxxxxxxx>
> Message-ID:
>       <be8e7a530911051237q3254c599j9dc04ab7b7958365@xxxxxxxxxxxxxx>
> Content-Type: text/plain; charset="utf-8"
>
> Hi,
> I don't think the folder size is a problem, I have used similar sizes before
> without problems.
>
> Based on the error message I can think of two reasons for the error message
>
>    1. some character set encoding issue or
>    2. the length of the file path is too long.
>
> I'm not sure about the encoding. For 2-byte Japanese char set you need
> utf16, not utf8?
>
> I haven't tried this but maybe you could try set the encoding to utf16?
> In *
> config/database.yml* there should be a line *encoding: utf8* for your
> environment. Is it possible to set that to *utf16* and try again to create
> your database? I don't have utf16 on my machine so I can't test right now
> if
> this will work.
>
> You have to recreate your database of course, assuming your environment
> is
> 'production'.
>
> On Windows:
> set RAILS_ENV=production
> rake db:drop db:create db:migrate
>
> On Linux
> export RAILS_ENV=production
> rake db:drop db:create db:migrate
>
> I have to point out however that the rel_path column is varchar 220, for
> utf16 this would imply a max file path length of 55 characters? Again, I'm
> not sure, but it might turn out that the column max length is too short
> if
> you set to utf16 to hold the relative paths of your files.
> HTH,
> Onno
>
> 2009/11/5 <tashiroh@xxxxxxxxxxxxx>
>
> > Dear all,
> >
> > Are there any file limit such as file size or Character Size for creating
> > wiki or using the EPF wiki?
> >
> > Now, we have trouble in [Creating a Wiki].
> > We select the baseline(folder) that has following features to update.
> >  - Including the file which name is 2-byte.
> >  - Folder size is bigger than 250MB (not zip)
> >
> > After we select the baseline and select [update now],
> > we got following message.
> >
> > Mysql::Error: Incorrect string value: '\x83V\x83X\x83e...' for column
> > 'rel_path' at row 1: INSERT INTO `pages` (`body_tag`, `created_on`,
> > `rel_path`, `status`, `site_id`, `text`, `tool`, `updated_on`, `type`,
> > `head_tag`, `presentation_name`, `uma_name`, `copyright_tag`,
> `filename`,
> > `user_id`, `treebrowser_tag`, `uma_type`) VALUES('
> > ', '2009-11-04 18:06:23', '(PATH / xxxx_58AE806C.html', 'N.A.', 13, NULL,
> > 'EPFC', '2009-11-04 18:06:23', 'BaselineProcessPage',
> > '\n\n\n\n\n\n\n\n\n\n\n', 'ＡＡＡＡＡＹＹＹ [ＹＹ]', 'ＡＡＡＡＡ', '',
> > 'xxxx_58AE806C.html', NULL, '', 'WorkProductDescriptor')
> >
> >  [*] A, Y; 2byte character
> >  Actually, [ＡＡＡＡＡ', '', 'xxxx_58AE806C.html] was one string
> > [ＡＡＡＡＡ_58AE806C.html]
> >
> >
> > We tried following cases.
> >
> > 1.One task process(1MB folder). File-name of all files are English. All
> > contents in the all file are also English perfectly.
> >  -Success
> >
> > 2.One task process(1MB folder). One file-name is
> Japanese(2byte-character).
> > All contents in the all file are also English perfectly.
> >  -Error. [That message was generated.]
> >
> > 3.One task process(1MB folder). File-name of all files are English. One
> > content(link information) is Japanese(2byte-character like  --/ＢＢ
> Ｂ.html).
> >  -Success
> >
> > 4.250MB folder. File-name of all files are English. All contents in the
> all
> > file are also English perfectly.
> >  -Error(500 Internal Server Error)
> >
> >
> > [Environment]
> > Apache 1.3.41
> > EPF wiki epfwiki_r1_5_20081021_0316.zip
> > Ruby 1.8.6
> > MySQL 5.0
> >  Encoding ; "utf8 "
> > _______________________________________________
> > epf-dev mailing list
> > epf-dev@xxxxxxxxxxx
> > https://dev.eclipse.org/mailman/listinfo/epf-dev
> >
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:
> https://dev.eclipse.org/mailman/private/epf-dev/attachments/20091105/d
> fb52707/attachment.html
>
> ------------------------------
>
> _______________________________________________
> epf-dev mailing list
> epf-dev@xxxxxxxxxxx
> https://dev.eclipse.org/mailman/listinfo/epf-dev
>
>
> End of epf-dev Digest, Vol 47, Issue 3
> **************************************

_______________________________________________
epf-dev mailing list
epf-dev@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/epf-dev