Recherche avancée

Sur d’autres sites (12438)

• Anomalie #4374 : Sauvegarde au format SQLite impossible avec les dernières version de MariaDB

  7 novembre 2020, par b b

  Un truc comme ça @marcimat ?

  <span class="CodeRay"><span class="line comment">diff --git a/ecrire/req/sqlite_generique.php b/ecrire/req/sqlite_generique.php</span>
  <span class="line comment">index 8ed38dc0a5..00d61660ee 100644</span>
  <span class="line head"><span class="head">--- </span><span class="filename">a/ecrire/req/sqlite_generique.php</span></span>
  <span class="line head"><span class="head">+++ </span><span class="filename">b/ecrire/req/sqlite_generique.php</span></span>
  <span class="change"><span class="change">@@</span> -2429,6 +2429,7 <span class="change">@@</span></span> <span class="keyword">function</span> <span class="function">_sqlite_remplacements_definitions_table</span>(<span class="local-variable">$query</span>, <span class="local-variable">$autoinc</span> = <span class="predefined-constant">false</span>) {
           <span class="string"><span class="delimiter">'</span><span class="content">/((char|varchar)</span><span class="delimiter">'</span></span> . <span class="local-variable">$num</span> . <span class="string"><span class="delimiter">'</span><span class="content">\s</span><span class="content">+not</span><span class="content">\s</span><span class="content">+null(</span><span class="content">\s</span><span class="content">+collate</span><span class="content">\s</span><span class="content">+</span><span class="content">\w</span><span class="content">+)?)</span><span class="content">\s</span><span class="content">*$/is</span><span class="delimiter">'</span></span> => <span class="string"><span class="delimiter">"</span><span class="char">\\</span><span class="content">1 DEFAULT ''</span><span class="delimiter">"</span></span>,
           <span class="string"><span class="delimiter">'</span><span class="content">/(datetime</span><span class="content">\s</span><span class="content">+not</span><span class="content">\s</span><span class="content">+null)</span><span class="content">\s</span><span class="content">*$/is</span><span class="delimiter">'</span></span> => <span class="string"><span class="delimiter">"</span><span class="char">\\</span><span class="content">1 DEFAULT '0000-00-00 00:00:00'</span><span class="delimiter">"</span></span>,
           <span class="string"><span class="delimiter">'</span><span class="content">/(date</span><span class="content">\s</span><span class="content">+not</span><span class="content">\s</span><span class="content">+null)</span><span class="content">\s</span><span class="content">*$/is</span><span class="delimiter">'</span></span> => <span class="string"><span class="delimiter">"</span><span class="char">\\</span><span class="content">1 DEFAULT '0000-00-00'</span><span class="delimiter">"</span></span>,
  <span class="line insert"><span class="insert">+</span>        <span class="string"><span class="delimiter">'</span><span class="content">/current_timestamp</span><span class="content">\(</span><span class="content">\)</span><span class="content">/</span><span class="delimiter">'</span></span> => <span class="string"><span class="delimiter">'</span><span class="content">CURRENT_TIMESTAMP</span><span class="delimiter">'</span></span></span>
       );
   
       <span class="comment">// pour l'autoincrement, il faut des INTEGER NOT NULL PRIMARY KEY</span>
   
  </span>
  Télécharger

• Show error when build win32 version Ffmpeg in windows10,How solve it ? [duplicate]

  25 septembre 2020, par lslboy

  I build a win32 version FFmpeg for get the .dll and .lib file in windows10 follow the https://trac.ffmpeg.org/wiki/CompilationGuide/WinRT document, I executed the command

  


      ../../../configure \
--toolchain=msvc \
--disable-programs \
--disable-d3d11va \
--disable-dxva2 \
--arch=x86 \
--enable-shared \
--enable-cross-compile \
--target-os=win32 \
--extra-cflags="-MD -DWINAPI_FAMILY=WINAPI_FAMILY_APP -D_WIN32_WINNT=0x0A00" \
--extra-ldflags="-APPCONTAINER WindowsApp.lib" \
--prefix=../../../Build/Windows10/x86


  


  everything works well, after that, I execute the command :

  


  make


  


  it shows error :

  


  \Users\LEE\Downloads\ffmpeg-snapshot\ffmpeg\Output\Windows10\x86\config.h: warning C4828: The file contains a character starting at offset 0x2da, which is invalid in the current source character set (code page 65001) .
