<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hi Jacob,<br>
<br>
The default charset is the charset used to create new tables and new
fields. (e.g. when you add new fields to eprints). It is best to
change the default to utf8 (by using the ALTER DATABASE databasename
CHARACTER SET utf8 COLLATE utf8_unicode_ci;). But this is not
directly related to your problem. <br>
<br>
You need to make sure the existing tables' encoding are in utf8.<br>
<br>
To check your table encoding, in mysql command line, type:<b><br>
</b><b>SHOW FULL COLUMNS FROM </b><b><i>tablename</i></b><b>; </b><br>
<br>
The <b><i>Collation</i></b><b> </b>column tells you the current
encoding used for the field. I presume you will find them in
"Latin1".<br>
<br>
If so, you will need to convert the table to utf8 encoding: <b><br>
</b><b>ALTER TABLE tablename CONVERT TO CHARACTER SET utf8 COLLATE
utf8_general_ci;</b><br>
<br>
After you converted tables, you will need to re-save the text as the
utf8 texts are already corrupted. <br>
<br>
Best<br>
Jiadi<br>
<br>
<br>
<br>
<br>
<br>
<div class="moz-cite-prefix">On 13/08/2014 15:30, Jacob Wenzel
wrote:<br>
</div>
<blockquote
cite="mid:EMEW3|fba67edb47615a650a855374907d2355q7CFUo14eprints-tech-bounces|ecs.soton.ac.uk|53EB766D.608@energiakademiet.dk"
type="cite">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
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"> 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"> 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 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 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>
<pre class="moz-signature" cols="72">--
Jiadi Yao
<a 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>
</body>
</html>