Recherche avancée

Sur d’autres sites (4997)

• Revision 30246 : Corrections de grosses boulettes sql Correction d’une boulette dans la ...

  27 juillet 2009, par kent1@… — Log

  Corrections de grosses boulettes sql
  Correction d’une boulette dans la déclaration des champs
  On ne permet la demande de réencodage que depuis le document original sinon vive ma perte de qualité
  On affiche un message indiquant que c’est une version encodée issue d’un autre document s’il y a lieu de le faire
  On encode les sons dorénavant

• Video not clear when concatinate videos thogther using ffmpeg

  5 février 2018, par no name

  I have 3 types of the video first is start video played when the video start, the main video which is the main content of the video and last is the end video I want to add them together they have different resolutions so I use a text file to write the videos name like this.

  file start.mp4
  
  file main.mp4
  
  file end.mp4

  then I use this command with FFmpeg

  FFmpeg -f concat -i ffmpeg-sound.txt -c copy final_output.mp4

  the problem is when I start watching the video the first video image is appearing in all the video duration I tried different player every one shows me a crashed photo but the sound is working fine.
  also, the main video is created from mp3 file and image with subtitle it’s not original or downloaded from anywhere and I want to concatenate them.
  what i tried when i make some searches and i thought it’s the problem that they have different resolution so i tried this command on both 3 videos to make them have the same resolution so no problem show after the concatenate
  

  FFmpeg -y -i end.mp4 -c copy -bsf:v h264_mp4toannexb -f mpegts end.mp4.ts

  and try to add the 3 files again with ts formate and the same problem shown too so please any help to solve this
  Update
  i tried to use this command to change all the three videos to 1280x720

  FFmpeg -i a.mp4 -vf scale=1280:720 a1.mp4

  after testing the problem exactly i found that the first video only works then when it go to next video to show it, the screen is a freeze on the last image from the first video. I don’t know why this problem even after i make them same scale !
  here is the output of

  ffmpeg -i start.mp4 -i a.mp4 -i end.mp4

  output this before edit all the videos resulution to 1280x720

      ffmpeg version N-89940-gb1af0e23a3 Copyright (c) 2000-2018 the FFmpeg developers
  
    built with gcc 7.2.0 (GCC)
  
    configuration: --enable-gpl --enable-version3 --enable-sdl2 --enable-bzlib --enable-fontconfig --enable-gnutls --enable-iconv --enable-libass --enable-libbluray --enable-libfreetype --enable-libmp3lame --enable-libopencore-amrnb --enable-libopencore-amrwb --enable-libopenjpeg --enable-libopus --enable-libshine --enable-libsnappy --enable-libsoxr --enable-libtheora --enable-libtwolame --enable-libvpx --enable-libwavpack --enable-libwebp --enable-libx264 --enable-libx265 --enable-libxml2 --enable-libzimg --enable-lzma --enable-zlib --enable-gmp --enable-libvidstab --enable-libvorbis --enable-libvo-amrwbenc --enable-libmysofa --enable-libspeex --enable-libxvid --enable-libmfx --enable-amf --enable-cuda --enable-cuvid --enable-d3d11va --enable-nvenc --enable-dxva2 --enable-avisynth
  
    libavutil      56.  7.100 / 56.  7.100
  
    libavcodec     58.  9.100 / 58.  9.100
  
    libavformat    58.  7.100 / 58.  7.100
  
    libavdevice    58.  0.101 / 58.  0.101
  
    libavfilter     7. 11.101 /  7. 11.101
  
    libswscale      5.  0.101 /  5.  0.101
  
    libswresample   3.  0.101 /  3.  0.101
  
    libpostproc    55.  0.100 / 55.  0.100
  
  Input #0, mov,mp4,m4a,3gp,3g2,mj2, from 'start.mp4':
  
    Metadata:
  
      major_brand     : isom
  
      minor_version   : 512
  
      compatible_brands: isomiso2avc1mp41
  
      title           : Tunepro
  
      artist          : Kiran Khan
  
      album_artist    : Kiran Khan
  
      encoder         : Lavf57.83.100
  
      description     : This video is about Tunepro
  
      keywords        : tunepro,new
  
    Duration: 00:00:03.15, start: 0.000000, bitrate: 863 kb/s
  
      Stream #0:0(und): Video: h264 (High) (avc1 / 0x31637661), yuv420p, 1920x1080 [SAR 1:1 DAR 16:9], 729 kb/s, 25 fps, 25 tbr, 12800 tbn, 50 tbc (default)
  
      Metadata:
  
        handler_name    : VideoHandler
  
      Stream #0:1(eng): Audio: aac (LC) (mp4a / 0x6134706D), 44100 Hz, stereo, fltp, 129 kb/s (default)
  
      Metadata:
  
        handler_name    : SoundHandler
  
  Input #1, mov,mp4,m4a,3gp,3g2,mj2, from 'a.mp4':
  
    Metadata:
  
      major_brand     : isom
  
      minor_version   : 512
  
      compatible_brands: isomiso2avc1mp41
  
      encoder         : Lavf58.7.100
  
    Duration: 00:05:21.24, start: 0.000000, bitrate: 188 kb/s
  
      Stream #1:0(und): Video: h264 (High 4:4:4 Predictive) (avc1 / 0x31637661), yuvj444p(pc), 300x300 [SAR 1:1 DAR 1:1], 53 kb/s, 25 fps, 25 tbr, 12800 tbn, 50 tbc (default)
  
      Metadata:
  
        handler_name    : VideoHandler
  
      Stream #1:1(und): Audio: aac (LC) (mp4a / 0x6134706D), 44100 Hz, stereo, fltp, 128 kb/s (default)
  
      Metadata:
  
        handler_name    : SoundHandler
  
  Input #2, mov,mp4,m4a,3gp,3g2,mj2, from 'end.mp4':
  
    Metadata:
  
      major_brand     : isom
  
      minor_version   : 512
  
      compatible_brands: isomiso2avc1mp41
  
      title           : Tunepro
  
      artist          : Kiran Khan
  
      album_artist    : Kiran Khan
  
      encoder         : Lavf57.83.100
  
      description     : This video is about Tunepro
  
      keywords        : tunepro,new
  
    Duration: 00:00:30.03, start: 0.000000, bitrate: 8051 kb/s
  
      Stream #2:0(und): Video: h264 (High) (avc1 / 0x31637661), yuv420p, 1920x1080 [SAR 1:1 DAR 16:9], 7923 kb/s, 25 fps, 25 tbr, 12800 tbn, 50 tbc (default)
  
      Metadata:
  
        handler_name    : VideoHandler
  
      Stream #2:1(eng): Audio: aac (LC) (mp4a / 0x6134706D), 44100 Hz, stereo, fltp, 128 kb/s (default)
  
      Metadata:
  
        handler_name    : SoundHandler
  
  At least one output file must be specified

