[serious] Off Topic Moderation Input - Part 2

[ZEE]

Did I miss something again?

[rah]

Thank you.

[Aeson]

Any DL that causes even the slightest inconvenience to moderate is permanent toast.

[seIf biased]

dont talk ****
disrespectful
you get written up
fired
at any job for that talk
ban my ****
I give half a **** about someone who can't let another be
don't read the thread you don't like it

[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