Skip to main content

Bug Report Example: SQL Error – Greenhorns 💚

Charlie avatar
Written by Charlie
Updated over 2 weeks ago

LEVEL UP Your Reporting

Here, navigate to the video for better quality.

Exemplary Bug Form

Feature:

Product listing page

Bug Type:

Critical functional

Title:

After the price filter is applied three times on the ❝Sandals and Flip flop Man❞ page, the system renders a blank page with error ''You have an error in your SQL syntax...'

URL:

Steps:

  1. Hover the mouse over the "MAN" tab in the header

  2. Click the "Sandals" link

  3. Click the "Filters" button

  4. Enter "0" in the "From" box, "110" in the "To" box in the "Price" section

  5. Click the magnifier button

  6. Click the "Filters" button

  7. Enter "0" in the "From" box, "100" in the "To" box in the "Price" section

  8. Click the magnifier button

  9. Click the "Filters" button

  10. Enter "0" in the "From" box, "120" in the "To" box in the "Price" section

  11. Click the magnifier button

Actual result:

The products disappear, and a 'You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1' error message appears on the "Sandals and Flip flop Man" page.

Expected result:

The relevant products with prices should be displayed on the "Sandals and Flip flop Man" page after applying the price range filter as many times as users need, or if the server doesn’t allow such, a proper system message should be displayed instead of an SQL error.

Did this answer your question?