
Recherche avancée
Médias (1)
-
La conservation du net art au musée. Les stratégies à l’œuvre
26 mai 2011
Mis à jour : Juillet 2013
Langue : français
Type : Texte
Autres articles (51)
-
Personnaliser les catégories
21 juin 2013, parFormulaire de création d’une catégorie
Pour ceux qui connaissent bien SPIP, une catégorie peut être assimilée à une rubrique.
Dans le cas d’un document de type catégorie, les champs proposés par défaut sont : Texte
On peut modifier ce formulaire dans la partie :
Administration > Configuration des masques de formulaire.
Dans le cas d’un document de type média, les champs non affichés par défaut sont : Descriptif rapide
Par ailleurs, c’est dans cette partie configuration qu’on peut indiquer le (...) -
Ajouter notes et légendes aux images
7 février 2011, parPour pouvoir ajouter notes et légendes aux images, la première étape est d’installer le plugin "Légendes".
Une fois le plugin activé, vous pouvez le configurer dans l’espace de configuration afin de modifier les droits de création / modification et de suppression des notes. Par défaut seuls les administrateurs du site peuvent ajouter des notes aux images.
Modification lors de l’ajout d’un média
Lors de l’ajout d’un média de type "image" un nouveau bouton apparait au dessus de la prévisualisation (...) -
Contribute to translation
13 avril 2011You can help us to improve the language used in the software interface to make MediaSPIP more accessible and user-friendly. You can also translate the interface into any language that allows it to spread to new linguistic communities.
To do this, we use the translation interface of SPIP where the all the language modules of MediaSPIP are available. Just subscribe to the mailing list and request further informantion on translation.
MediaSPIP is currently available in French and English (...)
Sur d’autres sites (11086)
-
Anomalie #4603 (Nouveau) : Des erreurs dans les logs en php 8
7 novembre 2020, par Franck DHello :)
Laragon avec :
Php 8.0.0RC3 (VS16 x64 Non Thread Safe) https://windows.php.net/qa
Apache 2.4.46 Win64 avec mod_fcgid-2.3.10-win64-VS16 https://www.apachelounge.com/download/
Mysql 8.0.22 (mysql-8.0.22-winx64.zip) https://dev.mysql.com/downloads/mysql/
phpMyAdmin 5.0.4 https://www.phpmyadmin.netInstallation en MySQL
Prefix des tables à l’installation : "test12"
SPIP 3.3.0-dev GIT [master : 6f148242]Juste pour dire que si je fais une sauvegarde, cela semble fonctionner correctement y compris la restauration, mais si je regarde le log "sqlite.log" j’ai dedans :
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L2837:executer_requete()::Pri:debug : PDOException : SQLSTATE[HY000] : General error : 1 no such table : spip_articles
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L2859:executer_requete()::Pri:ERREUR : SQLSTATE[HY000] : General error : 1 no such table : spip_articles in C :\laragon\www\test12\ecrire\req\sqlite_generique.php line 2835 -
DELETE FROM spip_articles
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L857:spip_sqlite_errno()::Pri:ERREUR : Erreur sqlite HY000 / 1
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L857:spip_sqlite_errno()::Pri:ERREUR : Erreur sqlite HY000 / 1
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L2837:executer_requete()::Pri:debug : PDOException : SQLSTATE[HY000] : General error : 1 no such table : spip_auteurs
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L2859:executer_requete()::Pri:ERREUR : SQLSTATE[HY000] : General error : 1 no such table : spip_auteurs in C :\laragon\www\test12\ecrire\req\sqlite_generique.php line 2835 -
DELETE FROM spip_auteurs
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L857:spip_sqlite_errno()::Pri:ERREUR : Erreur sqlite HY000 / 1
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L857:spip_sqlite_errno()::Pri:ERREUR : Erreur sqlite HY000 / 1
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L2837:executer_requete()::Pri:debug : PDOException : SQLSTATE[HY000] : General error : 1 no such table : spip_auteurs_liens
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L2859:executer_requete()::Pri:ERREUR : SQLSTATE[HY000] : General error : 1 no such table : spip_auteurs_liens in C :\laragon\www\test12\ecrire\req\sqlite_generique.php line 2835 -
DELETE FROM spip_auteurs_liens
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L857:spip_sqlite_errno()::Pri:ERREUR : Erreur sqlite HY000 / 1
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L857:spip_sqlite_errno()::Pri:ERREUR : Erreur sqlite HY000 / 1
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L2837:executer_requete()::Pri:debug : PDOException : SQLSTATE[HY000] : General error : 1 no such table : spip_breves
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L2859:executer_requete()::Pri:ERREUR : SQLSTATE[HY000] : General error : 1 no such table : spip_breves in C :\laragon\www\test12\ecrire\req\sqlite_generique.php line 2835 -
DELETE FROM spip_breves
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L857:spip_sqlite_errno()::Pri:ERREUR : Erreur sqlite HY000 / 1
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L857:spip_sqlite_errno()::Pri:ERREUR : Erreur sqlite HY000 / 1
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L2837:executer_requete()::Pri:debug : PDOException : SQLSTATE[HY000] : General error : 1 no such table : spip_depots
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L2859:executer_requete()::Pri:ERREUR : SQLSTATE[HY000] : General error : 1 no such table : spip_depots in C :\laragon\www\test12\ecrire\req\sqlite_generique.php line 2835 -
DELETE FROM spip_depots
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L857:spip_sqlite_errno()::Pri:ERREUR : Erreur sqlite HY000 / 1
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L857:spip_sqlite_errno()::Pri:ERREUR : Erreur sqlite HY000 / 1
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L2837:executer_requete()::Pri:debug : PDOException : SQLSTATE[HY000] : General error : 1 no such table : spip_depots_plugins
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L2859:executer_requete()::Pri:ERREUR : SQLSTATE[HY000] : General error : 1 no such table : spip_depots_plugins in C :\laragon\www\test12\ecrire\req\sqlite_generique.php line 2835 -
DELETE FROM spip_depots_plugins
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L857:spip_sqlite_errno()::Pri:ERREUR : Erreur sqlite HY000 / 1
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L857:spip_sqlite_errno()::Pri:ERREUR : Erreur sqlite HY000 / 1
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L2837:executer_requete()::Pri:debug : PDOException : SQLSTATE[HY000] : General error : 1 no such table : spip_documents
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L2859:executer_requete()::Pri:ERREUR : SQLSTATE[HY000] : General error : 1 no such table : spip_documents in C :\laragon\www\test12\ecrire\req\sqlite_generique.php line 2835 -
DELETE FROM spip_documents
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L857:spip_sqlite_errno()::Pri:ERREUR : Erreur sqlite HY000 / 1
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L857:spip_sqlite_errno()::Pri:ERREUR : Erreur sqlite HY000 / 1
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L2837:executer_requete()::Pri:debug : PDOException : SQLSTATE[HY000] : General error : 1 no such table : spip_documents_liens
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L2859:executer_requete()::Pri:ERREUR : SQLSTATE[HY000] : General error : 1 no such table : spip_documents_liens in C :\laragon\www\test12\ecrire\req\sqlite_generique.php line 2835 -
DELETE FROM spip_documents_liens
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L857:spip_sqlite_errno()::Pri:ERREUR : Erreur sqlite HY000 / 1
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L857:spip_sqlite_errno()::Pri:ERREUR : Erreur sqlite HY000 / 1
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L2837:executer_requete()::Pri:debug : PDOException : SQLSTATE[HY000] : General error : 1 no such table : spip_forum
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L2859:executer_requete()::Pri:ERREUR : SQLSTATE[HY000] : General error : 1 no such table : spip_forum in C :\laragon\www\test12\ecrire\req\sqlite_generique.php line 2835 -
DELETE FROM spip_forum
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L857:spip_sqlite_errno()::Pri:ERREUR : Erreur sqlite HY000 / 1
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L857:spip_sqlite_errno()::Pri:ERREUR : Erreur sqlite HY000 / 1
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L2837:executer_requete()::Pri:debug : PDOException : SQLSTATE[HY000] : General error : 1 no such table : spip_groupes_mots
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L2859:executer_requete()::Pri:ERREUR : SQLSTATE[HY000] : General error : 1 no such table : spip_groupes_mots in C :\laragon\www\test12\ecrire\req\sqlite_generique.php line 2835 -
DELETE FROM spip_groupes_mots
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L857:spip_sqlite_errno()::Pri:ERREUR : Erreur sqlite HY000 / 1
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L857:spip_sqlite_errno()::Pri:ERREUR : Erreur sqlite HY000 / 1
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L2837:executer_requete()::Pri:debug : PDOException : SQLSTATE[HY000] : General error : 1 no such table : spip_jobs
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L2859:executer_requete()::Pri:ERREUR : SQLSTATE[HY000] : General error : 1 no such table : spip_jobs in C :\laragon\www\test12\ecrire\req\sqlite_generique.php line 2835 -
DELETE FROM spip_jobs
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L857:spip_sqlite_errno()::Pri:ERREUR : Erreur sqlite HY000 / 1
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L857:spip_sqlite_errno()::Pri:ERREUR : Erreur sqlite HY000 / 1
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L2837:executer_requete()::Pri:debug : PDOException : SQLSTATE[HY000] : General error : 1 no such table : spip_jobs_liens
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L2859:executer_requete()::Pri:ERREUR : SQLSTATE[HY000] : General error : 1 no such table : spip_jobs_liens in C :\laragon\www\test12\ecrire\req\sqlite_generique.php line 2835 -
DELETE FROM spip_jobs_liens
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L857:spip_sqlite_errno()::Pri:ERREUR : Erreur sqlite HY000 / 1
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L857:spip_sqlite_errno()::Pri:ERREUR : Erreur sqlite HY000 / 1
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L2837:executer_requete()::Pri:debug : PDOException : SQLSTATE[HY000] : General error : 1 no such table : spip_messages
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L2859:executer_requete()::Pri:ERREUR : SQLSTATE[HY000] : General error : 1 no such table : spip_messages in C :\laragon\www\test12\ecrire\req\sqlite_generique.php line 2835 -
DELETE FROM spip_messages
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L857:spip_sqlite_errno()::Pri:ERREUR : Erreur sqlite HY000 / 1
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L857:spip_sqlite_errno()::Pri:ERREUR : Erreur sqlite HY000 / 1
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L2837:executer_requete()::Pri:debug : PDOException : SQLSTATE[HY000] : General error : 1 no such table : spip_mots
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L2859:executer_requete()::Pri:ERREUR : SQLSTATE[HY000] : General error : 1 no such table : spip_mots in C :\laragon\www\test12\ecrire\req\sqlite_generique.php line 2835 -
DELETE FROM spip_mots
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L857:spip_sqlite_errno()::Pri:ERREUR : Erreur sqlite HY000 / 1
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L857:spip_sqlite_errno()::Pri:ERREUR : Erreur sqlite HY000 / 1
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L2837:executer_requete()::Pri:debug : PDOException : SQLSTATE[HY000] : General error : 1 no such table : spip_mots_liens
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L2859:executer_requete()::Pri:ERREUR : SQLSTATE[HY000] : General error : 1 no such table : spip_mots_liens in C :\laragon\www\test12\ecrire\req\sqlite_generique.php line 2835 -
DELETE FROM spip_mots_liens
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L857:spip_sqlite_errno()::Pri:ERREUR : Erreur sqlite HY000 / 1
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L857:spip_sqlite_errno()::Pri:ERREUR : Erreur sqlite HY000 / 1
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L2837:executer_requete()::Pri:debug : PDOException : SQLSTATE[HY000] : General error : 1 no such table : spip_paquets
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L2859:executer_requete()::Pri:ERREUR : SQLSTATE[HY000] : General error : 1 no such table : spip_paquets in C :\laragon\www\test12\ecrire\req\sqlite_generique.php line 2835 -
DELETE FROM spip_paquets
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L857:spip_sqlite_errno()::Pri:ERREUR : Erreur sqlite HY000 / 1
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L857:spip_sqlite_errno()::Pri:ERREUR : Erreur sqlite HY000 / 1
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L2837:executer_requete()::Pri:debug : PDOException : SQLSTATE[HY000] : General error : 1 no such table : spip_petitions
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L2859:executer_requete()::Pri:ERREUR : SQLSTATE[HY000] : General error : 1 no such table : spip_petitions in C :\laragon\www\test12\ecrire\req\sqlite_generique.php line 2835 -
DELETE FROM spip_petitions
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L857:spip_sqlite_errno()::Pri:ERREUR : Erreur sqlite HY000 / 1
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L857:spip_sqlite_errno()::Pri:ERREUR : Erreur sqlite HY000 / 1
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L2837:executer_requete()::Pri:debug : PDOException : SQLSTATE[HY000] : General error : 1 no such table : spip_plugins
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L2859:executer_requete()::Pri:ERREUR : SQLSTATE[HY000] : General error : 1 no such table : spip_plugins in C :\laragon\www\test12\ecrire\req\sqlite_generique.php line 2835 -
DELETE FROM spip_plugins
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L857:spip_sqlite_errno()::Pri:ERREUR : Erreur sqlite HY000 / 1
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L857:spip_sqlite_errno()::Pri:ERREUR : Erreur sqlite HY000 / 1
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L2837:executer_requete()::Pri:debug : PDOException : SQLSTATE[HY000] : General error : 1 no such table : spip_rubriques
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L2859:executer_requete()::Pri:ERREUR : SQLSTATE[HY000] : General error : 1 no such table : spip_rubriques in C :\laragon\www\test12\ecrire\req\sqlite_generique.php line 2835 -
DELETE FROM spip_rubriques
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L857:spip_sqlite_errno()::Pri:ERREUR : Erreur sqlite HY000 / 1
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L857:spip_sqlite_errno()::Pri:ERREUR : Erreur sqlite HY000 / 1
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L2837:executer_requete()::Pri:debug : PDOException : SQLSTATE[HY000] : General error : 1 no such table : spip_signatures
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L2859:executer_requete()::Pri:ERREUR : SQLSTATE[HY000] : General error : 1 no such table : spip_signatures in C :\laragon\www\test12\ecrire\req\sqlite_generique.php line 2835 -
DELETE FROM spip_signatures
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L857:spip_sqlite_errno()::Pri:ERREUR : Erreur sqlite HY000 / 1
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L857:spip_sqlite_errno()::Pri:ERREUR : Erreur sqlite HY000 / 1
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L2837:executer_requete()::Pri:debug : PDOException : SQLSTATE[HY000] : General error : 1 no such table : spip_syndic
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L2859:executer_requete()::Pri:ERREUR : SQLSTATE[HY000] : General error : 1 no such table : spip_syndic in C :\laragon\www\test12\ecrire\req\sqlite_generique.php line 2835 -
DELETE FROM spip_syndic
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L857:spip_sqlite_errno()::Pri:ERREUR : Erreur sqlite HY000 / 1
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L857:spip_sqlite_errno()::Pri:ERREUR : Erreur sqlite HY000 / 1
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L2837:executer_requete()::Pri:debug : PDOException : SQLSTATE[HY000] : General error : 1 no such table : spip_syndic_articles
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L2859:executer_requete()::Pri:ERREUR : SQLSTATE[HY000] : General error : 1 no such table : spip_syndic_articles in C :\laragon\www\test12\ecrire\req\sqlite_generique.php line 2835 -
DELETE FROM spip_syndic_articles
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L857:spip_sqlite_errno()::Pri:ERREUR : Erreur sqlite HY000 / 1
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L857:spip_sqlite_errno()::Pri:ERREUR : Erreur sqlite HY000 / 1
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L2837:executer_requete()::Pri:debug : PDOException : SQLSTATE[HY000] : General error : 1 no such table : spip_types_documents
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L2859:executer_requete()::Pri:ERREUR : SQLSTATE[HY000] : General error : 1 no such table : spip_types_documents in C :\laragon\www\test12\ecrire\req\sqlite_generique.php line 2835 -
DELETE FROM spip_types_documents
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L857:spip_sqlite_errno()::Pri:ERREUR : Erreur sqlite HY000 / 1
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L857:spip_sqlite_errno()::Pri:ERREUR : Erreur sqlite HY000 / 1
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L2837:executer_requete()::Pri:debug : PDOException : SQLSTATE[HY000] : General error : 1 no such table : spip_urls
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L2859:executer_requete()::Pri:ERREUR : SQLSTATE[HY000] : General error : 1 no such table : spip_urls in C :\laragon\www\test12\ecrire\req\sqlite_generique.php line 2835 -
DELETE FROM spip_urls
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L857:spip_sqlite_errno()::Pri:ERREUR : Erreur sqlite HY000 / 1
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L857:spip_sqlite_errno()::Pri:ERREUR : Erreur sqlite HY000 / 1
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L2837:executer_requete()::Pri:debug : PDOException : SQLSTATE[HY000] : General error : 1 no such table : spip_versions
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L2859:executer_requete()::Pri:ERREUR : SQLSTATE[HY000] : General error : 1 no such table : spip_versions in C :\laragon\www\test12\ecrire\req\sqlite_generique.php line 2835 -
DELETE FROM spip_versions
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L857:spip_sqlite_errno()::Pri:ERREUR : Erreur sqlite HY000 / 1
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L857:spip_sqlite_errno()::Pri:ERREUR : Erreur sqlite HY000 / 1
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L2837:executer_requete()::Pri:debug : PDOException : SQLSTATE[HY000] : General error : 1 no such table : spip_versions_fragments
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L2859:executer_requete()::Pri:ERREUR : SQLSTATE[HY000] : General error : 1 no such table : spip_versions_fragments in C :\laragon\www\test12\ecrire\req\sqlite_generique.php line 2835 -
DELETE FROM spip_versions_fragments
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L857:spip_sqlite_errno()::Pri:ERREUR : Erreur sqlite HY000 / 1
2020-11-07 17:39:17 ::1 (pid 18348) C :\laragon\www\test12\ecrire\req\sqlite_generique.php:L857:spip_sqlite_errno()::Pri:ERREUR : Erreur sqlite HY000 / 1Franck
-
What are all the codecs and formats not supported by FFmpeg ?
4 mars 2020, par Alexander SwannWe are building a service where we do not know what format/codec a video uploaded by a user is in. Due to the nature of the application, we expect input video formats to be very fragmented, diverse and niche. We are currently using FFmpeg to transcode input formats to a consistent output (e.g. mp4).
Due to the above scenario, I would like to establish a general list of what formats and codecs are not currently supported by FFmpeg. This is so I can research other open source video transcoding tools which I can utilise to fill in the gaps and allow our service to be more reliable for the user.
Are there resources online that can help at least get a general idea of what might not be supported by FFmpeg ?
-
Nginx rtmp module - on_publish fires multiple time instead of once
29 juillet 2017, par Stephen WrightThis is copy and pasted from the bug report I created on the rtmp-module by Arut, I am not completely sure if it is a bug or me not understanding how the module works, I have read the whole directives of module as from https://github.com/arut/nginx-rtmp-module/wiki/Directives
Proper explanation, if code is not displayed properly I will edit and fix
Hi, been using the module and finding it very very good !
Think I have found a issue though, although it may be me misunderstanding the directives.
Essentially I wish to fire a script (/usr/local/bin/make_thumbnail.sh) which creates a thumbnail automatically from a stream (using ffmpeg), the idea is to have this done for every stream as soon as it is published in order to create a function a bit like twitch tv where the streamer will not have to specify any thumbnail image, authenticated users simply start a stream (which will later be authenticated but is not yet) The script does also write data into the database however this stage works fine and I don’t believe the issue is related, if I comment out these lines then the thumbnail creation still works and my issue continues.
Initially this was done using the "exec" command as I believe I mis-read the documentation and I believe the exec command doesn’t work for my problem as ". When publishing stops the process is terminated." does this mean it will continually execute until stream stops ?
I have started using the exec_publish command to try and fix this issue however the same issue seems to occur. The entire script repeats approximately every 15-17 seconds, a new thumbnail is created and a new database entry is create with all the correct information.
Below is the nginx.conf line. Please ignore if indentation is incorrect couldn’t see a way to indent blocks of code and it’s late here, assume all code is indented correctly unless you believe that could be the issue in which case I will post it indented as early as I can.
application live {
allow play all;
live on;
record all;
record_path /var/stream/video_recordings/;
record_unique on;
hls on;
hls_nested on;
hls_path /var/stream/HLS/live;
hls_fragment 10s;
#on publish create thumbnail using first second of stream and save in
/var/stream/video_recordings/thumbnails
exec_publish usr/local/bin/make_thumbnail.sh $name;The rest can be pasted or attached if needed but is working nginx config for rtmp + website
The most simple version of the make_thumbnail..sh is pasted below, I have omitted the variables that I have used for database entryys obviously but as the script works without fail from terminal I believe this to be an nginx issue (if I run the command manually under the nginx user e.g. sudo -u nginx /usr/local/bin/make_thumbnail.sh with a name the same as any running stream, it works and only executes once as would expect, all permissions in script are ok and tested.
make_thumbnail.sh
#!/bin/bash
TIME=$(date +%s)
NAME=$1
echo "time: "
FILENAME=${TIME}_${NAME}
ffmpeg -i rtmp://192.168.0.98:1935/live/$1 -vframes 1 -s 150x150 -ss 10 -
strftime 1 /var/stream/video_recordings/thumbnails/"$FILENAME.jpg";
#Writes path to video into database
mysql --user=$DB_USER --password=$DB_PASSWD $DB_NAME << EOF
INSERT INTO $TABLE3 (thumbnailfile) VALUES ('$FILENAME');
set @last_id_in_thumbnails = LAST_INSERT_ID();
INSERT INTO $TABLE (created_at, updated_at, thumnailID) VALUES
(NOW(),NOW(),@last_id_in_thumbnails);
SET @last_id_in_livestreams = LAST_INSERT_ID();
INSERT INTO $TABLE2 (created_at, updated_at, filename,liveID) VALUES
(NOW(),NOW(),'$FILENAME',@last_id_in_livestreams);
EOFI have not got the nginx rtmp logs installed, I can obviously do this however some of the logs appear in the nginx error.log, strangely the latest stream I tried did not update in the access log, however I think this is because I did not attempt to connect to it via any method. I don’t fully understand the error.log, in my stupidity I decided to use nginx with which I am quite inexperienced and I am finding it very difficult to troubleshoot this issue, it appears to me that as part of the RTMP protocol or my streaming software (OBS) is either directly pinging the rtmp stream or is being pinged by the server to ensure the connection is still there. And this ping is
I have left a stream running from approx 4 minutes without interacting with the server, streaming software, computer running the stream, I have ensured the internet connection is constant as my first though was the connection dropped, however on inspecting the database the executing is done always after at least 11 seconds however usually this is 16, I can’t seem to figure out how to select the closest dates from the database however there has been at least a few 17 second differences (potentially when
I am unsure if this is an issue or if it is intended behavior but I do require this to finish a university degree, I’m not asking for answers but if it is a legitimate issue then I would be happy to spend as much time I can commit to it if some insight into what is causing it, or if there is a workaround I believe it should be documented somewhere, I have googled into making any exec commands run only once on publishI can’t seem to pinpoint where in the log the issue is happening however think it is something to do with the below exceprts I would attach the file but can’t seem to select all lines after the timestamp upon starting a stream
2017/07/26 18:17:35 [info] 1451#0: *2229 exec: starting managed child
'ffmpeg', client: 192.168.0.78, server: 0.0.0.0:1935
2017/07/26 18:17:35 [info] 1451#0: *2412 client connected '192.168.0.98'
2017/07/26 18:17:35 [info] 1451#0: *2412 connect: app='live' args=''
flashver='LNX 9,0,124,2' swf_url='' tc_url='rtmp://192.168.0.98:1935/live'
page_url='' acodecs=4071 vcodecs=252 object_encoding=0, client:
192.168.0.98, server: 0.0.0.0:1935
2017/07/26 18:17:35 [info] 1451#0: *2412 createStream, client: 192.168.0.98,
server: 0.0.0.0:1935
2017/07/26 18:17:35 [info] 1451#0: *2412 play: name='newname' args=''
start=-2000 duration=0 reset=0 silent=0, client: 192.168.0.98, server:
0.0.0.0:1935
2017/07/26 18:17:36 [info] 1451#0: *2410 recv() failed (104: Connection
reset by peer), client: 192.168.0.98, server: 0.0.0.0:1935
2017/07/26 18:17:36 [info] 1451#0: *2410 disconnect, client: 192.168.0.98,
server: 0.0.0.0:1935
2017/07/26 18:17:36 [info] 1451#0: *2410 deleteStream, client: 192.168.0.98,
server: 0.0.0.0:1935
2017/07/26 18:17:36 [notice] 1451#0: signal 17 (SIGCHLD) received
2017/07/26 18:17:36 [notice] 1451#0: unknown process 10487 exited with code
0
2017/07/26 18:17:36 [info] 1451#0: *2229 exec: child 10487 exited; ignoring,
client: 192.168.0.78, server: 0.0.0.0:1935
ver: 0.0.0.0:1935
2017/07/26 18:17:41 [info] 1451#0: *2229 exec: starting managed child
'usr/local/bin/make_thumbnail.sh', client: 192.168.0.78, server:
0.0.0.0:1935
2017/07/26 18:17:41 [info] 1451#0: *2413 client connected '192.168.0.98'
2017/07/26 18:17:41 [info] 1451#0: *2413 connect: app='live' args=''
flashver='LNX 9,0,124,2' swf_url='' tc_url='rtmp://192.168.0.98:1935/live'
page_url='' acodecs=4071 vcodecs=252 object_encoding=0, client:
192.168.0.98,
server: 0.0.0.0:1935
2017/07/26 18:17:41 [info] 1451#0: *2413 createStream, client: 192.168.0.98,
server: 0.0.0.0:1935
2017/07/26 18:17:41 [info] 1451#0: *2413 play: name='newname' args=''
start=-2000 duration=0 reset=0 silent=0, client: 192.168.0.98, server:
0.0.0.0:1935
2017/07/26 18:17:43 [info] 1451#0: *2229 exec: starting managed child
'ffmpeg',
client: 192.168.0.78, server: 0.0.0.0:1935
2017/07/26 18:17:43 [info] 1451#0: *2414 client connected '192.168.0.98'
2017/07/26 18:17:43 [info] 1451#0: *2414 connect: app='live' args=''
flashver='LNX 9,0,124,2' swf_url='' tc_url='rtmp://192.168.0.98:1935/live'
page_url='' acodecs=4071 vcodecs=252 object_encoding=0, client:
192.168.0.98,
server: 0.0.0.0:1935
@