c:\users\lee\downloads\ffmpeg-snapshot\ffmpeg\libavcodec\mf_utils.h(59): error C2143: syntax error: missing ")" (before "*")
c:\users\lee\downloads\ffmpeg-snapshot\ffmpeg\libavcodec\mf_utils.h(59): error C2143: syntax error: missing "{" (before "*")
c:\users\lee\downloads\ffmpeg-snapshot\ffmpeg\libavcodec\mf_utils.h(60): warning C4228: Non-standard extension used: Ignore the qualifier after the comma in the declarator list
c:\users\lee\downloads\ffmpeg-snapshot\ffmpeg\libavcodec\mf_utils.h(60): error C2143: syntax error: missing ";" (before "*")
c:\users\lee\downloads\ffmpeg-snapshot\ffmpeg\libavcodec\mf_utils.h(61): error C2371: “IMFActivate”: redefinition; different base types
C:\Program Files (x86)\Windows Kits\10\Include\10.0.14393.0\um\mfobjects.h(184): note: see the statement of "IMFActivate"
c:\users\lee\downloads\ffmpeg-snapshot\ffmpeg\libavcodec\mf_utils.h(61): error C2143: syntax error: missing ";" (before "*")
c:\users\lee\downloads\ffmpeg-snapshot\ffmpeg\libavcodec\mf_utils.h(61): warning C4142: "UINT32": benign redefinition of types
C:\Program Files (x86)\Windows Kits\10\Include\10.0.14393.0\shared\basetsd.h(81): note: see the statement of "UINT32"
c:\users\lee\downloads\ffmpeg-snapshot\ffmpeg\libavcodec\mf_utils.h(61): error C2370: “UINT32”: redefinition; different storage class
C:\Program Files (x86)\Windows Kits\10\Include\10.0.14393.0\shared\basetsd.h(81): note: see the statement of "UINT32"
c:\users\lee\downloads\ffmpeg-snapshot\ffmpeg\libavcodec\mf_utils.h(61): error C2059: syntax error: ")"
c:\users\lee\downloads\ffmpeg-snapshot\ffmpeg\libavcodec\mf_utils.h(166): error C2143: syntax error: missing ")" (before "*")
c:\users\lee\downloads\ffmpeg-snapshot\ffmpeg\libavcodec\mf_utils.h(166): error C2081: "MFT_REGISTER_TYPE_INFO": The name in the formal parameter table is illegal
c:\users\lee\downloads\ffmpeg-snapshot\ffmpeg\libavcodec\mf_utils.h(166): error C2143: syntax error: missing "{" (before "*")
c:\users\lee\downloads\ffmpeg-snapshot\ffmpeg\libavcodec\mf_utils.h(167): error C2143: syntax error: missing ";" (before "*")
c:\users\lee\downloads\ffmpeg-snapshot\ffmpeg\libavcodec\mf_utils.h(168): error C2059: syntax error: "type"
c:\users\lee\downloads\ffmpeg-snapshot\ffmpeg\libavcodec\mf_utils.h(168): error C2059: syntax error: ")"
C:/Users/LEE/Downloads/ffmpeg-snapshot/ffmpegbavcodec/mf_utils.c(54): error C2143: syntax error: missing ")" (before "*")
C:/Users/LEE/Downloads/ffmpeg-snapshot/ffmpegbavcodec/mf_utils.c(54): error C2143: syntax error: missing "{" (before "*")
C:/Users/LEE/Downloads/ffmpeg-snapshot/ffmpegbavcodec/mf_utils.c(55): warning C4228: Non-standard extension used: Ignore the qualifier after the comma in the declarator list
C:/Users/LEE/Downloads/ffmpeg-snapshot/ffmpegbavcodec/mf_utils.c(55): error C2143: syntax error: missing ";" (before "*")
C:/Users/LEE/Downloads/ffmpeg-snapshot/ffmpegbavcodec/mf_utils.c(56): error C2371: “IMFActivate”: redefinition; different base types
C:\Program Files (x86)\Windows Kits\10\Include\10.0.14393.0\um\mfobjects.h(184): note: see the statement of "IMFActivate"
C:/Users/LEE/Downloads/ffmpeg-snapshot/ffmpegbavcodec/mf_utils.c(56): error C2143: syntax error: missing ";" (before "*")
C:/Users/LEE/Downloads/ffmpeg-snapshot/ffmpegbavcodec/mf_utils.c(56): warning C4142: "UINT32": benign redefinition of types
C:\Program Files (x86)\Windows Kits\10\Include\10.0.14393.0\shared\basetsd.h(81): note: see the statement of "UINT32"
C:/Users/LEE/Downloads/ffmpeg-snapshot/ffmpegbavcodec/mf_utils.c(56): error C2370: “UINT32”: redefinition; different storage class
C:\Program Files (x86)\Windows Kits\10\Include\10.0.14393.0\shared\basetsd.h(81): note: see the statement of "UINT32"
C:/Users/LEE/Downloads/ffmpeg-snapshot/ffmpegbavcodec/mf_utils.c(56): error C2059: syntax error: ")"
C:/Users/LEE/Downloads/ffmpeg-snapshot/ffmpegbavcodec/mf_utils.c(57): error C2054: "(" should be entered after "pnumMFTActivate"
C:/Users/LEE/Downloads/ffmpeg-snapshot/ffmpegbavcodec/mf_utils.c(584): error C2143: syntax error: missing ")" (before "*")
C:/Users/LEE/Downloads/ffmpeg-snapshot/ffmpegbavcodec/mf_utils.c(584): error C2081: "MFT_REGISTER_TYPE_INFO": The name in the formal parameter table is illegal
C:/Users/LEE/Downloads/ffmpeg-snapshot/ffmpegbavcodec/mf_utils.c(584): error C2143: syntax error: missing "{" (before "*")
C:/Users/LEE/Downloads/ffmpeg-snapshot/ffmpegbavcodec/mf_utils.c(585): error C2143: syntax error: missing ";" (before "*")
C:/Users/LEE/Downloads/ffmpeg-snapshot/ffmpegbavcodec/mf_utils.c(586): error C2059: syntax error: "type"
C:/Users/LEE/Downloads/ffmpeg-snapshot/ffmpegbavcodec/mf_utils.c(587): error C2059: syntax error: ")"
make: *** [/c/Users/LEE/Downloads/ffmpeg-snapshot/ffmpeg/ffbuild/common.mak:67: libavcodec/mf_utils.o] Error 2


  


  I don't know why, could you help me,thanks !

  


