报告 • Board Game Arena

所有案件

#12779: "Player game history "from date" field glitch on /gamestats renders application unusable."

fixed: 漏洞已修复

这个案件是关于哪方面的？

BGA 网站

发生什么事? 请从下方选择

本站的某些功能异常（非游戏过程中发生）

发生什么事? 请从下方选择

本站的某些功能异常（非游戏过程中发生）

请检查是否已有同课题案件

若肯定，请「投票」给这桩案件。最高票的案件将「优先」处理！

#	Status	Votes	Game	Type	Title	Last update

细节描述

案件历史

2019年Jun14日 06:46 • BulgarianHorde • 漏洞尚未被修复:

Things I've tried:
- Different devices
- different start dates
- inputting and end date first
- typing in the date(s)
everything resulted in the same effect. I have not been able to confirm that other parties have experienced this problem.

2019年Jun19日 15:10 • BulgarianHorde • 漏洞尚未被修复:

bug reproduced by DaMaster and Delferth
(thanks!)

2019年Jun19日 15:11 • Delferth • 漏洞尚未被修复:

Other parties do experience this.

2020年Mar8日 22:19 • Smugs • 漏洞尚未被修复:

This is still an issue

2020年Apr14日 20:53 • Sugs • 漏洞尚未被修复:

+1 Experienced on both desktop (Firefox) and mobile (Android), which actually crashes the app.

The bug status is still "Bug has not been reproduced by developers yet" — Have they attempted a repro? It seems to be just broken, I don't think it will be hard to reproduce.

Impact: Right now there's no other way to view non-recent history more than several entries at a time, other than clicking "More" and scrolling, click and scroll, click and scroll, endlessly.

2020年Apr14日 20:55 • Sugs • 漏洞尚未被修复:

+2 more users (cookiea and chaos05) who've confirmed the same

This would be great to get fixed, especially since we are interested in tracking our game scores for a particular game. Thanks!

2020年Apr14日 22:13 • Sugs • 漏洞尚未被修复:

I think you can consolidate these 2 later bug reports with this one:
boardgamearena.com/bug?id=13057
boardgamearena.com/bug?id=13608

More details.... This is probably at least 2 different bugs:
– Case 1: Entering a valid start date causes endless "Error while processing Database request" red error box overlays.
– Case 2: Entering a valid end date cause endless redirects (flickering). This is worse than endless reloads because it also floods the browser history, forcing the user to close the tab (navigating back doesn't work).

Additionally:
– Entering an invalid date does not cause a problem: the page resets the field and reloads (via a fresh URL).
– Only valid dates cause these issues, and it's the same whether typed or using the date picker.

– The 2 different outcomes suggest Case 1 is creating and executing a SQL/db query but that the query is bad (date format error maybe?) but that some other exception is derailing Case 2 either before or after the query.
– My off-the-wall guess would be before and while actually constructing the query (perhaps assuming start date exists and is valid?).

2020年Apr14日 22:49 • Sugs • 漏洞尚未被修复:

Debugging within Firefox, I see 2 GETs on every update to the search inputs. This pair of requests get repeated forever. For example on a start date change:
– boardgamearena.com/gamestats?player=85562224&opponent_id=0&start_date=1586329200&finished=0&refreshtemplate=1&dojo.preventCache=1586895615311
– boardgamearena.com/gamestats/gamestats/getGames.html?player=85562224&opponent_id=0&start_date=1586329200&finished=0&updateStats=1&dojo.preventCache=1586895617663

(The only change between requests is every URL gets a new dogo.preventCache value, presumably to force a fresh DB read.)

Same with end date (but with end_date URL param).

I was curious if the bug was related to not having both start and end date (which a user never is able to achieve because the page becomes unusable after setting either one), so I manually cold loaded a URL with both in it:
– boardgamearena.com/gamestats?player=85562224&opponent_id=0&start_date=1586329200&end_date=1586674800&finished=0

Same result as the Case 1 (start date) – endless DB errors.

Hope that helps!

P.S. BTW, I'd highly recommend some kind of quadratic backoff and/or even a hard abort after some number of consecutive errors... at least for some class of endpoint calls. I realize this is trickier in cases like this where the looping is actually a chain of reloads, but this does seem to be common pattern across your whole site (e.g. voice chat, move transmit retries, etc). This has to dramatically affect site stability however — even 1 unbroken loop slams your site with requests, but any blip in infrastructure multiplies then compounds it! Anyway sorry for the digression...

2020年May17日 20:52 • megamau • 漏洞尚未被修复:

Confirmed also by user megamau. Unusable in any way

2020年Jul24日 02:46 • KongKing123 • 漏洞尚未被修复:

I can confirm that this is still an issue on Firefox 78.0.2, this is what it looks like: i.postimg.cc/fbrzbK7X/Game-history-date-crash.png

2020年Nov22日 10:06 • v1p3r • 漏洞尚未被修复:

Using on firefox 82.0.3 (64-bit)
Mac OS 10.15.7 (19H15)

The issue is still persistent, tried different date ranges from 10 year to 1 year all of them have same issue

2020年Nov23日 10:28 • Een • 漏洞已修复:

Thanks, this will be fixed with the next release.

2020年Nov23日 13:09 • KongKing123 • 漏洞已修复:

Great! These duplicates can then also be closed:

* boardgamearena.com/bug?id=13057
* boardgamearena.com/bug?id=13608
* boardgamearena.com/bug?id=28457

2020年Nov23日 13:11 • KongKing123 • 漏洞已修复:

Another duplicate: boardgamearena.com/bug?id=18618

增加一些新内容到这篇报告

任何可能重现这项漏洞或了解你的建议之相关资讯，都请在此填写:

其他的游戏桌 ID / 移动 ID
按 F5 是否解决了这个问题？
问题是否发生了好几次？还是每次都发生？还是时好时坏？
如果你有这个系统漏洞发生时的屏幕截图(画质不要太差)，你可以使用Imgur.com来把它上传到网络，然后将链接复制/粘贴到这里来。

取消更新报告

#12779: "Player game history "from date" field glitch on /gamestats renders application unusable."

这个案件是关于哪方面的？

发生什么事? 请从下方选择

发生什么事? 请从下方选择

请检查是否已有同课题案件

细节描述

案件历史

增加一些新内容到这篇报告

更改案件状态为：

帮助

贡献

导航

关注我们