Danbooru

Danbooru 2 Issues Topic

Posted under General

This topic has been locked.

user 441999

The upload changes report page (how long has that been there?) lists tags that you add and then remove later in the "Tags changed by other users" column. Is this intentional?

eg. post #2652702 has "+animal_ears +japari_symbol -artist_name -commentary_request" in that column when the "artist name" and "commentary request" tags were both removed by me. It thus lists both commentary and commentary request in the "tags added by uploader" column even though I removed the request tag when I added the commentary one.

Type-kun

kuuderes_shadow said:

The upload changes report page (how long has that been there?) lists tags that you add and then remove later in the "Tags changed by other users" column. Is this intentional?

eg. post #2652702 has "+animal_ears +japari_symbol -artist_name -commentary_request" in that column when the "artist name" and "commentary request" tags were both removed by me. It thus lists both commentary and commentary request in the "tags added by uploader" column even though I removed the request tag when I added the commentary one.

No, it's not intentional, I simply forgot to account for removal of own tags.

andalus

ActiveRecord::StatementInvalid exception raised
PG::QueryCanceled: ERROR: canceling statement due to statement timeout : SELECT COUNT(*) FROM "artist_versions" WHERE (updater_id = 474806)
app/models/user.rb:682:in `artist_version_count'
app/presenters/user_presenter.rb:169:in `artist_version_count'
app/views/users/_statistics.html.erb:84:in `_app_views_users__statistics_html_erb___93360961016155849_69949237494980'
app/views/users/show.html.erb:5:in `_app_views_users_show_html_erb___3742159537612952927_69949236799240'
app/controllers/users_controller.rb:41:in `show'

BrokenEagle98

andalus said:

ActiveRecord::StatementInvalid exception raised

Does that always happen when you visit your profile...? I just visited it and didn't get the above error.

Usually the above happens when the database is slow, but it could also happen because of the arrangement of the records and whether certain aspects are indexed or not.

BrokenEagle98

toshiya4 said:

Is it possible to increase the number of related and frequent tags?

There's no limit that I'm aware of for frequent tags. Did you mean recent tags instead?

As far as related tags go, you start losing a lot of precision after the top N related tags (usually 10-15 from what I've noticed). What Danbooru basically does is to do a random sampling, and then it calculates the highest 25 tags used (per tag category). However, a random sample does not accurately represent the full population, and the farther away you get away from the Top N tags, the more inaccurate it becomes.

evazion

Hmm, it looks like manga gallery samples now use this format:

while single images use this format:

Changing the gallery sample to https://i.pximg.net/img-original/img/2014/05/15/23/53/59/43521009_p1_master1200.jpg just results in a 404 [1]. This needs further investigation.

EDIT: So it looks like https://i.pximg.net/img-original/img/2014/05/15/23/53/59/43521009_p1.jpg is the right url, but it has a smaller filesize than the sample??

[1]: n.b. you need to use a browser extension to spoof the referer to avoid pixiv's hotlink protection, otherwise it will return 403 forbidden.

Updated

Ars

evazion said:

Hmm, it looks like manga gallery samples now use this format:

while single images use this format:

Changing the gallery sample to https://i.pximg.net/img-original/img/2014/05/15/23/53/59/43521009_p1_master1200.jpg just results in a 404 [1]. This needs further investigation.

EDIT: So it looks like https://i.pximg.net/img-original/img/2014/05/15/23/53/59/43521009_p1.jpg is the right url, but it has a smaller filesize than the sample??

[1]: n.b. you need to use a browser extension to spoof the referer to avoid pixiv's hotlink protection, otherwise it will return 403 forbidden.

The only thing that's changed from before is the i.pximg.net host, the rest of the URL format hasn't changed. Image samples are resampled from their original, which explains why it happens to have a higher filesize. Doesn't matter whether or not the original goes above the 1200px limit for samples, they're all resampled.

BrokenEagle98

Sacriven said:

For some reason, my bookmarklet doesn't detect a possibly duplicate post anymore. Only happened when I'm trying to upload from Pixiv though.

It still works for me...

Which of the following link types are you using it on? (I.e. in the URL bar)

1. Post type:

2. Image type:

#1 detected the duplicate, whereas #2 did not.

Sacriven

BrokenEagle98 said:

It still works for me...

Which of the following link types are you using it on? (I.e. in the URL bar)

#1 detected the duplicate, whereas #2 did not.

I have no idea.

Let's say, from ten uploads, four uploads aren't detected as duplicate even though it's already uploaded before from Pixiv.

1 166 167 168 169 170 171 172 173 174 315