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:

https://www.pierre-bz.com/en/filtro/?price%5B0%5D=0&price%5B1%5D=120&q=

Steps:

  1. Open https://www.pierre-bz.com/en

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

  3. Click the "Sandals" link

  4. Click the "Filters" button

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

  6. Click the magnifier button

  7. Click the "Filters" button

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

  9. Click the magnifier button

  10. Click the "Filters" button

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

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

Related Articles
Bug Report Examples Collection for Greenhorn Testers 💚
Did this answer your question?