Mon Commerce OpenStreetMap

Statistiques - 59668 Zuydcoote - 33% complété

Population : 1 608

1 lieu pour 62 habitants

0 / 26 lieux avec note

Budget annuel : 2 638 728 €

Budget par habitant : 1 641 €

Dernier labourage : 15/07/2025 19:40(il y a 2 jours)

Thèmes

Catégorie	Thème	Nombre	Complétion	Évolution	Graphique
🚨 Urgence	Bornes incendie	0	0%	0 0%
	Défibrillateurs	2	75%	0 0%
🚌 Transport	Arrêts de bus	8	75%	0 +25%
	Bornes de recharge	1	0%	0 0%
	Parkings vélos	8	94%	0 0%
🏥 Santé	Lieux de santé	4	25%	0 0%
	Laboratoires d'analyse	0	0%	0 0%
	Eau potable	0	0%	0 0%
🎓 Éducation	Écoles	1	67%	0 0%
🛡️ Sécurité	Commissariats	0	0%	0 0%
	Caméras de surveillance	1	100%	0 0%
🏗️ Infrastructure	Toilettes publiques	1	0%	0 0%
	Points de recyclage	3	100%	0 0%
	Sous-stations électriques	9	89%	0 0%

Bornes incendie

0 | 0%

Bornes de recharge

1 | 0%

Toilettes publiques

1 | 0%

8 | 75%

Défibrillateurs

2 | 75%

Caméras de surveillance

1 | 100%

Points de recyclage

3 | 100%

Sous-stations électriques

9 | 89%

Laboratoires d'analyse

0 | 0%

1 | 67%

0 | 0%

Lieux de santé

4 | 25%

Parkings vélos

8 | 94%

Panneaux électoraux

0 | 0%

1387 | 100%

0 | 0%

Objets avec email

5 | 80%

7 | 50%

1 | 0%

0 | 0%

0 | 0%

1 | 0%

20 | 33%

Poteaux électriques

0 | 0%

Bouche d'égout

0 | 0%

Micro bibliothèque

0 | 0%

Parc à jeux pour enfants

0 | 0%

Bornes incendie

Critères de complétion attendus :

ref
colour

Bornes de recharge

Critères de complétion attendus :

charging_station:output
capacity

Toilettes publiques

Critères de complétion attendus :

wheelchair
access

Arrêts de bus

Critères de complétion attendus :

shelter
network
highway
public_transport

Défibrillateurs

Critères de complétion attendus :

indoor
access

Caméras de surveillance

Critères de complétion attendus :

surveillance:type

Points de recyclage

Critères de complétion attendus :

recycling_type

Sous-stations électriques

Critères de complétion attendus :

substation

Laboratoires d'analyse

Critères de complétion attendus :

website
contact:website
name
phone

Écoles

Critères de complétion attendus :

ref:UAI
isced:level
school:FR

Commissariats

Critères de complétion attendus :

phone
website

Lieux de santé

Critères de complétion attendus :

name
contact:phone
phone
email
contact:email

Parkings vélos

Critères de complétion attendus :

capacity
covered

Panneaux électoraux

Critères de complétion attendus :

operator
contact:phone

Bâtiments

Critères de complétion attendus :

building

RNB

Critères de complétion attendus :

building
ref:FR:RNB

Objets avec email

Critères de complétion attendus :

name
phone

Bancs

Critères de complétion attendus :

material
backrest

Poubelles

Critères de complétion attendus :

waste
recycling_type

Lampadaires

Critères de complétion attendus :

lamp_type
height

Eau potable

Critères de complétion attendus :

covered
ref

Arbres

Critères de complétion attendus :

species
leaf_type
leaf_cycle

Lieux

Critères de complétion attendus :

name
address
opening_hours
website
phone
wheelchair
siret

Poteaux électriques

Critères de complétion attendus :

ref
material

Bouche d'égout

Critères de complétion attendus :

manhole
location

Micro bibliothèque

Critères de complétion attendus :

amenity
operator

Parc à jeux pour enfants

Critères de complétion attendus :

playground
operator

33 % complété sur les critères donnés.

26 lieux dans la zone.

5 lieux avec horaires.

4 lieux avec adresse.

8 lieux avec site web renseigné.

3 lieux avec accessibilité PMR renseignée.

0 lieux avec note renseignée.

Carte

Graphiques

Fréquence des mises à jour par trimestre pour Zuydcoote

Données OpenStreetMap

Évolution du taux de complétion

Tableau des 26 lieux

Export Overpass CSV Export Tableau CSV

