bug in showing Related search terms

[visol069]

Hello guys,

I would like to know who managed to solve this bug or remove the search terms related as workaround.

I use magento 2.3.5p1 with the theme Porto

Bug showing related search terms
Stabilo + brush + p
Stabilo + pen + and + brand + text '+ or + (1,2) = (select * from (select + name_const (CHAR (111,108,111,108,111,115,104,101,114), 1), name_const (CH
Stabilo + pen + e + brand + text999999.1 + union + select + unhex (hex (version ())) + - + and + 1 = 1
Stabilo + pen + and + brand + text "+ or + (1,2) = (select * from (select + name_const (CHAR (111,108,111,108,111,115,104,101,114), 1), name_const (CH
Stabilo pen and highlighter "or (1,2) = (select * from (select name_const (CHAR (111,108,111,108,111,115,104,101,114), 1), name_const (CH

[visol069]

As I couldn't find a solution. I then decided to delete all search and related terms in my database. To temporarily work around this bug.

So I got to menu Makerting > Search Terms > and Select to delete all data.

45518 records found 45518 selected

[Geeks on tap]

@visol069 Im using the same theme Porto and experienced the issue.

Tried the workaround but the sql entries keep generating on my search_query table and I dont know the root cause of the issue.

Please share if you have an update on this, thanks.

[Geeks on tap]

I found the root cause, the sql entries generated from Search Engine Spider (SES).

Configured WAF on my server captured the entries as SQL injection.

Now my search term is clean from sql script.