Advanced search

On other websites (4358)

• Anomalie #4728 (En cours): Dump php, support pour MariaDB

  13 April 2021, by Joachim SENE

  Si Spip fonctionne bien sur des serveurs utilisant MariaDB (comme chez l’hébergeur Nuxit), cela plante pour deux fonctions essentielles :

  • Sauvegarde de la base
  • Mise à jour via spip_loader.php

  Pendant la sauvegarde (je crois que c’est donc ecrire/base/dump.php) le préfixe de table est ignoré.
  Pour une base qui fonctionne avec un préfixe comme spippref* ici les erreurs renvoient spip* comme préfixe utilisé :

  2021-04-09 10:26:24 90.3.175.179 (pid 12829) :Pri:ERREUR: no such table: spip_articles - <br />SELECT COUNT(*)<br />FROM spip_articles - /home/users4/s/sj140phpnet/www/plugins-dist/dump/prive/squelettes/contenu/sauvegarder_fonctions.php L36 [sql_countsel(),dump_afficher_tables_sauvegardees(),html_4efc0080d0d07f4680aa17f4911fe369(),public_parametrer_dist(),public_produire_page_dist(),inclure_page(),evaluer_fond(),recuperer_fond(),eval(),include(),evaluer_fond(),recuperer_fond(),eval(),include(),evaluer_fond(),recuperer_fond(),eval(),include(),include()]<br />2021-04-09 10:26:24 90.3.175.179 (pid 12829) :Pri:ERREUR: Erreur sqlite HY000 / 1<br />2021-04-09 10:26:24 90.3.175.179 (pid 12829) :Pri:ERREUR: no such table: spip_breves -

  La sauvegarde indique, dans l’espace privé :

  spip_articles (vide)<br />spip_auteurs_liens (82/82)<br />spip_breves (vide)<br />spip_depots (vide)<br />spip_depots_plugins (707/707)<br />spip_documents (vide)<br />spip_documents_liens (116/116)<br />spip_forum (vide)<br />spip_groupes_mots (vide)<br />spip_jobs (7/7)<br />spip_jobs_liens (vide)<br />spip_messages (vide)<br />spip_mots (vide)<br />spip_mots_liens (203/203)<br />spip_paquets (1109/1109)<br />spip_petitions (vide)<br />spip_plugins (732/732)<br />spip_referers (vide)<br />spip_referers_articles (vide)<br />spip_rubriques (vide)<br />spip_signatures (vide)<br />spip_syndic (vide)<br />spip_syndic_articles (vide)<br />spip_types_documents (vide)<br />spip_urls (172/172)<br />spip_versions (vide)<br />spip_versions_fragments (vide)

  Sachant que même les tables marquées comme ok 172/172 lignes sauvegardées par ex, sont en erreur dans le log !

  2021-04-13 11:29:25 90.3.175.179 (pid 23528) :Pri:ERREUR: no such table: spip_urls -

  J’ai échangé avec l’hébergeur, on en est arrivé à cette conclusion possible Spip & MariaDB à ce niveau pose problème. Je ne sais pas aller plus loin, si quelqu’un a besoin d’un FTP sur Nuxit je peux fournir !

  Je me suis permis d’assigner en fonction de la signature dans dump.php pour que le ticket soit reçu :)
  merci d’avance !
  

• FFmpeg - Convert video changing resolution and bitrates

  8 April 2021, by parvares

  I’m trying to convert a video and change these parameters:

  


  resolution: from 1.280x720 to 640x360 pixels

  


  average bitrate: from 1.410 to 300 kb/s

  


  maximum bitrate: from 1.680 to 2500 kb/s

  


  Sampling rate: from 48.0 to 44.1 kHz

  


  Bit rate audio: 128 kb/s

  


  I used this string with ffmpeg vers. 4.3.2-2021-02-20 full build:

  


  ffmpeg -i input.mp4 -c:v -vf scale=640:360 libx264 -b:v 300k -maxrate 2500k -bufsize 2500k -crf 25 -c:a -ar 44100 libfdk_aac -b:a 128k output.mp4


  


  I get the error: “ffmpeg unable to find a suitable output format for scale ‘640:360’ scale 640:360: invalid argument”. Could you help me please?

  


  Below is the original file analyzed by MediaInfo, thanks!

  


  General

  


  Complete name : C:\Users\parvares\Desktop\input.mp4
Format : MPEG-4
Format profile : Base Media
Codec ID : isom (isom/iso2/avc1/mp41)
File size : 424 MiB
Duration : 38 min 21 s
Overall bit rate : 1 545 kb/s
Writing application : Lavf58.64.100

  


  Video

  


  ID : 1