Nom (26)	Email	Contenu email	Completion %	Type	Adresse (4 / 26)	Numéro	Rue	Site web (8 / 26)	Accès PMR (3 / 26)	Note ? (0 / 26)	Texte de la note	Siret	Siret clos	Dernière modif. OSM	Osm id	Osm kind	Lieux par habitants
Point d'informations touristiques		-	0	🏷️			(inconnue)						0.016		2021-06-02 11:56 Danalieth73 4 ans , 1 mois		node
(sans nom)		-	0	🏷️			(inconnue)						0.016		2023-08-17 21:53 Mateusz Konieczny - bot account 1 an , 11 mois		node
Le Galion		-	40	🍽️	1	2	Rue du Général de Gaulle	1					0.016		2021-09-01 11:23 Danalieth73 3 ans , 10 mois		node
Laverie des Dunes		-	0	🏷️			(inconnue)						0.016		2024-03-16 16:54 olecky 1 an , 4 mois		node
(sans nom)		-	0	🏷️			(inconnue)						0.016		2021-09-05 22:08 Danalieth73 3 ans , 10 mois		node
(sans nom)		-	0	🏷️			(inconnue)						0.016		2021-09-05 22:08 Danalieth73 3 ans , 10 mois		node
Base nautique du Sémaphore		-	0	🏷️			(inconnue)						0.016		2024-04-03 16:21 Danalieth73 1 an , 3 mois		node
La Grande Marée		contact@lagrandemaree.com	40	🍽️	1	147	Rue de Valenciennes	1					0.016		2022-11-09 18:16 ThomasDu 2 ans , 8 mois		node
Glace et gaufres		-	0	🏷️			(inconnue)						0.016		2022-07-07 20:05 Mizuna 3 ans		node
La cabane aux délices		-	40	🍽️	1	3	Place de la Gare						0.016		2023-07-07 14:43 pneff 2 ans		node
Kotje		-	0	🍽️			(inconnue)						0.016		2024-03-16 16:54 olecky 1 an , 4 mois		node
ADEELI - CPIE Flandre Maritime (Bureaux)		contact@cpieflandremaritime.fr	60	🏷️			(inconnue)	1	1				0.016		2024-04-05 07:36 Danalieth73 1 an , 3 mois		node
Association pour le Développement de l’Education à l’Environnement sur le Littoral - Centre permanent d'initiatives pour l'environnement Flandre Maritime		-	0	🏷️			Rue Jean Delvallez						0.016		2025-02-03 15:28 VLD528 5 mois , 14 jours		node
Aldi		-	60	🛒			Avenue de la Ferme Fonteyne	1	1			40309364401221	0.016		2025-07-12 13:29 michel60 5 jours		node
Camping Zuydcoote Beach		-	20	🏷️			(inconnue)	1					0.016		2023-07-16 14:17 Niels Elgaard Larsen 2 ans		way
Camping de l'Estran		-	40	🏷️			(inconnue)	1					0.016		2023-07-16 14:17 Niels Elgaard Larsen 2 ans		way
Hôpital Maritime de Zuydcoote		-	20	🏷️			(inconnue)	1					0.016		2024-05-06 17:32 Westpfeil 1 an , 2 mois		way
Pharmacie Mesurolle		-	0	🏷️			(inconnue)						0.016		2023-08-17 21:53 Mateusz Konieczny - bot account 1 an , 11 mois		way
Au Joyeux Retour des Pêcheurs		-	0	🍽️			(inconnue)						0.016		2014-05-14 15:18 Pichasso 11 ans , 2 mois		way
Mairie de Zuydcoote		mairie@villedezuydcoote.fr	80	🏛️	1	118	Rue du Général de Gaulle	1	1			21590668600013	0.016		2025-05-17 17:13 nlehuby 2 mois , 1 jour		way
Le Galion		-	40	🍽️	1	2	Rue du Général de Gaulle	1					0.016		2021-09-01 11:23 Danalieth73 3 ans , 10 mois		node
La Grande Marée		contact@lagrandemaree.com	40	🍽️	1	147	Rue de Valenciennes	1					0.016		2022-11-09 18:16 ThomasDu 2 ans , 8 mois		node
La cabane aux délices		-	40	🍽️	1	3	Place de la Gare						0.016		2023-07-07 14:43 pneff 2 ans		node
ADEELI - CPIE Flandre Maritime (Bureaux)		contact@cpieflandremaritime.fr	60	🏷️			(inconnue)	1	1				0.016		2024-04-05 07:36 Danalieth73 1 an , 3 mois		node
Association pour le Développement de l’Education à l’Environnement sur le Littoral - Centre permanent d'initiatives pour l'environnement Flandre Maritime		-	0	🏷️			Rue Jean Delvallez						0.016		2025-02-03 15:28 VLD528 5 mois , 14 jours		node
Mairie de Zuydcoote		mairie@villedezuydcoote.fr	80	🏛️	1	118	Rue du Général de Gaulle	1	1			21590668600013	0.016		2025-05-17 17:13 nlehuby 2 mois , 1 jour		way

Podium des contributeurs OSM de cette ville

#	Utilisateur OSM	Nombre de lieux	Score de complétion moyen	Score de complétion pondéré	Score pondéré normalisé (0-100)
1	Danalieth73	8	25 %	200	100
2	nlehuby	2	80 %	160	80
3	ThomasDu	2	40 %	80	40
4	pneff	2	40 %	80	40
5	Niels Elgaard Larsen	2	30 %	60	30
6	michel60	1	60 %	60	30
7	Westpfeil	1	20 %	20	10
8	Mateusz Konieczny - bot account	2	0 %	0	0
9	olecky	2	0 %	0	0
10	VLD528	2	0 %	0	0
11	Mizuna	1	0 %	0	0
12	Pichasso	1	0 %	0	0

Comment est calculé le score de complétion ?

Tester les JSON Complète tes commerces

