CyberRota Analysis
AI-GeneratedThe vulnerability affects SPIP versions prior to 4.4.18, specifically in the public sitemap endpoint, where an unauthenticated blind SQL injection can be exploited due to improper escaping of date-type values. Attackers can leverage this flaw to execute crafted SQL queries, potentially exposing sensitive database information, including critical secrets used for signing actions. Organizations using affected SPIP versions should prioritize patching to mitigate the risk of data breaches and unauthorized access.
Original NVD Description
SPIP before 4.4.18 contains an unauthenticated blind SQL injection vulnerability in the public sitemap endpoint where the MySQL escaper spip_mysql_cite() in ecrire/req/mysql.php returns values unescaped when the target column is a date type and the supplied value matches the pattern of a word character followed by an open parenthesis. Attackers can supply a crafted value such as a time-based payload through the annee parameter in squelettes-dist/sitemap.xml.html to embed arbitrary SQL directly into the generated query, enabling time-based and boolean-based blind SQL injection that can expose arbitrary database content including the alea_ephemere secret used to sign action nonces.