[serious] Off Topic Moderation Input - Part 2

[Buster Crabbe's Uncle]

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

[I AM I AM MOBIUS]

give it a /w

[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.

[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**/;

[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

[OneFootInTheRave]

PP.(1)

[I AM I AM I AM MOBIUS]

oh well

[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

[Aeson]

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

[rah]

Thank you.

[pchang]

search for seif biased - he used a capital I to look like an l

[ZEE]

Did I miss something again?

[pchang]

Spambots have been busy today.

[Proteus_MST]

It is fascinating how they now work in tandem ... passing balls to eachother

[rah]

Probably about time to unsticky the march madness thread.

[-Jrabbit]

But how will you access the Sports subforum?