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

Did a search and returned General SQL error

No data yet

Bug Report

2

Description

Device: Desktop
Browser: Chrome
OS: Win10

Steps to reproduce: Searched for a trade, Typed in Chaos, selected rare and ring in the advanced. Below is the query string that was produced and if you follow the link. There is a gen sql error.


Anything else to add:

search.php?keywords=Chaos&fid%5B%5D=16& ... mit=Search
5

Can be used to make Runewords:

7
Device: Desktop
Browser: Chrome
OS: Win10

Steps to reproduce: Searched for a trade, Typed in Chaos, selected rare and ring in the advanced. Below is the query string that was produced and if you follow the link. There is a gen sql error.


Anything else to add:

search.php?keywords=Chaos&fid%5B%5D=16& ... mit=Search
Fixedby Teebling2 years agoGo to post
Fixed in 1.04
7
Similar error can be reproduced by:
  1. Trade > Find Trades
  2. Type in titan's; doesn't seem to matter if you select the result or not
  3. Expand Advanced, select Javelins
  4. Click Full Search, get SQL error
Here's the URL of the error:
https://diablo2.io/search.php?keywords=titan%27s&fid%5B%5D=16&terms=all&sc=0&sf=titleonly&sr=on&irarity=&legacy_resu=1&iitemtype=Javelins&wtbs=&plat_pc=1&plat_switch=&plat_playstation=&plat_xbox=&region=1&xc=1&hc=&ladder=&eth=&super=&imaxsockets=&charm=&skiller=&resists=&magicfind=&life=&mana=&extragold=&fcr=&frw=&fhr=&ar=&mmd=&iclassspec=&imercspec=&uitemid=&author_id=&activesold=&author=&sk=t&sd=d&st=0&ch=300&t=0&submit=Search

search.php?keywords=titan%27s&fid%5B%5D ... mit=Search
7
looked for 4 OS
Archon Plate
, similar SQL error

search.php?keywords=Archon+Plate&fid%5B%5D=16&terms=all&sc=0&sf=titleonly&sr=on&irarity=4&legacy_resu=1&iitemtype=Body+Armor&wtbs=&plat_pc=1&plat_switch=&plat_playstation=&plat_xbox=&region=2&xc=1&hc=&ladder=&
Eth
=&super=&imaxsockets=4&charm=&skiller=&resists=&magicfind=&life=&mana=&extragold=&fcr=&frw=&fhr=&ar=&mmd=&iclassspec=&imercspec=&uitemid=1405&author_id=&activesold=&author=&sk=t&sd=d&st=0&ch=300&t=0&submit=Search

Add on Bnet for faster checkout -- SleepyShaman#23358
7
User avatar

Teebling 6885Admin

Europe PC
Fixed in 1.04
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 2 guests.

No matches
 

 

 

 

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