• How to concat 2 FLAC files using ffmpeg version 3.4.8 [duplicate]

  19 septembre 2020, par Armstrong Soo

  I am trying to concatenate 2 flac files in Ubuntu via CLI. The first flac file is "mynameis.flac", which contains the audio of "My name is" and lasts 2.66 sec. The second flac file is "stt_VNFKEY.fac" that contains audio of a name that last 1.9 sec. After a successful concatenation, I expect the output "test.flac" should contain an audio of about 3.56 sec (2.66+1.9). However, the following command only yield the "mynameis" in the output. What do I need to do to concat both flacs ?

  


  ffmpeg -i mynameis.flac -i stt_VNFKEY.flac test.flac


ffmpeg version 3.4.8-0ubuntu0.2 Copyright (c) 2000-2020 the FFmpeg developers
  built with gcc 7 (Ubuntu 7.5.0-3ubuntu1~18.04)
  configuration: --prefix=/usr --extra-version=0ubuntu0.2 --toolchain=hardened --libdir=/usr/lib/x86_64-linux-gnu --incdir=/usr/include/x86_64-linux-gnu --enable-gpl --disable-stripping --enable-avresample --enable-avisynth --enable-gnutls --enable-ladspa --enable-libass --enable-libbluray --enable-libbs2b --enable-libcaca --enable-libcdio --enable-libflite --enable-libfontconfig --enable-libfreetype --enable-libfribidi --enable-libgme --enable-libgsm --enable-libmp3lame --enable-libmysofa --enable-libopenjpeg --enable-libopenmpt --enable-libopus --enable-libpulse --enable-librubberband --enable-librsvg --enable-libshine --enable-libsnappy --enable-libsoxr --enable-libspeex --enable-libssh --enable-libtheora --enable-libtwolame --enable-libvorbis --enable-libvpx --enable-libwavpack --enable-libwebp --enable-libx265 --enable-libxml2 --enable-libxvid --enable-libzmq --enable-libzvbi --enable-omx --enable-openal --enable-opengl --enable-sdl2 --enable-libdc1394 --enable-libdrm --enable-libiec61883 --enable-chromaprint --enable-frei0r --enable-libopencv --enable-libx264 --enable-shared
  libavutil      55. 78.100 / 55. 78.100
  libavcodec     57.107.100 / 57.107.100
  libavformat    57. 83.100 / 57. 83.100
  libavdevice    57. 10.100 / 57. 10.100
  libavfilter     6.107.100 /  6.107.100
  libavresample   3.  7.  0 /  3.  7.  0
  libswscale      4.  8.100 /  4.  8.100
  libswresample   2.  9.100 /  2.  9.100
  libpostproc    54.  7.100 / 54.  7.100
Input #0, flac, from 'mynameis.flac':
  Duration: 00:00:02.66, start: 0.000000, bitrate: 108 kb/s
    Stream #0:0: Audio: flac, 16000 Hz, mono, s16
Input #1, flac, from 'stt_VNFKEY.flac':
  Duration: 00:00:01.90, start: 0.000000, bitrate: 87 kb/s
    Stream #1:0: Audio: flac, 16000 Hz, mono, s16
File 'test.flac' already exists. Overwrite ? [y/N] y
Stream mapping:
  Stream #0:0 -> #0:0 (flac (native) -> flac (native))
Press [q] to stop, [?] for help
Output #0, flac, to 'test.flac':
  Metadata:
    encoder         : Lavf57.83.100
    Stream #0:0: Audio: flac, 16000 Hz, mono, s16, 128 kb/s
    Metadata:
      encoder         : Lavc57.107.100 flac
size=      36kB time=00:00:02.66 bitrate= 110.3kbits/s speed= 881x
video:0kB audio:28kB subtitle:0kB other streams:0kB global headers:0kB muxing overhead: 29.205723%