devotee

  • Newbie
  • Posts: 24
  • Trades: 14

[Lestrades.com] Nao 尚

  • I'm Share-Locked
  • Administrator
  • Posts: 1,329
  • Trades: 215
Re: Issue(s)
« Reply #226,  »
Ah! At last :)
Were you on a Christmas break? ;)
Re: Issue(s)
« Reply #227,  »
Apologies about the downtime today... I wrote a faulty SQL statement that was missing a safeguard, and ended up running it a million times (!) more than needed. Oops! Had to wait until the query finished, reset the database, and then run the fix query which just took a second or so... Silly me.

Akylen

  • Full Member
  • Posts: 205
  • Trades: 53
Re: Issue(s)
« Reply #228,  »
I noticed a few exclusive steam bundles that include a GOG game or two:
https://lestrades.com/bundle/7800/ - Space Robinson: Hardcore Roguelike Action

This messes up the stats not only mine, but site's too.

[Lestrades.com] Nao 尚

  • I'm Share-Locked
  • Administrator
  • Posts: 1,329
  • Trades: 215
Re: Issue(s)
« Reply #229,  »
Fixed. The issue comes from the fact that ITAD bundle imports are forced to work with game names, and sometimes bundle reporters will enter a name that's not on Steam, but it'll find an equivalent in another store, so this'll be used. Meh.

I could add some kind of failsafe to prevent non-Steam games being added without my manual approval, but I like mostly having the thing working without human intervention.

/u/humpaaa

  • Full Member
  • ▶ ¦ Yep
  • Posts: 188
  • Trades: 10

[Lestrades.com] Nao 尚

  • I'm Share-Locked
  • Administrator
  • Posts: 1,329
  • Trades: 215
Re: Issue(s)
« Reply #231,  »
Yeah and Devotee is nowhere to be found, again ;)

I always convince myself he's finally automated the renewal, lol... It's just a matter of adding a script.

Annoyer13

  • Newbie
  • Posts: 7
  • Trades: 0
Re: Issue(s)
« Reply #232,  »
I'd recommend cloudflare, adds ssl with no hassle.

[Lestrades.com] Nao 尚

  • I'm Share-Locked
  • Administrator
  • Posts: 1,329
  • Trades: 215
Re: Issue(s)
« Reply #233,  »
Meh, LetsEncrypt does the job just fine and you don't have to go through another server for that.
The only problem is that I can never get to wake devotee up in time for fixing SSL...
Other than that, I could possibly move the server to another place, but I don't want to pay for it, etc.
It's not a project that earns me anything (either glory or fortune), and I added the server to my 'exception list' long ago (so that I wouldn't get SSL error notifications), so I don't know what else to say... Add to your exceptions? Or try & find a way to get in touch with devotee because I can't ;)

Banny

  • Newbie
  • Posts: 2
  • Trades: 5
Re: Issue(s)
« Reply #234,  »
Error 302An error occurred while trying to retrieve your Barter blacklist. Please try again!

[Lestrades.com] Nao 尚

  • I'm Share-Locked
  • Administrator
  • Posts: 1,329
  • Trades: 215
Re: Issue(s)
« Reply #235,  »
Yeah, as I mentioned in the other topic, it looks like Barter is currently preventing other websites (or just Lestrade's?) from getting data from it.
Someone would have to ask the BVG webmaster to look into it and re-enable outside scraping.
We had this discussion years ago, and settled on a scraping system that was soft on his servers, I can look into making the updates less frequent (it's better than nothing), but if there's no way to get data from BVG, I will no longer be able to connect users between the websites, and make it possible to transfer tradables with tags, etc. Which would be... bad, for both websites (in my opinion).

Akylen

  • Full Member
  • Posts: 205
  • Trades: 53
Re: Issue(s)
« Reply #236,  »
I've created a discussion here. Hope it gets his attention :)

[Lestrades.com] Nao 尚

  • I'm Share-Locked
  • Administrator
  • Posts: 1,329
  • Trades: 215
Re: Issue(s)
« Reply #237,  »
You know, you don't have to convince him, we already had this discussion in the past. ;-)
Our main issue wasn't that I was scraping his database, but rather the fact that he wanted me to use his JSON API instead (which I'm thinking he wrote with me in mind). Which I'd be fine with, but there were always things missing compared to what was being shown on the website. And now in 2020 I don't really see an incentive to start rewriting my codebase anyway. Lestrade's is in maintenance mode, meaning I'm always there to fix it, but I don't even bother to document new features anymore... :-/ (For instance, this week I added a 'release date' field on studio pages, lol. Figured it could help if you're looking through a game series and want to know which one came out first.)

Akylen

  • Full Member
  • Posts: 205
  • Trades: 53
Re: Issue(s)
« Reply #238,  »
Just wanted to add in there that I think both platforms are useful for different purposes. As I said, I hope this is just some bug in the system