Search the database
Search forum topics
Search members
Search for trades
diablo2.io is supported by ads
diablo2.io is supported by ads
2 replies   2314 views
1

Advanced Filter Options (Jewels) -> sql query error

No data yet

Bug Report

2

Description

Device: PC
Browser: Chrome
OS: Win10

Steps to reproduce:
- Find Trades > Advanced > Jewels [selected]
- in search textbox: "Jewel of Fervor" (without the "")
- clicked on button "Full Search (Uses Filters + Config)"

Then the error appears:
General Error
SQL ERROR [ mysqli ]
Unknown column 'Jewels' in 'where clause' [1054]
An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.


Anything else to add:
If I don't select "Jewels" in the Advanced Filter Options, the search query goes through. No problem there.

Love the v1.0 and the website. Super happy you made that. Big thanks!
5

Can be used to make Runewords:

7
Device: PC
Browser: Chrome
OS: Win10

Steps to reproduce:
- Find Trades > Advanced > Jewels [selected]
- in search textbox: "Jewel of Fervor" (without the "")
- clicked on button "Full Search (Uses Filters + Config)"

Then the error appears:
General Error
SQL ERROR [ mysqli ]
Unknown column 'Jewels' in 'where clause' [1054]
An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.


Anything else to add:
If I don't select "Jewels" in the Advanced Filter Options, the search query goes through. No problem there.

Love the v1.0 and the website. Super happy you made that. Big thanks!
Fixedby Teebling2 years agoGo to post
@Kosh_ch Confirmed fixed upon review. Not sure which patch.

Page working fine after following reproduction steps.
7
User avatar

Teebling 5806Admin

Europe PC
Cheers, added to known issues.

7
User avatar

Teebling 5806Admin

Europe PC
@Kosh_ch Confirmed fixed upon review. Not sure which patch.

Page working fine after following reproduction steps.
This post was marked as the fix.

9

Advertisment

Hide ads
999

Greetings stranger!

You don't appear to be logged in...

99

Who is online

Users browsing Bug Reports: No registered users and 1 guest.

No matches
diablo2.io is supported by ads
 

 

 

 

Value:
Hide ads forever by supporting the site with a donation.

Greetings adblocker...

Warriv asks that you consider disabling your adblocker when using diablo2.io

Ad revenue helps keep the servers going and supports me, the site's creator :)

A one-time donation hides all ads, forever:
Make a donation