Format : AVC
Format/Info : Advanced Video Codec
Format profile : High@L3.1
Format settings : CABAC / 4 Ref Frames
Format settings, CABAC : Yes
Format settings, Reference frames : 4 frames
Codec ID : avc1
Codec ID/Info : Advanced Video Coding
Duration : 38 min 21 s
Bit rate : 1 410 kb/s
Maximum bit rate : 1 680 kb/s
Width : 1 280 pixels
Height : 720 pixels
Display aspect ratio : 16:9
Frame rate mode : Constant
Frame rate : 25.000 FPS
Color space : YUV
Chroma subsampling : 4:2:0
Bit depth : 8 bits
Scan type : Progressive
Bits/(Pixel*Frame) : 0.061
Stream size : 387 MiB (91%)
Writing library : x264 core 161 r3027 4121277
Encoding settings : cabac=1 / ref=2 / deblock=1:0:0 / analyse=0x3:0x113 / me=hex / subme=6 / psy=1 / psy_rd=1.00:0.00 / mixed_ref=1 / me_range=16 / chroma_me=1 / trellis=1 / 8x8dct=1 / cqm=0 / deadzone=21,11 / fast_pskip=1 / chroma_qp_offset=-2 / threads=12 / lookahead_threads=2 / sliced_threads=0 / nr=0 / decimate=1 / interlaced=0 / bluray_compat=0 / constrained_intra=0 / bframes=3 / b_pyramid=2 / b_adapt=1 / b_bias=0 / direct=1 / weightb=1 / open_gop=0 / weightp=1 / keyint=250 / keyint_min=125 / scenecut=40 / intra_refresh=0 / rc_lookahead=125 / rc=crf / mbtree=1 / crf=20.0 / qcomp=0.60 / qpmin=0 / qpmax=69 / qpstep=4 / vbv_maxrate=1680 / vbv_bufsize=8400 / crf_max=0.0 / nal_hrd=none / filler=0 / ip_ratio=1.40 / aq=1:1.00
Color range : Limited
Color primaries : BT.709
Transfer characteristics : BT.709
Matrix coefficients : BT.709
Codec configuration box : avcC

  


  Audio

  


  ID : 2
Format : AAC LC
Format/Info : Advanced Audio Codec Low Complexity
Codec ID : mp4a-40-2
Duration : 38 min 21 s
Bit rate mode : Constant
Bit rate : 129 kb/s
Channel(s) : 2 channels
Channel layout : L R
Sampling rate : 48.0 kHz
Frame rate : 46.875 FPS (1024 SPF)
Compression mode : Lossy
Stream size : 35.3 MiB (8%)
Default : Yes
Alternate group : 1

  


• Unable to convert mov to mp4 using ffmpeg carrierwave in ruby

  9 April 2021, by LearningROR

  I am unable to convert MOV files to MP4 using carrierwave and FFmpeg.

  


  It does upload mp4 file but does not convert it to mp4 and so on browser only sound gets played not the video.

  


  What I am missing here? I tried most of the solutions.

  


  Code:

  


  class VideoUploader < CarrierWave::Uploader::Base
  include CarrierWave::MiniMagick
  include CarrierWave::Video
  include CarrierWave::Video::Thumbnailer
  include CarrierWave::FFmpeg
  # Choose what kind of storage to use for this uploader:
  storage :file
  # Override the directory where uploaded files will be stored.
  # This is a sensible default for uploaders that are meant to be mounted:
  def store_dir
    "uploads/#{model.class.to_s.underscore}/#{mounted_as}/#{model.id}"
  end
  version :video, :if => :video? do
    process :encode
  end
  version :thumb do
    process thumbnail: [{format: 'jpg', quality: 8, size: 360, logger: Rails.logger, square: false}]
    def full_filename for_file
      jpg_name for_file, version_name
    end
  end
  def encode
    tmp_path = File.join( File.dirname(current_path), "tmpfile.mp4" )
    movie = FFMPEG::Movie.new(current_path)
    movie.transcode(tmp_path, custom: %w(-c:v libx264 -c:a aac -vf format=yuv420p -movflags +faststart)) do |progress|
      puts progress
    end
    File.rename tmp_path, current_path
  end
  protected
  def video?(new_file)
    new_file.content_type.include? 'video'
  end
end


  


  Logs:

  


  I, [2021-04-09T15:33:24.783337 #9397]  INFO -- : Running transcoding...
["/usr/local/bin/ffmpeg", "-y", "-i", "/Users/osx/workspace_ror/xxx-react/tmp/1617964403-459168728101935-0021-9213/video/sample_iTunes__1_.mov", "-c:v", "libx264", "-c:a", "aac", "-vf", "format=yuv420p", "-movflags", "+faststart", "/Users/osx/workspace_ror/xxx-react/tmp/1617964403-459168728101935-0021-9213/video/tmpfile.mp4"]

0.0
0.08304093567251461
0.1672514619883041
0.2327485380116959
0.3229239766081871
0.4008187134502924
0.45426900584795327
0.5033918128654971
0.5403508771929825
0.6100584795321637
0.663859649122807
0.711812865497076
0.7657309941520468
0.8196491228070175
0.87953216374269
0.9394152046783625
1.0
1.0
I, [2021-04-09T15:33:33.555508 #9397]  INFO -- : Transcoding of /Users/osx/workspace_ror/xxx-react/tmp/1617964403-459168728101935-0021-9213/video/sample_iTunes__1_.mov to /Users/osx/workspace_ror/xxx-react/tmp/1617964403-459168728101935-0021-9213/video/tmpfile.mp4 succeeded

Running....ffmpegthumbnailer -i /Users/osx/workspace_ror/xxx-react/tmp/1617964403-459168728101935-0021-9213/thumb/sample_iTunes__1_.mov -o /Users/osx/workspace_ror/xxx-react/tmp/1617964403-459168728101935-0021-9213/thumb/tmpfile.jpg -c jpg -q 8 -s 360
Success!