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   6820 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 Teebling3 years agoGo to post
@Kosh_ch Confirmed fixed upon review. Not sure which patch.

Page working fine after following reproduction steps.
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 7 guests.

No matches
 

 

 

 

You haven't specified which diablo2.io user you completed this trade with. This means that you will not be able to exchange trust.

Are you sure you want to continue?

Yes, continue without username
No, I will specify a username
Choose which dclone tracking options you want to see in this widget:
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