cancel
Showing results for 
Search instead for 
Did you mean: 

bug in showing Related search terms

bug in showing Related search terms

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 (CHSEARCH RESULT.png

3 REPLIES 3

Re: bug in showing Related search terms

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

Re: bug in showing Related search terms

@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.

Re: bug in showing Related search terms

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.