Skip to content

query error when deleting all transients #26

@DanielRuf

Description

@DanielRuf
[Sun Feb 27 14:02:33 2022] WordPress-Datenbank-Fehler <div style="clear:both">&nbsp;</div><div class="queries" style="clear:both; margin_bottom:2px; border: red dotted thin;">Queries made or created this session were<br/>
	<ol>
		<li>Raw query:
DELETE a, b FROM wp_options a, wp_options b
			WHERE a.option_name LIKE '_transient_%'
			AND a.option_name NOT LIKE '_transient_timeout_%'
			AND b.option_name = CONCAT( '_transient_timeout_', SUBSTRING( a.option_name, 12 ) )
			AND b.option_value < 1645966953</li>
		<li>Rewritten:
DELETE a, b FROM wp_options a, wp_options b
			WHERE a.option_name LIKE '_transient_%'
			AND a.option_name NOT LIKE '_transient_timeout_%'
			AND b.option_name = CONCAT( '_transient_timeout_', SUBSTRING( a.option_name, 12 ) )
			AND b.option_value < 1645966953</li>
		<li>With Placeholders:
DELETE a, b FROM wp_options a, wp_options b
			WHERE a.option_name LIKE  :param_0 
			AND a.option_name NOT LIKE  :param_1 
			AND b.option_name = CONCAT(  :param_2 , SUBSTRING( a.option_name, 12 ) )
			AND b.option_value < 1645966953</li>
		<li>Prepare:
DELETE a, b FROM wp_options a, wp_options b
			WHERE a.option_name LIKE  :param_0 
			AND a.option_name NOT LIKE  :param_1 
			AND b.option_name = CONCAT(  :param_2 , SUBSTRING( a.option_name, 12 ) )
			AND b.option_value < 1645966953</li>
	</ol>
Error message was: Problem preparing the PDO SQL Statement.  Error was: SQLSTATE[HY000]: General error: 1 near "a": syntax error

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't workinghelp wantedExtra attention is needed

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions