Recherche avancée

Sur d’autres sites (6610)

• Anomalie #4522 (En cours) : erreur en php 8 dans mysql.log

  14 juillet 2020, par Franck D

  Hello :)

  Windows 10 (1909)
  Firefox 78.0.2
  Easyphp
  Apache 2.4.43 x64
  PHP 8.0.0 alpha1 x64
  MySQL 8.0.20 x64
  PhpMyAdmin 5.0.2
  Prefix des tables "spip5"
  Je fais tout afficher via mes_options, j’installe spip 3.3 ensuite, je regarde les logs de la table mysql.log et cela m’affiche 5 erreurs ( à voir si ce n’est pas "normal" quand même, car cela semble fonctionner quand même)

  2020-07-14 14:48:35 127.0.0.1 (pid 1576) C :\Program Files (x86)\EasyPHP-Devserver-17\eds-www\test5\ecrire\base\connect_sql.php:L170:spip_sql_erreur()::Pub:ERREUR : Erreur 1525 de mysql : Incorrect TIMESTAMP value : ’’2020-07-13 14:48:35’’
  in C :\Program Files (x86)\EasyPHP-Devserver-17\eds-www\test5\plugins-dist\forum\forum_pipelines.php L308 [sql_delete(),forum_optimiser_base_disparus(),minipipe(),execute_pipeline_optimiser_base_disparus(),pipeline(),optimiser_base_disparus(),optimiser_base(),genie_optimiser_dist(),queue_start_job(),queue_schedule(),inc_genie_dist(),cron(),action_cron(),traiter_appels_actions(),include()]
  DELETE FROM `spip`.spip5_forum
  WHERE statut=’redac’ AND maj < ’\’2020-07-13 14:48:35\’’

  2020-07-14 14:48:35 127.0.0.1 (pid 1576) C :\Program Files (x86)\EasyPHP-Devserver-17\eds-www\test5\ecrire\base\connect_sql.php:L170:spip_sql_erreur()::Pub:ERREUR : Erreur 1525 de mysql : Incorrect TIMESTAMP value : ’’2020-07-13 14:48:35’’
  in C :\Program Files (x86)\EasyPHP-Devserver-17\eds-www\test5\plugins-dist\mots\mots_pipelines.php L97 [sql_delete(),mots_optimiser_base_disparus(),minipipe(),execute_pipeline_optimiser_base_disparus(),pipeline(),optimiser_base_disparus(),optimiser_base(),genie_optimiser_dist(),queue_start_job(),queue_schedule(),inc_genie_dist(),cron(),action_cron(),traiter_appels_actions(),include()]
  DELETE FROM `spip`.spip5_mots
  WHERE length(titre)=0 AND maj < ’\’2020-07-13 14:48:35\’’

  2020-07-14 14:48:35 127.0.0.1 (pid 1576) C :\Program Files (x86)\EasyPHP-Devserver-17\eds-www\test5\ecrire\base\connect_sql.php:L170:spip_sql_erreur()::Pub:ERREUR : Erreur 1525 de mysql : Incorrect TIMESTAMP value : ’’2020-07-13 14:48:35’’
  in C :\Program Files (x86)\EasyPHP-Devserver-17\eds-www\test5\plugins-dist\petitions\petitions_pipelines.php L78 [sql_delete(),petitions_optimiser_base_disparus(),minipipe(),execute_pipeline_optimiser_base_disparus(),pipeline(),optimiser_base_disparus(),optimiser_base(),genie_optimiser_dist(),queue_start_job(),queue_schedule(),inc_genie_dist(),cron(),action_cron(),traiter_appels_actions(),include()]
  DELETE FROM `spip`.spip5_petitions
  WHERE statut=’poubelle’ AND maj < ’\’2020-07-13 14:48:35\’’

  2020-07-14 14:48:35 127.0.0.1 (pid 1576) C :\Program Files (x86)\EasyPHP-Devserver-17\eds-www\test5\ecrire\base\connect_sql.php:L170:spip_sql_erreur()::Pub:ERREUR : Erreur 1525 de mysql : Incorrect TIMESTAMP value : ’’2020-07-13 14:48:35’’
  in C :\Program Files (x86)\EasyPHP-Devserver-17\eds-www\test5\plugins-dist\sites\sites_pipelines.php L228 [sql_delete(),sites_optimiser_base_disparus(),minipipe(),execute_pipeline_optimiser_base_disparus(),pipeline(),optimiser_base_disparus(),optimiser_base(),genie_optimiser_dist(),queue_start_job(),queue_schedule(),inc_genie_dist(),cron(),action_cron(),traiter_appels_actions(),include()]
  DELETE FROM `spip`.spip5_syndic
  WHERE maj<’\’2020-07-13 14:48:35\’’ AND statut=’refuse’

  2020-07-14 14:48:35 127.0.0.1 (pid 1576) C :\Program Files (x86)\EasyPHP-Devserver-17\eds-www\test5\ecrire\base\connect_sql.php:L170:spip_sql_erreur()::Pub:ERREUR : Erreur 1525 de mysql : Incorrect TIMESTAMP value : ’’2020-07-13 14:48:35’’
  in C :\Program Files (x86)\EasyPHP-Devserver-17\eds-www\test5\plugins-dist\breves\breves_pipelines.php L298 [sql_select(),breves_optimiser_base_disparus(),minipipe(),execute_pipeline_optimiser_base_disparus(),pipeline(),optimiser_base_disparus(),optimiser_base(),genie_optimiser_dist(),queue_start_job(),queue_schedule(),inc_genie_dist(),cron(),action_cron(),traiter_appels_actions(),include()]
  SELECT B.id_breve AS id
  FROM `spip`.spip5_breves AS B
  LEFT JOIN `spip`.spip5_rubriques AS R
  ON B.id_rubrique=R.id_rubrique
  WHERE R.id_rubrique IS NULL
  AND B.maj < ’\’2020-07-13 14:48:35\’’

