Recherche avancée

Sur d’autres sites (10598)

• Anomalie #4354 : Problème de recherche REGEX, mauvais joker

  19 juin 2019

  Et donc, Mysql 8.0 améliore ces points là : https://mysqlserverteam.com/mysql-8-0-regular-expressions-and-character-properties/

• Anomalie #4033 : Critère `{age #TRUC}` erroné en SQLite

  28 octobre 2017

  SQLite3 :
  

  sqlite> select 2 < ’3’ ;
  1
  sqlite> select 4 < ’3’ ;
  1
  

  Mysql :
  

  mysql> select 2 < ’3’ ;
  1
  mysql> select 4 < ’3’ ;
  0
  

• How to make ffmpeg respect the "start_time" variable when combining cdg and mp3 ?

  5 juillet 2020, par Steffen Poulsen

  I'm trying to combine two .cdg and .mp3 files because I want to make a single .mkv file out of them.

  



  When I do it I get a .mkv file alright, but the audio is unfortunately not synced with the video.

  



  So, I was wondering why this is ? Apparently I must be missing a parameter on my command or something.

  



  What I do is this :

  



  ffmpeg -y -i song.cdg -i song.mp3 -pix_fmt yuv420p -vcodec libx264 -acodec copy song.mkv


  



  It works fine, but in this particular case the result is out of sync by 1.2 seconds. This varies per song, from 0 to a couple of seconds.

  



  However, if I do a ffprobe on the .cdg file I notice that this number is already present, as the "start_time" variable :

  



  ffprobe -v error -show_format -show_streams song.cdg
...
start_time=1.186667
...


  



  So, if I just use this number directly as this for the -itsoffset parameter :

  



  ffmpeg -y -itsoffset 1.186667 -i song.cdg -i song.mp3 -pix_fmt yuv420p -vcodec libx264 -acodec copy song.mkv


  



  Then the video and audio is in perfect sync.

  



  So, I am wondering - what parameter do I need to add to my command to have ffmpeg respect this variable ?