unlink(): Argument #1 ($filename) must not contain any null bytes (500 Internal Server Error)

Symfony Exception

ValueError

HTTP 500 Internal Server Error

unlink(): Argument #1 ($filename) must not contain any null bytes

Exception

ValueError

in vendor/symfony/http-kernel/Profiler/FileProfilerStorage.php (line 341)

if ($csvTime >= $minimalProfileTimestamp) {
break;
}
@unlink($this->getFilename($csvToken));
$offset += \strlen($line);
}
fclose($handle);
file_put_contents($file.'.offset', $offset);

in vendor/symfony/http-kernel/Profiler/FileProfilerStorage.php unlink (line 341)

if ($csvTime >= $minimalProfileTimestamp) {
break;
}
@unlink($this->getFilename($csvToken));
$offset += \strlen($line);
}
fclose($handle);
file_put_contents($file.'.offset', $offset);

in vendor/symfony/http-kernel/Profiler/FileProfilerStorage.php -> removeExpiredProfiles (line 193)

$profile->getVirtualType() ?? 'request',
], ',', '"', '\\');
fclose($file);
if (1 === mt_rand(1, 10)) {
$this->removeExpiredProfiles();
}
}
return true;
}

in vendor/symfony/http-kernel/Profiler/Profiler.php -> write (line 97)

if ($collector instanceof LateDataCollectorInterface) {
$collector->lateCollect();
}
}
if (!($ret = $this->storage->write($profile)) && null !== $this->logger) {
$this->logger->warning('Unable to store the profiler information.', ['configured_storage' => $this->storage::class]);
}
return $ret;
}

in vendor/symfony/http-kernel/EventListener/ProfilerListener.php -> saveProfile (line 129)

}
}
// save profiles
foreach ($this->profiles as $request) {
$this->profiler->saveProfile($this->profiles[$request]);
}
$this->profiles = new \SplObjectStorage();
$this->parents = new \SplObjectStorage();
}

in vendor/symfony/event-dispatcher/Debug/WrappedListener.php -> onKernelTerminate (line 115)

$this->priority ??= $dispatcher->getListenerPriority($eventName, $this->listener);
$e = $this->stopwatch->start($this->name, 'event_listener');
try {
($this->optimizedListener ?? $this->listener)($event, $eventName, $dispatcher);
} finally {
if ($e->isStarted()) {
$e->stop();
}
}

in vendor/symfony/event-dispatcher/EventDispatcher.php -> __invoke (line 206)