• ffmpeg : simple RTMP streaming over LAN

  30 mars 2013, par sajad

  I am trying to launch up a rtmp transcoder server using ffmpeg ; that receives udp MPEG-TS streams as input, transcodes it ; and generates an rtmp output to a URL, that can be accessed by users to receive and play the rtmp stream. All these are expected to be performed in a LAN and the output be accessed by all users.

  1) First I don't know where the URL should point to. Is it enought to specify the IP of the system and some optional port ? Is it neccessary that a program should be listening on that port ?

  2) How I can play the stream on the URL ?

  I use a linux ubuntu machine whith IP=10.1.1.229 and I want to transcode multicast stream on this URL : udp://@224.10.1.1:2001.

  here is the command used to transcode input stream and generate rtmp url "rtmp ://10.1.1.229:2020".

  ffmpeg -y -f mpegts -i "udp://@224.10.1.1:2001" -re -vcodec libx264 -maxrate 700k -r 25 -s 640x360 -deinterlace -acodec libfaac -ab 64k -ac 1 -ar 44100 -f flv "rtmp://10.1.1.229:2020"

  and here is the command by which I am trying to play rtmp stream :

  ffplay rtmp://10.1.1.229:2020

  Any guidance would be helpfull. Thank you.

• ffmpeg : simple RTMP streaming

  2 avril 2013, par sajad

  I am trying to launch up a rtmp transcoder server using ffmpeg ; that receives udp MPEG-TS streams as input, transcodes it ; and generates an rtmp output to a URL, that can be accessed by users to receive and play the rtmp stream. All these are expected to be performed in a LAN and the output be accessed by all users.

  1) First I don't know where the URL should point to. Is it enought to specify the IP of the system and some optional port ? Is it neccessary that a program should be listening on that port ?

  2) How I can play the stream on the URL ?

  I use a linux ubuntu machine whith IP=10.1.1.229 and I want to transcode multicast stream on this URL : udp://@224.10.1.1:2001.

  here is the command used to transcode input stream and generate rtmp url "rtmp ://10.1.1.229:2020".

  ffmpeg -y -f mpegts -i "udp://@224.10.1.1:2001" -re -vcodec libx264 -maxrate 700k -r 25 -s 640x360 -deinterlace -acodec libfaac -ab 64k -ac 1 -ar 44100 -f flv "rtmp://10.1.1.229:2020"

  and here is the command by which I am trying to play rtmp stream :

  ffplay rtmp://10.1.1.229:2020

  Any guidance would be helpfull. Thank you.