Posted under General
This topic has been locked.
Can't add tags.
Error
The database timed out running your query.
Details
ActiveRecord::QueryCanceled exception raised
app/models/tag.rb:95:in `increment_post_counts'
app/models/post.rb:572:in `update_tag_post_counts'
app/controllers/posts_controller.rb:50:in `update'
Only happens in main site, it works just fine in the mirrors.[/s]
Edit: Fixed now, seems like it was a temporary issue.
Updated
Why am I not able to upload images from my computer? I installed the Upload File Input CSS code into both Greasemonkey and Danbooru's CSS settings, but while I actually see the icon for browsing my computer pop up, it's only there for a split second before it disappears.
This is particularly concerning because sometimes I upload images from Hitomi, but they recently switched over from JPG/PNG files to WebP, which Danbooru doesn't seem to support at the moment. That means I can't use the URL to upload. Thus I've had to manually convert these WebP images into PNG and upload from my computer, but now the upload file input doesn't work.
So yeah, I'm kind of stuck.
Benit149 said:
Please don't recompress anything anywhere.
First Hitomi is a exhentai rip, second you can still get original image from them.
say the id on the link is 1499969 you go on https://ltn.hitomi.la/galleries/1499969.js , view the image for page x, say the page 0 the name is SskVR_000.jpg, then go on https://aa.hitomi.la/galleries/1499969/SskVR_001.jpg .
or just go to the original gallery on exhentai, https://exhentai.org/g/1492263/62331248aa/ (notice the id of the gallery is the same as on hitomi because hitomi is just a selective copy of exhentai)
fredgido said:
Please don't recompress anything anywhere.
First Hitomi is a exhentai rip, second you can still get original image from them.
say the id on the link is 1499969 you go on https://ltn.hitomi.la/galleries/1499969.js , view the image for page x, say the page 0 the name is SskVR_000.jpg, then go on https://aa.hitomi.la/galleries/1499969/SskVR_001.jpg .
or just go to the original gallery on exhentai, https://exhentai.org/g/1492263/62331248aa/ (notice the id of the gallery is the same as on hitomi because hitomi is just a selective copy of exhentai)
They're not even a *good* exh RIP, they only rip the 1200p images, I think.
DeusExCalamus said:
They're not even a *good* exh RIP, they only rip the 1200p images, I think.
As far as I saw the "download" images are the original.
Ah I forgot to say it seems there is a problem, looks like you can only access direct link images with a referrer. So you do have to press download on the gallery page, or do some complicated stuff. Anyway, just use exhentai.
Updated
Benit149 said:
Why am I not able to upload images from my computer? I installed the Upload File Input CSS code into both Greasemonkey and Danbooru's CSS settings, but while I actually see the icon for browsing my computer pop up, it's only there for a split second before it disappears.
I developed a userscript fix for that in forum #160207.
fredgido said:
Please don't recompress anything anywhere.
First Hitomi is a exhentai rip, second you can still get original image from them.
say the id on the link is 1499969 you go on https://ltn.hitomi.la/galleries/1499969.js , view the image for page x, say the page 0 the name is SskVR_000.jpg, then go on https://aa.hitomi.la/galleries/1499969/SskVR_001.jpg .
or just go to the original gallery on exhentai, https://exhentai.org/g/1492263/62331248aa/ (notice the id of the gallery is the same as on hitomi because hitomi is just a selective copy of exhentai)
I wish I could use exhentai, but the website only comes up as a blank page for me.
BrokenEagle98 said:
I developed a userscript fix for that in forum #160207.
That's the exact same userscript I used yesterday, and the same problem keeps happening to me. The Browse button pops up for a split second, but then disappears.
Benit149 said:
My browser is Firefox. I’m using Danbooru’s custom CSS rather than Greasemonkey.
I meant what is your custom CSS? I was going to look it over and see if there was anything in it that was causing issues.
Anyways, I just tried the userscript on Firefox and it works for me. You might want to check to make sure that the script is even activated. If you click the Tampermonkey icon next to the address bar, it'll open up and show all of the scripts that are running. Make sure that "Upload File Input" is one of them. If all of that checks out, then check the dev console (F12) for errors.
BrokenEagle98 said:
I meant what is your custom CSS? I was going to look it over and see if there was anything in it that was causing issues.
Anyways, I just tried the userscript on Firefox and it works for me. You might want to check to make sure that the script is even activated. If you click the Tampermonkey icon next to the address bar, it'll open up and show all of the scripts that are running. Make sure that "Upload File Input" is one of them. If all of that checks out, then check the dev console (F12) for errors.
Well, this is the custom CSS I have in my Danbooru settings. My Greasemonkey settings are disabled, so these are the only settings that should be active...
BTW, I'm still on Greasemonkey. Should that be updated to Tampermonkey, or am I fine?
/* make spoiler text readable only when selected */
.spoiler { color: black }
.spoiler a { color: black }
.blacklisted-active { display:none }#c-posts #tags {
font-family: Arial;
}#c-uploads #a-new #filedropzone {
display: none;
}
#c-uploads #a-new .input.fallback {
display: block;
}#c-uploads #a-new #related-tags-container {
display: block;
}// ==UserScript==
// @name Upload File Input
// @version 1.0
// @description Add the file input back to the uploads page.
// @match *://*.donmai.us/uploads/new*
// @exclude /^https?://\w+\.donmai\.us/.*\.(xml|json|atom)(\?|$)/
// @grant none
// @run-at document-end
// ==/UserScript==const timer = setInterval(()=>{
if ($('#upload_file').length === 0) {
clearInterval(timer);
$("#filedropzone").before(`
<div class="input fallback">
<label for="upload_file">File</label>
<input size="50" type="file" name="upload[file]" id="upload_file" />
</div>`);
}
}, 100);
Benit149 said:
Well, this is the custom CSS I have in my Danbooru settings. My Greasemonkey settings are disabled, so these are the only settings that should be active...
BTW, I'm still on Greasemonkey. Should that be updated to Tampermonkey, or am I fine?
My scripts are always coded for Tampermonkey, so they should normally be used with that. The problem is that the Greasemonkey doesn't port jQuery over to the script so it doesn't have access to it like Tampermonkey does. It can be solved by using unsafeWindow like in the following, but it's generally not recommended.
// ==UserScript==
// @name Upload File Input (Greasemonkey ver)
// @version 1.0.g
// @description Add the file input back to the uploads page.
// @match *://*.donmai.us/uploads/new*
// @exclude /^https?://\w+\.donmai\.us/.*\.(xml|json|atom)(\?|$)/
// @grant none
// @run-at document-end
// ==/UserScript==
const timer = setInterval(function (){
if (unsafeWindow.$('#upload_file').length === 0) {
clearInterval(timer);
unsafeWindow.$("#filedropzone").before(`
<div class="input fallback">
<label for="upload_file">File</label>
<input size="50" type="file" name="upload[file]" id="upload_file" />
</div>`);
}
}, 100);
nil can't be coerced into Float
error when searching for a bunch of videos: filetype:avi, filetype:mpg, filetype:wmv, video
<b>, <i>, <s>, <u>, <strong>, <em>, <table>, <thead>, <tbody>, <tr>, <th>, <td>, <code>, <quote>, <tn>, <expand>, <spoiler>, <nodtext>.<a href="http://www.example.com">link text goes here</a>).[http://www.example.com](link text goes here)).Full changelog: https://github.com/r888888888/danbooru/compare/production-2019.10.08-045432-utc...production-2019.10.15-030638-utc
evazion said:
.sidebar-container aside { min-width: 15em; }The desktop layout is designed for desktop. You can use it on mobile, but if there are things that don't work well they're not generally going to be changed to accommodate phones. That's what the mobile layout is for.
Thank you very much.
And yes, I know, which is why I asked for CSS rather than a sitewide change.
Sorry if it came out wrongly.
Is there a way to keep the "Similar" button from automatically uploading your post and keeping you from adding tags in the meantime? I just want to check if the image has already been posted, and if it turns out it hasn't been that doesn't necessarily mean I want it to be added either.
Anonymous9000 said:
Is there a way to keep the "Similar" button from automatically uploading your post and keeping you from adding tags in the meantime? I just want to check if the image has already been posted, and if it turns out it hasn't been that doesn't necessarily mean I want it to be added either.
Not sure what you mean. The Similar button on the upload page has to download the image in order to do the check. It doesn't upload the post though unless you click submit. I'm not sure what you mean by it keeping you from adding tags.
You can use https://danbooru.donmai.us/iqdb_queries if you just want to do a reverse image search without uploading. It's easier though to use userscripts if you're checking for posts that have already been uploaded: