Fantasy Buddy Reads discussion
General Group Info
>
MODs - Please Adjust our Buddy Read Thread
message 351:
by
Narilka
(new)
Jan 01, 2025 09:15AM
I'm adding the Discworld BR requests this year and made a typo. In the request for The Fifth Elephant, it is book #24 in the series. Sorry about that!
reply
|
flag
@Iain--Formatting small thing--on Narilka's Jingo request, could you add the # to 21?
@Iain--and I just put in Hollows #1 for January 2nd 2024. *sigh* Actually, while you're (thank you!) fixing my error, would you mind just making the thread for us?
Nirkatze wrote: "@Iain--Formatting small thing--on Narilka's Jingo request, could you add the # to 21?"Thanks for catching that.
Mod
Narilka wrote: "Nirkatze wrote: "@Iain--Formatting small thing--on Narilka's Jingo request, could you add the # to 21?"Thanks for catching that."
I am sadly good at being bugged over little things, lol.
Timelord Iain wrote: "Done and done and done"Thank you!
Little thing--on my request for (Black Company #3.5) I missed the #
Something weird happened to the Upcoming BR tab in the Mod Sheet--it's all blank....
Mod
I figured out how to fix it with iferror and returning a black array (so now there's 1 blank row at the bottom of the BR list)...
For some reason, tho, if I implement the same iferror formula to the main BR Requests tab, it breaks the date column and turns all dates into meaningless (to me) 5 digit number backend displays of the date column (everything else still works)...
So I just removed that fix and trusted that the sheet will never be empty while we care about results...
Funnily enough, I encountered this exact same problem on one of my spreadsheet, with the error thrown when a query returned an empty dataset, and used the exact same fix :)I put back the iferror for the main BR requests query (even though it's very improbable that it'll be empty as you said). You had the right idea, you just had to format the column to Date.
The 5 digits number it showed is actually the number of days between the date and the reference date (December 30, 1899).
Mod
I honestly was scratching my head at first, until I realized the December 9/10 thing from tabbing around a bunch...
I almost blamed you for the formula change a few weeks ago to auto-hide, and/or maybe someone had a weird input in a request that Yanique activated yesterday that caused some sort of SQL injection, like the old Bobby Tables comic:
LOL that's hilarious. "Little Bobby Tables"!!
Typo in the spreadsheet for Unorthodox Chronicles #3--says "Tast" instead of "task"https://www.goodreads.com/topic/show/...
Timelord Iain wrote: "I had a feeling it was that simple, but I got up at 3-4am and started fiddling...I honestly was scratching my head at first, until I realized the December 9/10 thing from tabbing around a bunch....."
I'll admit, I had a 2s moment where I wondered if I broke something with my recent changes before scrolling and seeing your comment about the fix.
LOL at the comic. Yup, sanitize DB inputs. At this point, SQL injections are so well known, if you don't protect your DB against it, it's your own damn fault :p
Not sure if there's just a delay, or if there's a new form, or something... but I just put in three requests and they haven't shown up on the spreadsheet yet... Usually I check the sheet as I'm inputting requests, to try to catch my errors as I go...We're still using this one, right?
https://docs.google.com/spreadsheets/...
Mod
Yeah, that was weird... must've just been a temporary hiccup. Could've been my computer too.
Hi Mods! Could you please make the following updates to these BRs? Those of us participating in the BRs agreed to bump them out one month.• To Light a Candle (Mar 10) >>> Apr 10
• When Darkness Falls (Apr 10) >>> May 10
Thanks! Much appreciated :)
Mod
• To Light a Candle (Mar 10) >>> Apr 10
• [b..."
Changes made on my end.
Wise and powerful Mods, could the dates for the following BRs be adjusted as follows?The Heart of What Was Lost March 1 --> April 1st
Brothers of the Wind April 1 --> May 1
Thank you very much!
Oops, found a typo in my most recent requests:Dragons of the Dwarven Depths should have had a "the" in it, and say #1 for series. My bad. >.<
https://www.goodreads.com/topic/show/...
Also totally put the link in the Author slot for #3. *sigh* I should not make requests when tired. At least that's just a spreadsheet fix.
Aand Empire of Storms should be Empire of Storms (Throne of Glass #5)
Mod
LOL I'm stalled now, waiting for responses from folks before making more requests...
Okay, more errors I noticed:Rose and Thorn needs the GR link--copied wrong thing.
What Happened in London change series D.I. Adams --> DI Adams
And that's it! I think I'm done with requests for the time being...
Mod
Rose and Thorn needs the GR link--copied wrong thing.
What Happened in London change series D.I. Adams --> DI Adams
And that's it! I think I'm done with requests for t..."
Done Done Fixed Fixed Fixed Fixed Fixed, Found another:
DI Adams #2 said Trouble In Brewing Harrogate, instead of Trouble Brewing in Harrogate...
LOL Thank you!! I had originally typed Trouble in Harrogate and well, whoops!
OKay, found one more. DI Adams #0.5 I typed Kim M. Watts --> Watt
Mod
https://www.goodreads.com/topic/show/...
Fixed in spreadsheet already...
Okay, facepalming right now...I requested Malevolent Eight before Malevolent Seven and made some mistakes--please change it to
Malevolent Seven #2 on May 29th
Starting a backlog of requests, hopefully the sting of this facepalm will keep me from making more mistakes...
Making a bunch more requests, begging spreadsheet masters to fix my boo boos... fortunately not too many, ratio-wise.He Who Fights with Monsters 12: A LitRPG Adventure the formatting should be:
He Who Fights With Monsters 12 (HWFWM #12)
Was just looking at the Spreadsheet, and noted that Hench & sequel, and Reign, are all set for end of year/next year. Since their release dates keep getting pushed off.There're a few other threads that were made a long time ago for similar situations: Alecto the Ninth, Very Secret Society sequel etc--do you want to do the same for them? Or just ignore those old threads for now, and remake when they actually come out?
Alecto: https://www.goodreads.com/topic/show/...
Magical Innkeeping: https://www.goodreads.com/topic/show/...
Magical Innkeeping actually seems to have a solid date (fingers crossed) for this July--Alecto might still be in writing phase.
Mod
Alecto and Hench should probably just die until we get news...
Probably...Should we check interest/timing in the Invite thread for Magical Innkeeping? Might be nice to add to the Cozy November list, too.
Mod
LOL At this point I feel like I need a #1 reread.
Mod
Oh, that's a bummer. I thought it was a sequel...
Mod
Sarah Beth Durst is releasing The Enchanted Greenhouse... which sounds like a sequel to Spellshop... maybe... but if so, it's not being marketed that way, and it's a super light connection that won't affect the plot at all, afaik...
It's just both have a sentient spider plant... only this 2nd book would be about the person who created the plant, who was turned into a statue for 1000 years and ended up in a multiverse of magic greenhouses, and then the book happens?!?...
Either way, I'm totally in...
Fantasy Buddy Reads
Books mentioned in this topic
The Fractured Dark (other topics)The Navigator's Children (other topics)
The Bound Worlds (other topics)
The Dinosaur Princess (other topics)
The Navigator's Children (other topics)
More...
