Follow TV Tropes

Following

We are updating the forum database structure today!

Go To

itcdr Since: Aug, 2014
#1: Apr 21st 2016 at 2:06:15 PM

Hey tropers, we are pushing a major push to the backend of the forum today. If we do it right you won't notice anything so let me know if you notice any issues. This should make things a whole lot easier for adding new features in the future (ie: search forum posts, spam detection, etc.)

- Chris

edited 21st Apr '16 2:34:25 PM by itcdr

itcdr Since: Aug, 2014
#2: Apr 21st 2016 at 2:56:03 PM

Ok. The migration is complete. We just merged 70,000 database tables into one! Let's see how this works...

SeptimusHeap from Switzerland (Edited uphill both ways) Relationship Status: Mu
#3: Apr 21st 2016 at 2:59:56 PM

Moved and pinned, seems like this thread has problems with the buttons.

"For a successful technology, reality must take precedence over public relations, for Nature cannot be fooled." - Richard Feynman
TotemicHero No longer a forum herald from the next level Since: Dec, 2009
No longer a forum herald
#4: Apr 21st 2016 at 3:11:31 PM

I saw it briefly (the buttons at the top of each post weren't aligned correctly), but it seems fixed now.

Expergiscēre cras, medior quam hodie. (Awaken tomorrow, better than today.)
itcdr Since: Aug, 2014
#5: Apr 21st 2016 at 3:13:06 PM

We just fixed the issue with the buttons being mis-aligned. Minor typo in the new code.

Chariot King of Anime Since: Jul, 2014
King of Anime
#6: Apr 21st 2016 at 3:59:50 PM

I'm having a problem where a thread will show that there are new posts and will either take me directly to the most recent post in the thread, thereby skipping over any post I haven't read between the last time I loaded the thread and said post, or it'll take me to the last post I read and not show any post that posted after it and I need to edit the URL to get to the next page if the new post was on a new page or edit the URL to show a new page and then page back to the previous page to actually see the newest post after the last post I read.

edited 21st Apr '16 4:02:40 PM by Chariot

war877 Grr... <3 from Untamed Wilds Since: Dec, 2015 Relationship Status: Having tea with Cthulhu
Grr... <3
#7: Apr 21st 2016 at 4:09:14 PM

Yo, you lost all the pinned posts.

CathariSarad Since: Jan, 2014
#8: Apr 21st 2016 at 4:20:08 PM

Yeah, the forums also seem to be skipping to the most recent page on me too.

Nohbody "In distress", my ass. from Somewhere in Dixie Since: Jan, 2001 Relationship Status: Mu
"In distress", my ass.
#9: Apr 21st 2016 at 4:56:16 PM

Got that "skip to the next thread page" thing, too. Kinda annoying, though it seems to be a one-time deal that's cleared the next time I visit a thread that I've opened post-update.

(Edited, not a recurring problem, just the first time opening a thread since the change.)

A minor aesthetic issue I've noticed, though: The first page of the subforum thread index seems to be double-spacing the thread titles, but once you start paging down the titles are at their normal vertical spacing. As I said, though, "minor". No need to drop everything else just to fix that issue.

Though you totally should. tongue

edited 21st Apr '16 5:02:40 PM by Nohbody

All your safe space are belong to Trump
Unknownlight Since: Aug, 2009
#10: Apr 21st 2016 at 5:06:49 PM

We just merged 70,000 database tables into one!

...That's terrifying. Why were there 70K database tables before?

rmctagg09 The Wanderer from Brooklyn, NY (USA) (Time Abyss) Relationship Status: I won't say I'm in love
war877 Grr... <3 from Untamed Wilds Since: Dec, 2015 Relationship Status: Having tea with Cthulhu
Grr... <3
#12: Apr 21st 2016 at 5:44:52 PM

Because there were 70000 threads.

HeraldAlberich from Ohio (Before Recorded History) Relationship Status: Gonna take a lot to drag me away from you
#13: Apr 21st 2016 at 5:47:23 PM

Yo, you lost all the pinned posts.

It's worse than that for me. Seems like whenever I open a thread with a pinned post, I see nothing. There's an empty block where the pinned post should be, and no other posts below it, on any of the pages.

Fighteer Lost in Space from The Time Vortex (Time Abyss) Relationship Status: TV Tropes ruined my love life
Lost in Space
#14: Apr 21st 2016 at 6:17:33 PM

Don't see that on my end, but the sticky post is not visible even after being enabled. Known issue that's being worked on.

"It's Occam's Shuriken! If the answer is elusive, never rule out ninjas!"
Unknownlight Since: Aug, 2009
#15: Apr 21st 2016 at 6:36:45 PM

Red mod posts (like the OP of this thread) don't seem to always be working. I know for a fact this post used to be red.

Karxrida The Unknown from Eureka, the Forbidden Land Since: May, 2012 Relationship Status: I LOVE THIS DOCTOR!
The Unknown
#16: Apr 21st 2016 at 6:38:42 PM

The Metroid thread is missing posts/pages from earlier this week.

If a tree falls in the forest and nobody remembers it, who else will you have ice cream with?
itcdr Since: Aug, 2014
#17: Apr 21st 2016 at 6:52:03 PM

To the question about the 70,000+ database tables, war877 is correct. The forum was originally designed to create a new table for every thread. I'm guessing that back in the day the forum must have used a My ISAM engine or something similar that had issues with so many users editing the same table. But it's not currently an issue with our database so it was just a huge pain that made it impossible to do daily backups or create a search for the forum and edit anything across all posts. Much easier now. I just did a backup of the whole forum in 5 minutes which use to take 14 hours on our old servers with all these tables.

As for skipping forum posts you haven't read, can someone re-produce this with an example? I tried to re-produce but when I go to my thread watchlist and click on a post I end up at the last one I read, unless I click on the date then it goes to the most recent post. Same thing with the forum thread lists.

And not sure what you mean about the pinned posts issue. Please post an example.

TotemicHero No longer a forum herald from the next level Since: Dec, 2009
No longer a forum herald
#18: Apr 21st 2016 at 6:57:39 PM

Example. A copy of the first post in this thread is supposed to appear at the top of the page, regardless of which page of the thread you are looking at. For me, there is just a empty thin rectangle.

Expergiscēre cras, medior quam hodie. (Awaken tomorrow, better than today.)
rmctagg09 The Wanderer from Brooklyn, NY (USA) (Time Abyss) Relationship Status: I won't say I'm in love
The Wanderer
#19: Apr 21st 2016 at 7:11:59 PM

To be more exact, this is what it looks like page number-wise when you try accessing one of the missing pages.

Eating a Vanilluxe will give you frostbite.
war877 Grr... <3 from Untamed Wilds Since: Dec, 2015 Relationship Status: Having tea with Cthulhu
Grr... <3
#20: Apr 21st 2016 at 7:13:22 PM

The yellow thing at the top of threads like this one is supposed to contain the text of the first post.

Edit: [up][up]Oops duplicated.

edited 21st Apr '16 7:17:42 PM by war877

shimaspawn from Here and Now Since: May, 2010 Relationship Status: In your bunk
#21: Apr 21st 2016 at 7:22:35 PM

That post referenced earlier was in fact mod hatted when I made it. I even referenced that I'd done so in the post itself.

Reality is that, which when you stop believing in it, doesn't go away. -Philip K. Dick
HeraldAlberich from Ohio (Before Recorded History) Relationship Status: Gonna take a lot to drag me away from you
#22: Apr 21st 2016 at 7:44:03 PM

[up] Your moderator avatar also switched back to the regular one; it's not just that the red turns off.

I'm seeing the normal pinned-post bugs on some threads, but on others, like this one, I still see nothing except the empty pinned-post box, and the thread page numbers above and below it.

Karxrida The Unknown from Eureka, the Forbidden Land Since: May, 2012 Relationship Status: I LOVE THIS DOCTOR!
The Unknown
#23: Apr 21st 2016 at 8:33:36 PM

That thread link just leads me to a forum page with no posts.

If a tree falls in the forest and nobody remembers it, who else will you have ice cream with?
HeraldAlberich from Ohio (Before Recorded History) Relationship Status: Gonna take a lot to drag me away from you
#24: Apr 21st 2016 at 8:36:42 PM

[up] Precisely, but it's supposed to be the Image Suggestion Thread pinned at the top of Image Pickin'. The same thing is happening to General Page Quote Discussion in Long-Term Projects.

edited 21st Apr '16 8:39:26 PM by HeraldAlberich

war877 Grr... <3 from Untamed Wilds Since: Dec, 2015 Relationship Status: Having tea with Cthulhu
Grr... <3
#25: Apr 22nd 2016 at 2:00:12 AM

Re. rmctagg09's problem. It may be the case that the glitch happens because the last post on the glitched page is not a multiple of 25.


Total posts: 62
Top