<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Thanks for your reply Jiadi, but I think all my tables are already
utf8, it is only <i>default_character_set_name</i> that is <i>latin1</i>.<br>
<br>
All tables show <i>utf8_general_ci</i> in the column <i>Collation</i>
when I run <i>show table status from eprints_db_name;<br>
</i><br>
That is why, I'm guessing I only need to run <font color="#ff0000">ALTER
DATABASE eprints_db_name CHARACTER SET utf8 COLLATE
utf8_general_ci;<br>
<br>
</font>It is not clear to me if you missed that piece of information
or if I will need to convert all the tables anyway. Could you please
clarify that? <br>
<br>
Sorry for bugging you again. All the best!<br>
/Jacob<br>
<br>
<div class="moz-cite-prefix">On 13-08-2014 14:32, Jiadi Yao wrote:<br>
</div>
<blockquote
cite="mid:EMEW3|0267c385c8cf80e67c43ae87af70894cq7CDXl14eprints-tech-bounces|ecs.soton.ac.uk|53EB5AD8.80900@ecs.soton.ac.uk"
type="cite">
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
Hi Jacob,<br>
<br>
You only need to convert those tables that will store utf8
characters, but as a good practice, it is better to convert all
tables to utf8.<br>
<br>
You can try and find some tutorials that allow you to convert the
whole database to utf8. <br>
<br>
Regards,<br>
Jiadi<br>
<br>
<div class="moz-cite-prefix">On 13/08/2014 12:04, Jacob Wenzel
wrote:<br>
</div>
<blockquote
cite="mid:EMEW3|ffa66e8f043e51982c1264298d65a392q7CC5Z14eprints-tech-bounces|ecs.soton.ac.uk|53EB4657.3050401@energiakademiet.dk"
type="cite">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
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 moz-do-not-send="true" 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"> 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"> 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 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>