Summary
CVE-2026-79569 is a critical SQL injection vulnerability in Movie_Recommend v1.0.0, affecting the sort parameter of the /loadingmore endpoint (and the related /typesortmovie endpoint). Unauthenticated attackers can inject arbitrary SQL via unsanitized ORDER BY clause construction, leading to full compromise of confidentiality, integrity, and availability of the backing database. The vulnerability carries a CVSS v3.1 base score of 9.8 (Critical).
Technical details
- Root cause: The application reads the
sortrequest parameter viarequest.getParameter("sort")and concatenates it directly into a MyBatis-mapped SQL statement (order by ${sort} desc) instead of using a parameterized/bound value. The unsafe concatenation occurs inMovieMapper.xml(around lines 333–342), with the tainted input passed through fromIndexController.java(around lines 172–202). - Trigger conditions: No authentication or session is required to reach the vulnerable endpoints, and the application does not appear to implement any request-level authorization framework (e.g., Spring Security, Shiro, Sa-Token) in front of them.
- Attack vector: Remote, unauthenticated HTTP POST requests to
/Movie/loadingmore(and/typesortmovie) with a craftedsortparameter value. The underlying MySQL connection is reportedly configured withallowMultiQueries=true, which permits stacked/batched SQL queries in addition to standard UNION/subquery-based injection. - Impact: Demonstrated proof-of-concept techniques include time-based blind injection (e.g.,
sort=numrating,(SELECT SLEEP(5))) to confirm the flaw, and error-based extraction (e.g.,sort=numrating desc,(SELECT extractvalue(1,concat(0x7e,database())))) to disclose the database name, version, and current user. Given stacked-query support, the flaw could plausibly be extended to broader data exfiltration, modification, or destruction of database contents, and potentially further host compromise depending on database privileges.
Affected software
- Movie_Recommend v1.0.0 — vulnerable
sortparameter handling in the/loadingmoreand/typesortmovieendpoints.
Severity
- CVSS v3.1 Base Score: 9.8 (Critical)
- Vector:
CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H - CWE: CWE-89 (SQL Injection)
Mitigation and recommended actions
- Immediate: No official vendor patch has been identified for this open-source project at the time of publication. Organizations running Movie_Recommend v1.0.0 should treat this as unpatched and prioritize remediation.
- Workarounds / network mitigations:
- Refactor the affected MyBatis mapper queries to use parameter binding (
#{sort}) with a strict server-side allow-list of valid sort column names/directions instead of raw string interpolation (${sort}). - Disable
allowMultiQuerieson the MySQL JDBC connection string unless explicitly required, to reduce the impact of any residual injection points. - Restrict or disable public/unauthenticated access to the
/loadingmoreand/typesortmovieendpoints where feasible, and place a web application firewall (WAF) in front of the application to filter SQL injection patterns as an interim compensating control. - Monitor database and application logs for anomalous query patterns, extended response times, or SQL error messages that may indicate exploitation attempts.
- Refactor the affected MyBatis mapper queries to use parameter binding (

