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   4095 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 Teebling3 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
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 8 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