[serious] Off Topic Moderation Input - Part 2

[I AM I AM I AM MOBIUS]

oh well

[OneFootInTheRave]

PP.(1)

[Proteus_MST]

Sounds like you should look into the table "closure" of the forums database, as there seem to be some orphaned datasets that need to be manually deleted.

What I don't actually understand is, why in the SQL statement there are triple INNER JOINS within the same table.
Normally you use INNER JOINS in order to connect datasets (by PKs) across different tables

[Aeson]

There is an error when moving forums. It doesn't st op the move, just times out on the database. Not sure what it affects:

Error Invalid SQL: DELETE cl3 FROM closure AS cl INNER JOIN closure AS cl2 ON cl2.parent = cl.child AND cl2.depth > 0 INNER JOIN closure AS cl3 ON cl3.child = cl2.child AND cl3.parent = cl.parent WHERE cl.child IN (47) AND cl.depth > 0 /**deleteMovedNodeClosureRecords**/;

[Aeson]

Takes longer to log into the admin panel than it does to move a couple of subs on the directory...

Moving the forums around doesn't change whether or not the subforums are being displayed. They are listed in the database and admincp as subforums of the proper forums, they just don't display for some reason.

[I AM I AM MOBIUS]

give it a /w

[Buster Crabbe's Uncle]

Takes longer to log into the admin panel than it does to move a couple of subs on the directory...

[Broken_Erika]

I have no problem seeing signatures.....no subforms though..

[Aeson]

The subforums and signatures are all there in the database. For some reason they aren't accessible in some of the forum display scripts and user settings. I think it has something to do with the forum cache.

[-Jrabbit]

I have a direct link bookmark to the sports sub that still works:
https://apolyton.net/forum/miscellan...c/sports-forum

[pchang]

It would appear that all our signatures disappeared

[Berzerker]

then it aint just me

[Proteus_MST]

I agree ... both, the tech sub as well as the sports sub are gone

[Berzerker]

Mark Channels Read

thats what I see at the top instead of our sports section

[Berzerker]

what happened to the sub topic section? thats where our sports threads are