foreach ($listeners as $listener) {
if ($stoppable && $event->isPropagationStopped()) {
break;
}
$listener($event, $eventName, $this);
}
}
/**
* Sorts the internal list of listeners for the given event by priority.

in vendor/symfony/event-dispatcher/EventDispatcher.php -> callListeners (line 56)

} else {
$listeners = $this->getListeners($eventName);
}
if ($listeners) {
$this->callListeners($listeners, $eventName, $event);
}
return $event;
}

in vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php -> dispatch (line 122)

try {
$this->beforeDispatch($eventName, $event);
try {
$e = $this->stopwatch->start($eventName, 'section');
try {
$this->dispatcher->dispatch($event, $eventName);
} finally {
if ($e->isStarted()) {
$e->stop();
}
}

in vendor/symfony/http-kernel/HttpKernel.php -> dispatch (line 114)

public function terminate(Request $request, Response $response): void
{
try {
$this->terminating = true;
$this->dispatcher->dispatch(new TerminateEvent($this, $request, $response), KernelEvents::TERMINATE);
} finally {
$this->terminating = false;
}
}

in vendor/symfony/http-kernel/Kernel.php -> terminate (line 145)

if (false === $this->booted) {
return;
}
if ($this->getHttpKernel() instanceof TerminableInterface) {
$this->getHttpKernel()->terminate($request, $response);
}
}
public function shutdown(): void
{

in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> terminate (line 53)

} else {
$response->send();
}
if ($this->kernel instanceof TerminableInterface) {
$this->kernel->terminate($this->request, $response);
}
return 0;
}
}

in vendor/autoload_runtime.php -> run (line 29)

$app = $app(...$args);
exit(
$runtime
->getRunner($app)
->run()
);

require_once('/poule/encrypted/www/osm-commerces/vendor/autoload_runtime.php') in public/index.php (line 5)

<?php
use App\Kernel;
require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
// Optimisations pour éviter les timeouts
ini_set('max_execution_time', 300);
ini_set('memory_limit', '1024M');
set_time_limit(300);

Logs 1

Level	Channel	Message
INFO 23:51:40	request	Matched route "app_admin_stats". { "route": "app_admin_stats", "route_parameters": { "_route": "app_admin_stats", "_controller": "App\\Controller\\AdminController::stats", "insee_code": "59668" }, "request_uri": "https://osm-commerces.cipherbliss.com/admin/stats/59668", "method": "GET" }
DEBUG 23:51:40	security	Checking for authenticator support. { "firewall_name": "main", "authenticators": 0 }
DEBUG 23:51:40	event	Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure". { "event": "kernel.request", "listener": "Symfony\\Component\\HttpKernel\\EventListener\\DebugHandlersListener::configure" }
DEBUG 23:51:40	event	Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest". { "event": "kernel.request", "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ValidateRequestListener::onKernelRequest" }
DEBUG 23:51:40	event	Notified event "kernel.request" to listener "Symfony\Bridge\Doctrine\Middleware\IdleConnection\Listener::onKernelRequest". { "event": "kernel.request", "listener": "Symfony\\Bridge\\Doctrine\\Middleware\\IdleConnection\\Listener::onKernelRequest" }
DEBUG 23:51:40	event	Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest". { "event": "kernel.request", "listener": "Symfony\\Component\\HttpKernel\\EventListener\\SessionListener::onKernelRequest" }
DEBUG 23:51:40	event	Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale". { "event": "kernel.request", "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::setDefaultLocale" }
DEBUG 23:51:40	event	Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest". { "event": "kernel.request", "listener": "Symfony\\Component\\HttpKernel\\EventListener\\RouterListener::onKernelRequest" }
DEBUG 23:51:40	event	Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest". { "event": "kernel.request", "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::onKernelRequest" }
DEBUG 23:51:40	event	Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest". { "event": "kernel.request", "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleAwareListener::onKernelRequest" }
DEBUG 23:51:40	event	Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator". { "event": "kernel.request", "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::configureLogoutUrlGenerator" }
DEBUG 23:51:40	event	Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest". { "event": "kernel.request", "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::onKernelRequest" }
DEBUG 23:51:40	event	Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController". { "event": "kernel.controller", "listener": "Symfony\\Bundle\\FrameworkBundle\\DataCollector\\RouterDataCollector::onKernelController" }
DEBUG 23:51:40	event	Notified event "kernel.controller" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController". { "event": "kernel.controller", "listener": "Symfony\\Component\\HttpKernel\\DataCollector\\RequestDataCollector::onKernelController" }
DEBUG 23:51:40	event	Notified event "kernel.controller_arguments" to listener "Symfony\Component\Security\Http\EventListener\IsCsrfTokenValidAttributeListener::onKernelControllerArguments". { "event": "kernel.controller_arguments", "listener": "Symfony\\Component\\Security\\Http\\EventListener\\IsCsrfTokenValidAttributeListener::onKernelControllerArguments" }
DEBUG 23:51:40	event	Notified event "kernel.controller_arguments" to listener "Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments". { "event": "kernel.controller_arguments", "listener": "Symfony\\Component\\Security\\Http\\EventListener\\IsGrantedAttributeListener::onKernelControllerArguments" }
DEBUG 23:51:40	event	Notified event "kernel.controller_arguments" to listener "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelControllerArguments". { "event": "kernel.controller_arguments", "listener": "Symfony\\Component\\HttpKernel\\EventListener\\CacheAttributeListener::onKernelControllerArguments" }
DEBUG 23:51:40	event	Notified event "kernel.controller_arguments" to listener "ContainerPiH6UMA\RequestPayloadValueResolverGhost01ca9cc::onKernelControllerArguments". { "event": "kernel.controller_arguments", "listener": "ContainerPiH6UMA\\RequestPayloadValueResolverGhost01ca9cc::onKernelControllerArguments" }
DEBUG 23:51:40	event	Notified event "kernel.controller_arguments" to listener "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments". { "event": "kernel.controller_arguments", "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ErrorListener::onControllerArguments" }
INFO 23:51:40	doctrine	Connecting with parameters {params} { "params": { "use_savepoints": true, "driver": "pdo_mysql", "idle_connection_ttl": 600, "host": "127.0.0.1", "port": 3306, "user": "sf", "password": "<redacted>", "driverOptions": { "1002": "SET NAMES utf8mb4", "1000": true, "PDO::ATTR_TIMEOUT": 300, "PDO::ATTR_PERSISTENT": false, "PDO::MYSQL_ATTR_USE_BUFFERED_QUERY": true, "PDO::MYSQL_ATTR_INIT_COMMAND": "SET SESSION wait_timeout=300, interactive_timeout=300" }, "defaultTableOptions": [], "dbname": "osm-my-commerce", "serverVersion": "15", "charset": "utf8" } }
DEBUG 23:51:40	doctrine	Executing statement: SELECT t0.id AS id_1, t0.zone AS zone_2, t0.completion_percent AS completion_percent_3, t0.places_count AS places_count_4, t0.avec_horaires AS avec_horaires_5, t0.avec_adresse AS avec_adresse_6, t0.avec_site AS avec_site_7, t0.avec_accessibilite AS avec_accessibilite_8, t0.avec_note AS avec_note_9, t0.name AS name_10, t0.population AS population_11, t0.siren AS siren_12, t0.code_epci AS code_epci_13, t0.codes_postaux AS codes_postaux_14, t0.date_created AS date_created_15, t0.date_modified AS date_modified_16, t0.avec_siret AS avec_siret_17, t0.avec_name AS avec_name_18, t0.osm_data_date_min AS osm_data_date_min_19, t0.osm_data_date_avg AS osm_data_date_avg_20, t0.osm_data_date_max AS osm_data_date_max_21, t0.budget_annuel AS budget_annuel_22, t0.lat AS lat_23, t0.lon AS lon_24, t0.date_labourage_requested AS date_labourage_requested_25, t0.date_labourage_done AS date_labourage_done_26 FROM stats t0 WHERE t0.zone = ? LIMIT 1 (parameters: {params}, types: {types})
DEBUG 23:51:40	doctrine	Executing statement: SELECT t0.id AS id_1, t0.name AS name_2, t0.measure AS measure_3, t0.date AS date_4, t0.stats_id AS stats_id_5 FROM city_follow_up t0 WHERE t0.stats_id = ? (parameters: {params}, types: {types})
DEBUG 23:51:40	doctrine	Beginning transaction
DEBUG 23:51:40	doctrine	Executing statement: INSERT INTO action_log (type, data, created_at, from_url, who) VALUES (?, ?, ?, ?, ?) (parameters: {params}, types: {types})
DEBUG 23:51:40	doctrine	Committing transaction
DEBUG 23:51:40	doctrine	Executing statement: SELECT s0_.id AS id_0, s0_.places_count AS places_count_1, s0_.emails_count AS emails_count_2, s0_.completion_percent AS completion_percent_3, s0_.emails_sent AS emails_sent_4, s0_.date AS date_5, s0_.names_count AS names_count_6, s0_.opening_hours_count AS opening_hours_count_7, s0_.website_count AS website_count_8, s0_.address_count AS address_count_9, s0_.siret_count AS siret_count_10, s0_.stats_id AS stats_id_11 FROM stats_history s0_ WHERE s0_.stats_id = ? ORDER BY s0_.id DESC LIMIT 100 (parameters: {params}, types: {types})
DEBUG 23:51:40	doctrine	Executing statement: SELECT t0.id AS id_1, t0.uuid_for_url AS uuid_for_url_2, t0.osm_kind AS osm_kind_3, t0.email AS email_4, t0.opted_out AS opted_out_5, t0.dead AS dead_6, t0.note AS note_7, t0.modified_date AS modified_date_8, t0.zip_code AS zip_code_9, t0.asked_humains_support AS asked_humains_support_10, t0.last_contact_attempt_date AS last_contact_attempt_date_11, t0.osm_id AS osm_id_12, t0.name AS name_13, t0.has_opening_hours AS has_opening_hours_14, t0.has_address AS has_address_15, t0.has_website AS has_website_16, t0.has_wheelchair AS has_wheelchair_17, t0.has_note AS has_note_18, t0.main_tag AS main_tag_19, t0.note_content AS note_content_20, t0.displayed_date AS displayed_date_21, t0.lat AS lat_22, t0.lon AS lon_23, t0.street AS street_24, t0.housenumber AS housenumber_25, t0.siret AS siret_26, t0.habitants AS habitants_27, t0.osm_data_date AS osm_data_date_28, t0.osm_version AS osm_version_29, t0.osm_user AS osm_user_30, t0.osm_uid AS osm_uid_31, t0.osm_changeset AS osm_changeset_32, t0.email_content AS email_content_33, t0.place_count AS place_count_34, t0.stats_id AS stats_id_35 FROM place t0 WHERE t0.stats_id = ? (parameters: {params}, types: {types})
DEBUG 23:51:40	doctrine	Executing statement: SELECT p0_.osm_user AS osm_user_0, COUNT(p0_.id) AS sclr_1, AVG((CASE WHEN p0_.has_opening_hours = 1 THEN 1 ELSE 0 END) + (CASE WHEN p0_.has_address = 1 THEN 1 ELSE 0 END) + (CASE WHEN p0_.has_website = 1 THEN 1 ELSE 0 END) + (CASE WHEN p0_.has_wheelchair = 1 THEN 1 ELSE 0 END) + (CASE WHEN p0_.has_note = 1 THEN 1 ELSE 0 END)) / 5 * 100 AS sclr_2 FROM place p0_ WHERE p0_.osm_user IS NOT NULL AND p0_.osm_user <> '' AND p0_.stats_id = ? GROUP BY p0_.osm_user ORDER BY sclr_1 DESC LIMIT 100 (parameters: {params}, types: {types})
DEBUG 23:51:40	event	Notified event "kernel.response" to listener "Symfony\Component\Security\Csrf\SameOriginCsrfTokenManager::onKernelResponse". { "event": "kernel.response", "listener": "Symfony\\Component\\Security\\Csrf\\SameOriginCsrfTokenManager::onKernelResponse" }
DEBUG 23:51:40	event	Notified event "kernel.response" to listener "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse". { "event": "kernel.response", "listener": "Symfony\\Component\\Security\\Http\\Firewall\\ContextListener::onKernelResponse" }
DEBUG 23:51:40	event	Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse". { "event": "kernel.response", "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ResponseListener::onKernelResponse" }
DEBUG 23:51:40	event	Notified event "kernel.response" to listener "Symfony\Component\WebLink\EventListener\AddLinkHeaderListener::onKernelResponse". { "event": "kernel.response", "listener": "Symfony\\Component\\WebLink\\EventListener\\AddLinkHeaderListener::onKernelResponse" }
DEBUG 23:51:40	event	Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelResponse". { "event": "kernel.response", "listener": "Symfony\\Component\\HttpKernel\\DataCollector\\RequestDataCollector::onKernelResponse" }
DEBUG 23:51:40	event	Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelResponse". { "event": "kernel.response", "listener": "Symfony\\Component\\HttpKernel\\EventListener\\CacheAttributeListener::onKernelResponse" }
DEBUG 23:51:40	event	Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse". { "event": "kernel.response", "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ProfilerListener::onKernelResponse" }
DEBUG 23:51:40	event	Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\ErrorListener::removeCspHeader". { "event": "kernel.response", "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ErrorListener::removeCspHeader" }
DEBUG 23:51:40	event	Notified event "kernel.response" to listener "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse". { "event": "kernel.response", "listener": "Symfony\\Bundle\\WebProfilerBundle\\EventListener\\WebDebugToolbarListener::onKernelResponse" }
DEBUG 23:51:40	event	Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\DisallowRobotsIndexingListener::onResponse". { "event": "kernel.response", "listener": "Symfony\\Component\\HttpKernel\\EventListener\\DisallowRobotsIndexingListener::onResponse" }
DEBUG 23:51:40	event	Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse". { "event": "kernel.response", "listener": "Symfony\\Component\\HttpKernel\\EventListener\\SessionListener::onKernelResponse" }
DEBUG 23:51:40	event	Notified event "kernel.finish_request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelFinishRequest". { "event": "kernel.finish_request", "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::onKernelFinishRequest" }
DEBUG 23:51:40	event	Notified event "kernel.finish_request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest". { "event": "kernel.finish_request", "listener": "Symfony\\Component\\HttpKernel\\EventListener\\RouterListener::onKernelFinishRequest" }
DEBUG 23:51:40	event	Notified event "kernel.finish_request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest". { "event": "kernel.finish_request", "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::onKernelFinishRequest" }
DEBUG 23:51:40	event	Notified event "kernel.finish_request" to listener "Symfony\WebpackEncoreBundle\EventListener\ResetAssetsEventListener::resetAssets". { "event": "kernel.finish_request", "listener": "Symfony\\WebpackEncoreBundle\\EventListener\\ResetAssetsEventListener::resetAssets" }
DEBUG 23:51:40	event	Notified event "kernel.finish_request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest". { "event": "kernel.finish_request", "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleAwareListener::onKernelFinishRequest" }
CRITICAL 23:51:40	request	Uncaught PHP Exception ValueError: "unlink(): Argument #1 ($filename) must not contain any null bytes" at FileProfilerStorage.php line 341 { "exception": {} }
DEBUG 23:51:40	event	Notified event "kernel.terminate" to listener "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelTerminate". { "event": "kernel.terminate", "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ProfilerListener::onKernelTerminate" }
DEBUG 23:51:40	event	Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure". { "event": "kernel.request", "listener": "Symfony\\Component\\HttpKernel\\EventListener\\DebugHandlersListener::configure" }
DEBUG 23:51:40	event	Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest". { "event": "kernel.request", "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ValidateRequestListener::onKernelRequest" }
DEBUG 23:51:40	event	Notified event "kernel.request" to listener "Symfony\Bridge\Doctrine\Middleware\IdleConnection\Listener::onKernelRequest". { "event": "kernel.request", "listener": "Symfony\\Bridge\\Doctrine\\Middleware\\IdleConnection\\Listener::onKernelRequest" }
DEBUG 23:51:40	event	Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest". { "event": "kernel.request", "listener": "Symfony\\Component\\HttpKernel\\EventListener\\SessionListener::onKernelRequest" }
DEBUG 23:51:40	event	Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale". { "event": "kernel.request", "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::setDefaultLocale" }
DEBUG 23:51:40	event	Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest". { "event": "kernel.request", "listener": "Symfony\\Component\\HttpKernel\\EventListener\\RouterListener::onKernelRequest" }
DEBUG 23:51:40	event	Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest". { "event": "kernel.request", "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::onKernelRequest" }
DEBUG 23:51:40	event	Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest". { "event": "kernel.request", "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleAwareListener::onKernelRequest" }
DEBUG 23:51:40	event	Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator". { "event": "kernel.request", "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::configureLogoutUrlGenerator" }
DEBUG 23:51:40	event	Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest". { "event": "kernel.request", "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::onKernelRequest" }
DEBUG 23:51:40	event	Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController". { "event": "kernel.controller", "listener": "Symfony\\Bundle\\FrameworkBundle\\DataCollector\\RouterDataCollector::onKernelController" }
DEBUG 23:51:40	event	Notified event "kernel.controller" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController". { "event": "kernel.controller", "listener": "Symfony\\Component\\HttpKernel\\DataCollector\\RequestDataCollector::onKernelController" }
DEBUG 23:51:40	event	Notified event "kernel.controller_arguments" to listener "Symfony\Component\Security\Http\EventListener\IsCsrfTokenValidAttributeListener::onKernelControllerArguments". { "event": "kernel.controller_arguments", "listener": "Symfony\\Component\\Security\\Http\\EventListener\\IsCsrfTokenValidAttributeListener::onKernelControllerArguments" }
DEBUG 23:51:40	event	Notified event "kernel.controller_arguments" to listener "Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments". { "event": "kernel.controller_arguments", "listener": "Symfony\\Component\\Security\\Http\\EventListener\\IsGrantedAttributeListener::onKernelControllerArguments" }
DEBUG 23:51:40	event	Notified event "kernel.controller_arguments" to listener "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelControllerArguments". { "event": "kernel.controller_arguments", "listener": "Symfony\\Component\\HttpKernel\\EventListener\\CacheAttributeListener::onKernelControllerArguments" }
DEBUG 23:51:40	event	Notified event "kernel.controller_arguments" to listener "ContainerPiH6UMA\RequestPayloadValueResolverGhost01ca9cc::onKernelControllerArguments". { "event": "kernel.controller_arguments", "listener": "ContainerPiH6UMA\\RequestPayloadValueResolverGhost01ca9cc::onKernelControllerArguments" }
DEBUG 23:51:40	event	Notified event "kernel.controller_arguments" to listener "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments". { "event": "kernel.controller_arguments", "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ErrorListener::onControllerArguments" }

Stack Trace

ValueError

ValueError:
unlink(): Argument #1 ($filename) must not contain any null bytes

  at vendor/symfony/http-kernel/Profiler/FileProfilerStorage.php:341
  at unlink()
     (vendor/symfony/http-kernel/Profiler/FileProfilerStorage.php:341)
  at Symfony\Component\HttpKernel\Profiler\FileProfilerStorage->removeExpiredProfiles()
     (vendor/symfony/http-kernel/Profiler/FileProfilerStorage.php:193)
  at Symfony\Component\HttpKernel\Profiler\FileProfilerStorage->write()
     (vendor/symfony/http-kernel/Profiler/Profiler.php:97)
  at Symfony\Component\HttpKernel\Profiler\Profiler->saveProfile()
     (vendor/symfony/http-kernel/EventListener/ProfilerListener.php:129)
  at Symfony\Component\HttpKernel\EventListener\ProfilerListener->onKernelTerminate()
     (vendor/symfony/event-dispatcher/Debug/WrappedListener.php:115)
  at Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke()
     (vendor/symfony/event-dispatcher/EventDispatcher.php:206)
  at Symfony\Component\EventDispatcher\EventDispatcher->callListeners()
     (vendor/symfony/event-dispatcher/EventDispatcher.php:56)
  at Symfony\Component\EventDispatcher\EventDispatcher->dispatch()
     (vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php:122)
  at Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch()
     (vendor/symfony/http-kernel/HttpKernel.php:114)
  at Symfony\Component\HttpKernel\HttpKernel->terminate()
     (vendor/symfony/http-kernel/Kernel.php:145)
  at Symfony\Component\HttpKernel\Kernel->terminate()
     (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:53)
  at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
     (vendor/autoload_runtime.php:29)
  at require_once('/poule/encrypted/www/osm-commerces/vendor/autoload_runtime.php')
     (public/index.php:5)

unlink(): Argument #1 ($filename) must not contain any null bytes (500 Internal Server Error)

Symfony Exception

ValueError

HTTP 500 Internal Server Error

unlink(): Argument #1 ($filename) must not contain any null bytes

Exception

ValueError

in /poule/encrypted/www/osm-commerces/vendor/symfony/http-kernel/Profiler/FileProfilerStorage.php (line 341)

if ($csvTime >= $minimalProfileTimestamp) {
break;
}
@unlink($this->getFilename($csvToken));
$offset += \strlen($line);
}
fclose($handle);
file_put_contents($file.'.offset', $offset);

in /poule/encrypted/www/osm-commerces/vendor/symfony/http-kernel/Profiler/FileProfilerStorage.php unlink (line 341)

if ($csvTime >= $minimalProfileTimestamp) {
break;
}
@unlink($this->getFilename($csvToken));
$offset += \strlen($line);
}
fclose($handle);
file_put_contents($file.'.offset', $offset);

in /poule/encrypted/www/osm-commerces/vendor/symfony/http-kernel/Profiler/FileProfilerStorage.php -> removeExpiredProfiles (line 193)

$profile->getVirtualType() ?? 'request',
], ',', '"', '\\');
fclose($file);
if (1 === mt_rand(1, 10)) {
$this->removeExpiredProfiles();
}
}
return true;
}

in /poule/encrypted/www/osm-commerces/vendor/symfony/http-kernel/Profiler/Profiler.php -> write (line 97)

if ($collector instanceof LateDataCollectorInterface) {
$collector->lateCollect();
}
}
if (!($ret = $this->storage->write($profile)) && null !== $this->logger) {
$this->logger->warning('Unable to store the profiler information.', ['configured_storage' => $this->storage::class]);
}
return $ret;
}

in /poule/encrypted/www/osm-commerces/vendor/symfony/http-kernel/EventListener/ProfilerListener.php -> saveProfile (line 129)

}
}
// save profiles
foreach ($this->profiles as $request) {
$this->profiler->saveProfile($this->profiles[$request]);
}
$this->profiles = new \SplObjectStorage();
$this->parents = new \SplObjectStorage();
}

in /poule/encrypted/www/osm-commerces/vendor/symfony/event-dispatcher/Debug/WrappedListener.php -> onKernelTerminate (line 115)

$this->priority ??= $dispatcher->getListenerPriority($eventName, $this->listener);
$e = $this->stopwatch->start($this->name, 'event_listener');
try {
($this->optimizedListener ?? $this->listener)($event, $eventName, $dispatcher);
} finally {
if ($e->isStarted()) {
$e->stop();
}
}

in /poule/encrypted/www/osm-commerces/vendor/symfony/event-dispatcher/EventDispatcher.php -> __invoke (line 206)

foreach ($listeners as $listener) {
if ($stoppable && $event->isPropagationStopped()) {
break;
}
$listener($event, $eventName, $this);
}
}
/**
* Sorts the internal list of listeners for the given event by priority.

in /poule/encrypted/www/osm-commerces/vendor/symfony/event-dispatcher/EventDispatcher.php -> callListeners (line 56)

} else {
$listeners = $this->getListeners($eventName);
}
if ($listeners) {
$this->callListeners($listeners, $eventName, $event);
}
return $event;
}

in /poule/encrypted/www/osm-commerces/vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php -> dispatch (line 122)

try {
$this->beforeDispatch($eventName, $event);
try {
$e = $this->stopwatch->start($eventName, 'section');
try {
$this->dispatcher->dispatch($event, $eventName);
} finally {
if ($e->isStarted()) {
$e->stop();
}
}

in /poule/encrypted/www/osm-commerces/vendor/symfony/http-kernel/HttpKernel.php -> dispatch (line 114)

public function terminate(Request $request, Response $response): void
{
try {
$this->terminating = true;
$this->dispatcher->dispatch(new TerminateEvent($this, $request, $response), KernelEvents::TERMINATE);
} finally {
$this->terminating = false;
}
}

in /poule/encrypted/www/osm-commerces/vendor/symfony/http-kernel/HttpKernel.php -> terminate (line 144)

}
$response->sendHeaders();
$response->sendContent();
$this->terminate($request, $response);
}
/**
* Handles a request to convert it to a response.
*

in /poule/encrypted/www/osm-commerces/vendor/symfony/http-kernel/EventListener/DebugHandlersListener.php -> terminateWithException (line 84)

if ($hasRun) {
throw $e;
}
$hasRun = true;
$kernel->terminateWithException($e, $request);
};
}
} elseif ($event instanceof ConsoleEvent && $app = $event->getCommand()->getApplication()) {
$output = $event->getOutput();
if ($output instanceof ConsoleOutputInterface) {

in /poule/encrypted/www/osm-commerces/vendor/symfony/error-handler/ErrorHandler.php :: Symfony\Component\HttpKernel\EventListener\{closure} (line 538)

$this->exceptionHandler = null;
}
try {
if (null !== $exceptionHandler) {
$exceptionHandler($exception);
return;
}
$handlerException ??= $exception;
} catch (\Throwable $handlerException) {

ErrorHandler->handleException()

Stack Trace

ValueError

ValueError:
unlink(): Argument #1 ($filename) must not contain any null bytes

  at /poule/encrypted/www/osm-commerces/vendor/symfony/http-kernel/Profiler/FileProfilerStorage.php:341
  at unlink()
     (/poule/encrypted/www/osm-commerces/vendor/symfony/http-kernel/Profiler/FileProfilerStorage.php:341)
  at Symfony\Component\HttpKernel\Profiler\FileProfilerStorage->removeExpiredProfiles()
     (/poule/encrypted/www/osm-commerces/vendor/symfony/http-kernel/Profiler/FileProfilerStorage.php:193)
  at Symfony\Component\HttpKernel\Profiler\FileProfilerStorage->write()
     (/poule/encrypted/www/osm-commerces/vendor/symfony/http-kernel/Profiler/Profiler.php:97)
  at Symfony\Component\HttpKernel\Profiler\Profiler->saveProfile()
     (/poule/encrypted/www/osm-commerces/vendor/symfony/http-kernel/EventListener/ProfilerListener.php:129)
  at Symfony\Component\HttpKernel\EventListener\ProfilerListener->onKernelTerminate()
     (/poule/encrypted/www/osm-commerces/vendor/symfony/event-dispatcher/Debug/WrappedListener.php:115)
  at Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke()
     (/poule/encrypted/www/osm-commerces/vendor/symfony/event-dispatcher/EventDispatcher.php:206)
  at Symfony\Component\EventDispatcher\EventDispatcher->callListeners()
     (/poule/encrypted/www/osm-commerces/vendor/symfony/event-dispatcher/EventDispatcher.php:56)
  at Symfony\Component\EventDispatcher\EventDispatcher->dispatch()
     (/poule/encrypted/www/osm-commerces/vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php:122)
  at Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch()
     (/poule/encrypted/www/osm-commerces/vendor/symfony/http-kernel/HttpKernel.php:114)
  at Symfony\Component\HttpKernel\HttpKernel->terminate()
     (/poule/encrypted/www/osm-commerces/vendor/symfony/http-kernel/HttpKernel.php:144)
  at Symfony\Component\HttpKernel\HttpKernel->terminateWithException()
     (/poule/encrypted/www/osm-commerces/vendor/symfony/http-kernel/EventListener/DebugHandlersListener.php:84)
  at Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::Symfony\Component\HttpKernel\EventListener\{closure}()
     (/poule/encrypted/www/osm-commerces/vendor/symfony/error-handler/ErrorHandler.php:538)
  at Symfony\Component\ErrorHandler\ErrorHandler->handleException()