<html>
  <head>
    <meta content="text/html; charset=windows-1252"
      http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    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 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>