Recherche avancée

Sur d’autres sites (6008)

• Anomalie #4737 : Erreur recherche dans les forums dans le privé

  9 juillet 2021, par JLuc -

  Avec ou sans "plat", le SQL généré est :
  

  <span class="CodeRay"><span class="class">SELECT</span> forum.id_forum, resultats.points <span class="keyword">AS</span> points, forum.statut
  <span class="keyword">FROM</span> spip_forum <span class="keyword">AS</span> <span class="string"><span class="delimiter">`</span><span class="content">forum</span><span class="delimiter">`</span></span>  
  <span class="keyword">INNER</span> <span class="keyword">JOIN</span> spip_resultats <span class="keyword">AS</span> resultats <span class="keyword">ON</span> ( resultats.id = forum.id_forum )
  <span class="keyword">WHERE</span> <span class="keyword">NOT</span>((forum.statut <span class="keyword">LIKE</span> <span class="string"><span class="delimiter">'</span><span class="content">priv%</span><span class="delimiter">'</span></span>))
      <span class="keyword">AND</span> (resultats.recherche=<span class="string"><span class="delimiter">'</span><span class="content">c7b4cacf770e2915</span><span class="delimiter">'</span></span> <span class="keyword">AND</span> resultats.table_objet=<span class="string"><span class="delimiter">'</span><span class="content">forum</span><span class="delimiter">'</span></span> <span class="keyword">AND</span> resultats.serveur=<span class="string"><span class="delimiter">'</span><span class="delimiter">'</span></span>)
  <span class="keyword">GROUP</span> <span class="keyword">BY</span> forum.id_forum
  <span class="keyword">ORDER</span> <span class="keyword">BY</span> forum.id_forum <span class="directive">DESC</span>
  </span>
  Télécharger

  Le pb vient du fait que c’est le forum id_thread qui est enregistré dans la table spip_resultats.

• Anomalie #3418 : Les tables des plugins ne s’installent pas

  9 mai 2015, par Maïeul Rouquette

  Ma config local

  PHP Version 5.2.17

  System Darwin FTSR22998 12.6.0 Darwin Kernel Version 12.6.0 : Wed Mar 18 16:23:48 PDT 2015 ; root:xnu-2050.48.19 1/RELEASE_X86_64 x86_64
  Build Date Sep 18 2013 13:58:06
  Configure Command ’./configure’ ’—with-mysql=/Applications/MAMP/Library’ ’—with-apxs2=/Applications/MAMP/Library/bin/apxs’ ’—with-gd’ ’—with-jpeg-dir=/Applications/MAMP/Library’ ’—with-png-dir=/Applications/MAMP/Library’ ’—with-zlib’ ’—with-freetype-dir=/Applications/MAMP/Library’ ’—prefix=/Applications/MAMP/bin/php/php5.2.17’ ’—exec-prefix=/Applications/MAMP/bin/php/php5.2.17’ ’—sysconfdir=/Applications/MAMP/bin/php/php5.2.17/conf’ ’—with-soap’ ’—with-config-file-path=/Applications/MAMP/bin/php/php5.2.17/conf’ ’—enable-track-vars’ ’—enable-bcmath’ ’—enable-ftp’ ’—enable-gd-native-ttf’ ’—with-bz2=/usr’ ’—with-ldap’ ’—with-mysqli=/Applications/MAMP/Library/bin/mysql_config’ ’—with-sqlite’ ’—with-ttf’ ’—with-t1lib=/Applications/MAMP/Library’ ’—enable-mbstring=all’ ’—with-curl=/Applications/MAMP/Library’ ’—enable-dbx’ ’—enable-sockets’ ’—enable-bcmath’ ’—with-imap=shared,/Applications/MAMP/Library/lib/imap-2007f’ ’—enable-soap’ ’—with-kerberos’ ’—enable-calendar’ ’—with-pgsql=shared,/Applications/MAMP/Library/pg’ ’—enable-dbase’ ’—enable-exif’ ’—with-libxml-dir=/Applications/MAMP/Library’ ’—with-gettext=shared,/Applications/MAMP/Library’ ’—with-xsl=/Applications/MAMP/Library’ ’—with-pdo-mysql=shared,/Applications/MAMP/Library’ ’—with-pdo-pgsql=shared,/Applications/MAMP/Library/pg’ ’—with-mcrypt=shared,/Applications/MAMP/Library’ ’—with-openssl’ ’—enable-zip’ ’—with-iconv=/Applications/MAMP/Library’
  Server API Apache 2.0 Handler
  Virtual Directory Support disabled
  Configuration File (php.ini) Path /Applications/MAMP/bin/php/php5.2.17/conf
  Loaded Configuration File /Applications/MAMP/bin/php/php5.2.17/conf/php.ini
  Scan this dir for additional .ini files (none)
  additional .ini files parsed (none)
  PHP API 20041225
  PHP Extension 20060613
  Zend Extension 220060519
  Debug Build no
  Thread Safety disabled
  Zend Memory Manager enabled
  IPv6 Support enabled
  Registered PHP Streams https, ftps, compress.zlib, compress.bzip2, php, file, data, http, ftp, zip
  Registered Stream Socket Transports tcp, udp, unix, udg, ssl, sslv3, sslv2, tls
  Registered Stream Filters zlib.*, bzip2.*, convert.iconv.*, string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed

  Mon test
  1) spip 3.1 svn 22109
  2) pas de plugins/auto mais le flux déclaré
  3) plugin tickets mis manuellement dans plugins
  4) j’active le plugin. Il se "préactive" en entendance les dépendances
  5) lorsque j’installe saisies, le plugin tickets peut bien s’activer
  6) mais les tables n’ont pas été installées

• avformat : make avformat_network_init() explicitly optional

  16 janvier 2018, par wm4

  avformat : make avformat_network_init() explicitly optional
  It was sort of optional before - if you didn't call it, networking was
  
  initialized on demand, and an ugly warning was logged. Also, the doxygen
  
  comments threatened that it would be made strictly required one day.
  Make it explicitly optional. I would prefer to deprecate it fully, but
  
  there might still be legitimate reasons to use this. But the average
  
  user won't need it.
  This is needed only for two reasons : to initialize TLS libraries like
  
  OpenSSL and GnuTLS, and winsock.
  OpenSSL and GnuTLS were already silently initialized on demand if the
  
  global network init function was not called. They also have various
  
  thread-safety acrobatics, which make concurrent initialization within
  
  libavformat safe. In addition, the libraries are moving towards making
  
  their global init functions safe, which removes all need for central
  
  global init. In particular, GnuTLS 3.5.16 and OpenSSL 1.1.0g have been
  
  found to have safe init functions. In all cases, they use internal
  
  reference counters to avoid that the global uninit functions interfere
  
  with concurrent uses of the library by other API users who called global
  
  init.
  winsock should be thread-safe as well, and maintains an internal
  
  reference counter as well.
  Since we still support ancient TLS libraries, which do not have this
  
  fixed, and since it's unknown whether winsock and GnuTLS
  
  reinitialization is costly in any way, don't deprecate the libavformat
  
  functions yet.
  

  • [DH] doc/APIchanges
  • [DH] libavformat/avformat.h
  • [DH] libavformat/network.c
  • [DH] libavformat/network.h
  • [DH] libavformat/utils.c
  • [DH] libavformat/version.h