<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Thanks again Jiadi!<br>
<br>
<i>When I do:</i><br>
SELECT default_character_set_name FROM information_schema.SCHEMATA
WHERE schema_name = "eprints_db_name";<br>
<br>
<i>I get:</i><br>
default_character_set_name: latin1<br>
<br>
<i>But when I do:</i><br>
show table status from eprints_db_name;<br>
<br>
<i>I get:</i><br>
Collation: utf8_general_ci<br>
<br>
<i>Knowing this, it enough for me to do the following?</i><br>
ALTER DATABASE eprints_db_name CHARACTER SET utf8 COLLATE
utf8_general_ci;<br>
<br>
It seems that it would be quite time consuming to convert every
single table in the EPrints DB one by one.<br>
<br>
Actually I have never upgraded EPrints, I installed EPrints 3.3.12
through apt-get on Ubuntu Server 10.04 LTS and then transfered the
DB and files to Ubuntu Server 12.04 LTS, when my VPS provider
upgraded their systems. I followed this guide, I don't know if that
is where the db confusion began.<br>
<a class="moz-txt-link-freetext" href="http://wiki.eprints.org/w/Moving_a_repository">http://wiki.eprints.org/w/Moving_a_repository</a><br>
<br>
Thanks a lot for your help!<br>
<br>
<div class="moz-cite-prefix">On 07-08-2014 11:42, Jiadi Yao wrote:<br>
</div>
<blockquote
cite="mid:EMEW3|67cb63d6f49f8e1eabb5014ab98bd54aq76AiZ14eprints-tech-bounces|ecs.soton.ac.uk|53E349FE.3070800@ecs.soton.ac.uk"
type="cite">
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
Hi Jacob,<br>
<br>
This is to do with the encodings used by the database tables. <br>
<br>
The latest version of eprints would create tables using UTF-8
encoding, but if you upgraded from an older version of eprints,
you may still have the Latin encoding. UTF-8 characters will be
messed up if you to save them into the a Latin encoding database
table. <br>
<br>
To check the encoding:<br>
SELECT default_character_set_name FROM information_schema.SCHEMATA
WHERE schema_name = "eprints_db_name";<br>
<br>
If it is not UTF-8, you will need to convert your database tables
to UTF-8 encoding manually. (<a moz-do-not-send="true"
class="moz-txt-link-freetext"
href="http://stackoverflow.com/questions/6115612/how-to-convert-an-entire-mysql-database-characterset-and-collation-to-utf-8">http://stackoverflow.com/questions/6115612/how-to-convert-an-entire-mysql-database-characterset-and-collation-to-utf-8</a>
) <br>
<br>
Make sure you backup your database before doing so! <br>
<br>
<br>
Best<br>
Jiadi<br>
<br>
<br>
<div class="moz-cite-prefix">On 07/08/2014 09:57, Jacob Wenzel
wrote:<br>
</div>
<blockquote
cite="mid:EMEW3|db16acdff22b193759f56c3062752412q769wa14eprints-tech-bounces|ecs.soton.ac.uk|53E33F8B.5000801@energiakademiet.dk"
type="cite">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
Perfect, it all works now.<br>
<br>
I did notice s small bug related to UTF8 I guess.<br>
<br>
If video file name contains special characters like "Æ, Ø, Å",
no preview will be generated. But I guess that would be bad
practice to do anyway.<br>
<br>
Thanks a lot for helping me out!<br>
<br>
Jacob.<br>
<br>
<div class="moz-cite-prefix">On 05-08-2014 23:19, Jiadi Yao
wrote:<br>
</div>
<blockquote
cite="mid:EMEW3|5a6508f4ea2c94c7a89e21dd1aa1fa9dq74MLw14eprints-tech-bounces|ecs.soton.ac.uk|53E14A63.7030308@ecs.soton.ac.uk"
type="cite"> Hi Jacob,<br>
<br>
You first need to run <br>
<br>
$ bin/epadmin redo_mime_type <br>
<br>
then <br>
$ bin/epadmin redo_thumbnails<br>
<br>
Technical details : document.media_video_codec in the database
needs to be valid before thumbnails are generated. This field
is populated after a video file is upload when ffmpeg is
installed, otherwise you need to redo_mime_type to back-fill
those videos uploaded before installing ffmpeg. <br>
<br>
<br>
Best<br>
Jiadi<br>
<br>
<div class="moz-cite-prefix">On 05/08/2014 18:56, Jacob Wenzel
wrote:<br>
</div>
<blockquote
cite="mid:EMEW3|41f173ffce57d7062646829b2466289cq74Iuu14eprints-tech-bounces|ecs.soton.ac.uk|53E11AB2.6080200@energiakademiet.dk"
type="cite"> Great!<br>
<br>
I restarted apache and uploaded a video, and it now displays
correctly with a thumbnail.<br>
<br>
Now I only need to redo the ones I already uploaded.<br>
<br>
I tried "bin/generate_abstracts" and "bin/epadmin
redo_thumbnails [eprint id]" but neither had any effect.<br>
<br>
What am I missing?<br>
<br>
All the best<br>
Jacob<br>
<br>
<br>
<div class="moz-cite-prefix">On 05-08-2014 16:39, Jacob
Wenzel wrote:<br>
</div>
<blockquote
cite="mid:EMEW3|b83449a4ab1111be41196b3a2bad3767q74FeO14eprints-tech-bounces|ecs.soton.ac.uk|53E0ECA2.9090704@energiakademiet.dk"
type="cite"> Thank you both!<br>
<br>
I have done what Jiadi toild me to. Was that what you
meant by configure ffmpeg seb?<br>
<br>
If not, than what do I need to do now?<br>
<br>
If yes, what is the correct step for me now? Restart
apache and regenerate thumbnails?<br>
<br>
I really appreciate your feedback!<br>
<br>
/Jacob<br>
<br>
<div class="moz-cite-prefix">On 05-08-2014 15:43, Jiadi
Yao wrote:<br>
</div>
<blockquote
cite="mid:EMEW3|cd72d2614ade0885c148522aeb6ea635q74EjQ14eprints-tech-bounces|ecs.soton.ac.uk|53E0DF9C.5080902@ecs.soton.ac.uk"
type="cite"> After you installed ffmpeg, you'll need to
changed the codec settings in Thumbnails.pm : <br>
<br>
1. change libfaac codec with libvo_aacenc<br>
2. change vorbis codec to libvorbis<br>
<br>
as those codes are no longer supported by ffmpeg. <br>
<br>
In addition, in lib/syscfg.d/invocations.pl<br>
"-vpre default" parameter need to be removed<br>
<br>
<br>
I'll update the github when I get a chance.<br>
<br>
Best<br>
Jiadi <br>
<div class="moz-cite-prefix"><br>
<br>
On 05/08/2014 14:27, Sebastien Francois wrote:<br>
</div>
<blockquote
cite="mid:EMEW3|53cfad4f09caf90c89399d963031d329q74EQB14eprints-tech-bounces|ecs.soton.ac.uk|53E0DBAB.105@ecs.soton.ac.uk"
type="cite">
<div class="moz-cite-prefix">Hi,<br>
<br>
Yes - it's a core functionality: <a
moz-do-not-send="true"
class="moz-txt-link-freetext"
href="https://github.com/eprints/eprints/blob/3.3/perl_lib/EPrints/Plugin/Convert/Thumbnails.pm">https://github.com/eprints/eprints/blob/3.3/perl_lib/EPrints/Plugin/Convert/Thumbnails.pm</a><br>
<br>
Do you have ffmpeg set-up?<br>
<br>
Seb.<br>
<br>
On 05/08/14 13:50, Jacob Wenzel wrote:<br>
</div>
<blockquote
cite="mid:53E0D31A.6000100@energiakademiet.dk"
type="cite"> Is it even possible to show image
thumbnail previews of uploaded videos and images in
EPrints 3.3.12?<br>
<br>
I use coversheets and the youtube-dl packages from
the Baza, which generates a thumbnail preview from
PDFs or imports a screenshot from the video on
Youtube and adds a link to the video.<br>
<br>
But if I upload actual image files or videos, the
file is depicted with and icon and no preview link
is available.<br>
<br>
I found some guides/plugins that promise to do this,
but they all seem to be targeting different, older
versions of EPrints, and I haven't been able to find
recent ones.<br>
<br>
Furthermore I would think that this was basic
functionality that any user would want, so I don't
why this functionality shouldn't be available "out
the box".<br>
<br>
This is the most recent document i have been able to
find, but my "eprints_render" does not include the
lines, that are mentioned in the guide, so I suspect
is is targeting an older version.<br>
<a moz-do-not-send="true"
class="moz-txt-link-freetext"
href="http://wiki.eprints.org/w/How_to_Create_Cover_Images_in_EPrints_3">http://wiki.eprints.org/w/How_to_Create_Cover_Images_in_EPrints_3</a><br>
<br>
I also looked at PreviewPlus (only for older
versions) and a few other links<br>
<br>
Maybe my setup is wrong, but "epadmin test" shows
"everything seems OK", so any help or pointers would
be greatly appreciated. Where should I look, and how
should I start.<br>
<br>
Thank you all in advance!<br>
<div class="moz-signature">-- <br>
<p style="color:#999;"><strong>Med venlig
hilsen/Best regards</strong></p>
<p style="color:#999;"><strong>JACOB WENZEL<br>
Projektleder</strong></p>
<p style="color:#999;"><strong>ENERGIAKADEMIET</strong><br>
Strandengen 1<br>
8305 SAMSØ<br>
+45 60 61 15 97<br>
<a moz-do-not-send="true" style="color:#999;
text-decoration:none;"
href="mailto:jw@energiakademiet.dk">jw@energiakademiet.dk</a><br>
<a moz-do-not-send="true" style="color:#999;
text-decoration:none;"
href="http://energiakademiet.dk">www.energiakademiet.dk</a><br>
</p>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">*** Options: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a>
*** Archive: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://www.eprints.org/tech.php/">http://www.eprints.org/tech.php/</a>
*** EPrints community wiki: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://wiki.eprints.org/">http://wiki.eprints.org/</a>
*** EPrints developers Forum: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://forum.eprints.org/">http://forum.eprints.org/</a>
</pre>
</blockquote>
<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">*** Options: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a>
*** Archive: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://www.eprints.org/tech.php/">http://www.eprints.org/tech.php/</a>
*** EPrints community wiki: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://wiki.eprints.org/">http://wiki.eprints.org/</a>
*** EPrints developers Forum: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://forum.eprints.org/">http://forum.eprints.org/</a>
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Jiadi Yao
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:jy2e08@ecs.soton.ac.uk">jy2e08@ecs.soton.ac.uk</a>
EPrints Services
3081, Building 32
University of Southampton</pre>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">*** Options: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a>
*** Archive: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://www.eprints.org/tech.php/">http://www.eprints.org/tech.php/</a>
*** EPrints community wiki: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://wiki.eprints.org/">http://wiki.eprints.org/</a>
*** EPrints developers Forum: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://forum.eprints.org/">http://forum.eprints.org/</a>
</pre>
</blockquote>
<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">*** Options: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a>
*** Archive: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://www.eprints.org/tech.php/">http://www.eprints.org/tech.php/</a>
*** EPrints community wiki: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://wiki.eprints.org/">http://wiki.eprints.org/</a>
*** EPrints developers Forum: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://forum.eprints.org/">http://forum.eprints.org/</a>
</pre>
</blockquote>
<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">*** Options: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a>
*** Archive: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://www.eprints.org/tech.php/">http://www.eprints.org/tech.php/</a>
*** EPrints community wiki: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://wiki.eprints.org/">http://wiki.eprints.org/</a>
*** EPrints developers Forum: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://forum.eprints.org/">http://forum.eprints.org/</a>
</pre>
</blockquote>
<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">*** Options: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a>
*** Archive: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://www.eprints.org/tech.php/">http://www.eprints.org/tech.php/</a>
*** EPrints community wiki: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://wiki.eprints.org/">http://wiki.eprints.org/</a>
*** EPrints developers Forum: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://forum.eprints.org/">http://forum.eprints.org/</a>
</pre>
</blockquote>
<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">*** Options: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a>
*** Archive: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://www.eprints.org/tech.php/">http://www.eprints.org/tech.php/</a>
*** EPrints community wiki: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://wiki.eprints.org/">http://wiki.eprints.org/</a>
*** EPrints developers Forum: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://forum.eprints.org/">http://forum.eprints.org/</a>
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Jiadi Yao
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:jy2e08@ecs.soton.ac.uk">jy2e08@ecs.soton.ac.uk</a>
EPrints Services
3081, Building 32
University of Southampton</pre>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">*** Options: <a class="moz-txt-link-freetext" href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a>
*** Archive: <a class="moz-txt-link-freetext" href="http://www.eprints.org/tech.php/">http://www.eprints.org/tech.php/</a>
*** EPrints community wiki: <a class="moz-txt-link-freetext" href="http://wiki.eprints.org/">http://wiki.eprints.org/</a>
*** EPrints developers Forum: <a class="moz-txt-link-freetext" href="http://forum.eprints.org/">http://forum.eprints.org/</a>
</pre>
</blockquote>
<br>
</body>
</html>