• Paperclip with heroku and paperclip, migration fails

  2 décembre 2013, par jdartland

  I have a created ruby on rails application and I'm using paperclip to handle my file uploads.
  Paperclip works just fine on my local machine. But my video upload stops working when I deploy to Heroku. Does anyone know whats going wrong. I also get an error when I try to upload a video which says that the video filename does not exist. The photo upload works but not the Video, I'm using paperclip iwth nested attributes and ffmpeg.

  Upload Error log :

  Paperclip::Error (Asset model missing required attr_accessor for 'video_file_name')
  
  2013-12-02T14:38:16.867747+00:00 app[web.1]: Paperclip::Error (Asset model missing required attr_accessor for 'video_file_name'):
  
  2013-12-02T14:38:16.867747+00:00 app[web.1]:   app/controllers/projects_controller.rb:60:in `block in update'
  
  2013-12-02T14:38:16.867747+00:00 app[web.1]:   app/controllers/projects_controller.rb:59:in `update'

  Here is my migration error :

  Migrating to AddAttachmentPhotoToAssets (20131021134721)
  
  ==  AddAttachmentPhotoToAssets: migrating =====================================
  
  -- change_table(:assets)
  
     -> 0.0273s
  
  ==  AddAttachmentPhotoToAssets: migrated (0.0276s) ============================
  
  
  
  Migrating to AddProjectIdToAssets (20131022082744)
  
  -- add_column(:assets, :project_id, :integer)
  
  PG::DuplicateColumn: ERROR:  column "project_id" of relation "assets" already exists
  
  : ALTER TABLE "assets" ADD COLUMN "project_id" integer
  
  -- add_column(:assets, :project_id, :integer)
  
  PG::DuplicateColumn: ERROR:  column "project_id" of relation "assets" already exists
  
  : ALTER TABLE "assets" ADD COLUMN "project_id" integer
  
  rake aborted!
  
  PG::DuplicateColumn: ERROR:  column "project_id" of relation "assets" already exists
  
  : ALTER TABLE "assets" ADD COLUMN "project_id" integer
  
  /app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/connection_adapters/postgresql/database_statements.rb:128:in `exec'
  
  /app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/connection_adapters/postgresql/database_statements.rb:128:in `block in execute'
  
  /app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/connection_adapters/abstract_adapter.rb:425:in `block in log'
  
  /app/vendor/bundle/ruby/2.0.0/gems/activesupport-4.0.0/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
  
  /app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/connection_adapters/abstract_adapter.rb:420:in `log'
  
  /app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/connection_adapters/postgresql/database_statements.rb:127:in `execute'
  
  /app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/connection_adapters/abstract/schema_statements.rb:360:in `add_column'
  
  /app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/connection_adapters/postgresql/schema_statements.rb:379:in `add_column'
  
  /app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/migration.rb:625:in `block in method_missing'
  
  /app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/migration.rb:597:in `block in say_with_time'
  
  /app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/migration.rb:597:in `say_with_time'
  
  /app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/migration.rb:617:in `method_missing'
  
  /app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/migration.rb:383:in `method_missing'
  
  /app/db/migrate/20131022082744_add_project_id_to_assets.rb:2:in `'
  
  /app/db/migrate/20131022082744_add_project_id_to_assets.rb:1:in `<top>&#39;
  
  /app/vendor/bundle/ruby/2.0.0/gems/activesupport-4.0.0/lib/active_support/dependencies.rb:228:in `require&#39;
  
  /app/vendor/bundle/ruby/2.0.0/gems/activesupport-4.0.0/lib/active_support/dependencies.rb:228:in `block in require&#39;
  
  /app/vendor/bundle/ruby/2.0.0/gems/activesupport-4.0.0/lib/active_support/dependencies.rb:213:in `load_dependency&#39;
  
  /app/vendor/bundle/ruby/2.0.0/gems/activesupport-4.0.0/lib/active_support/dependencies.rb:228:in `require&#39;
  
  /app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/migration.rb:718:in `load_migration&#39;
  
  /app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/migration.rb:714:in `migration&#39;
  
  /app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/migration.rb:708:in `disable_ddl_transaction&#39;
  
  /app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/migration.rb:1012:in `use_transaction?&#39;
  
  /app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/migration.rb:922:in `rescue in block in migrate&#39;
  
  /app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/migration.rb:919:in `block in migrate&#39;
  
  /app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/migration.rb:916:in `each&#39;
  
  /app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/migration.rb:916:in `migrate&#39;
  
  /app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/migration.rb:764:in `up&#39;
  
  /app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/migration.rb:742:in `migrate&#39;
  
  /app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/railties/databases.rake:42:in `block (2 levels) in <top>&#39;
  
  Tasks: TOP => db:migrate
  
  (See full trace by running task with --trace)
  
  </top></top>

  Here is my table :

   create_table "assets", force: true do |t|
  
      t.datetime "created_at"
  
      t.datetime "updated_at"
  
      t.string   "photo_file_name"
  
      t.string   "photo_content_type"
  
      t.integer  "photo_file_size"
  
      t.datetime "photo_updated_at"
  
      t.integer  "project_id"
  
      t.string   "video_file_name"
  
      t.string   "video_content_type"
  
      t.integer  "video_file_size"
  
      t.datetime "video_updated_at"
  
    end
  
  add_index "projects", ["permalink"], name: "index_projects_on_permalink", using: :btree
  
  
  
    create_table "settings", force: true do |t|
  
      t.string   "title"
  
      t.text     "description"
  
      t.text     "paragraph"
  
      t.datetime "created_at"
  
      t.datetime "updated_at"
  
      t.string   "photo_file_name"
  
      t.string   "photo_content_type"
  
      t.integer  "photo_file_size"
  
      t.datetime "photo_updated_at"
  
      t.string   "video_file_name"
  
      t.string   "video_content_type"
  
      t.integer  "video_file_size"
  
      t.datetime "video_updated_at"
  
    end

  Would gladly need some help ! :)