Recherche avancée

Sur d’autres sites (3067)

• Anomalie #4108 (Fermé) : Critère IN et #ENV

  4 mars 2018, par Maïeul Rouquette

  Du fait que SPIP traite les #ENV comme des chaînes, ont ne peut pas utiliser un #ENV pour définir un IN sous forme de liste séparées par virgule.

  #ID_ARTICLE
  
  

  Sur http://astro.dev/?page=toto&ids_article=1,105
  donne
  

  SELECT articles.id_article, articles.lang, articles.titre
  FROM central_articles AS `articles`
  WHERE (articles.statut = ’publie’)
      AND ((articles.id_article  IN (’1,105’)))
  ORDER BY FIELD(articles.id_article,’1,105’)
  

  et pas

  SELECT articles.id_article, articles.lang, articles.titre
  FROM central_articles AS `articles`
  WHERE (articles.statut = ’publie’)
      AND ((articles.id_article  IN (1,105)))
  ORDER BY FIELD(articles.id_article,1,105)
  

  comme on pourrait souhaiter.

• Looking to play back non-encoded video upload then export gif from selection point via FFMPEG

  10 novembre 2019, par Christopher Neil

  We’ve been trying to crack this code all week, reaching out to everyone to see if you have any solutions ?

  1. We want the user to upload a video and in the next step he will select a small 5 second loop of the video which will be made as a gif.
  2. Old developer was able to do this by splicing the video at 10 seconds instead of 5 but not re-encoding it meant that it would sometimes be beyond 12 seconds and in some cases less than 7.
  3. We changed the code to force keyframes with re encoding so that it splices the video at exactly 5 seconds to show the loop.
  4. These slices are shown to the user using html5 video player.
  5. Upon selection of the loop that sliced video is converted to gif.

  Everything is working in the vice order. The issue is when the user uploads a large sized and length video this slicing and re-encoding takes forever and that cause the user to feel the site is not working properly.

  What we want is very simple :

  1. Show 5 second portion of the video on loop.
  2. If user wants to select another loop he/she clicks the next button and is taken to the next 5 second loop which would be either at 25% of the video or some other
  3. On selection of that portion it converts it into gif.

• How to get the buffer of the first frame of a video using ffmpeg ? (Node.js)

  12 avril 2024, par Mahmoud Walid

  I am trying to use child_processes and ffmpeg to do this, but it returns this error :

  


  FFmpeg stderr: [AVFilterGraph @ 00000157fd55abc0] No option name near 'eq(n, 0)"'
[AVFilterGraph @ 00000157fd55abc0] Error parsing a filter description around:
[AVFilterGraph @ 00000157fd55abc0] Error parsing filterchain '"select=eq(n\, 0)"' around:
[vost#0:0/libx264 @ 00000157fd574700] Error initializing a simple filtergraph
Error opening output file pipe:1.
Error opening output files: Invalid argument

FFmpeg process exited with code: 4294967274


  


  When I run that command in the terminal, it works fine, but it doesn't work in the code.
Here's the command (terminal version) :
ffmpeg -i input/vid.mp4 -vf "select=eq(n\,0)" -vframes 1 out.png

  


  And heres the code :

  


  import { spawn } from 'child_process';

const inputVideoPath = 'input/vid.mp4';

const ffmpeg = spawn('ffmpeg', [
    '-i', inputVideoPath,
    '-vf', '"select=eq(n\\, 0)"',
    '-vframes', '1',
    '-f', 'mp4',
    'pipe:1'
]);

let buffer = Buffer.from([]);
ffmpeg.stdout.on('data', (data) => {
    buffer = Buffer.concat([buffer, data]);
});

ffmpeg.stderr.on('data', (data) => {
    console.error('FFmpeg stderr:', data.toString());
});

ffmpeg.on('exit', (code) => {
    if (code == 0) {
        console.log('FFmpeg process exited successfully.');
        console.log(`Buffer size: ${buffer.length} bytes`);
    } else {
        console.error(`FFmpeg process exited with code: ${code}`);
    }
});

ffmpeg.on('error', (err) => {
    console.error('FFmpeg error:', err);
});


  


  Note : I know I'm not doing anything with the buffer, I just want it to work first then I'll start working with the output