[Solved!] lost all my sub-forums

[zenrei]

I don't know what happened, but I had issues with the heirarchy command corrupting my tree_def.php file... so i turned off caching for the tree...

I've also run db repair... and now have a category called "restored forums" which doesn't appear to have anything in them.

Now I see all of my subforums are gone.... but my def_tree has them listed... how do i get them back??

[Helter]

they are still there, but should be in restored forums. I wish there were a way to remove some of the functions from acp/db maintenance. It was never designed to be used with CH and does not recognize subforums, so it collects them all and puts them in the restored forum.

[zenrei]

when i go to restored forums, it's empty.. and it doesn't show up on my forum list, either... it's just empty.

if i replaced my def_tree.php with a backed up one from a few days ago and resynced, do you think it would bring them back?

[Helter]

no. look in your db and make sure they are still there. When you re-sync, you sync your includes/def_tree.php to your db. So if they are gone from your db, re-syncing them will empty the def file. You may have to temporarily re-enable caching, then resync.

[zenrei]

They're still there. I just uploaded a backup copy of my site, and they pulled in.

Now get this... it's not the database repair that killed my forums.

It's the mod_categories_heirarchy.php.. it overwrote my def_tree.php and rewrote it wrong, causing my whole site to go down... I had to turn off the caching, in mod_categories_heirarchy.php... so when I replaced my def_tree.php, it can't recache because it's turned off, so none of my subforums came back... why would it write it back wrong??


..i'm wondering if maybe it can't write to the db?? would that make it re-write wrong??

i'm looking at my config table, and there's only 2 fields there... should there be more?

Here's my mod_categories_heirarchy.php... can you tell me where it's trying to write to?

cuz if i'm reading this right, it's trying to write to the config table and the following fields:

sub_forum
split_cat
last_topic_title
last_topic_title_length
sub_level_links
display_viewonline
max_posts
max_topics
max_users

Or am I wrong?

Code: Select all

   <?php  /***************************************************************************  *                            mod_categories_hierarchy.php  *                            ----------------------------  *   begin             ]

The last mod i installed was the jail mod... i do see this run on the db:

[code]  ALTER TABLE phpbb_users ADD user_cell_time INT(11) DEFAULT '0' NOT NULL;ALTER TABLE phpbb_users ADD user_cell_time_judgement INT(11) DEFAULT '0' NOT NULL;ALTER TABLE phpbb_users ADD user_cell_caution INT(8) DEFAULT '0' NOT NULL;ALTER TABLE phpbb_users ADD user_cell_sentence TEXT DEFAULT '';ALTER TABLE phpbb_users ADD user_cell_enable_caution INT(8) DEFAULT '0' NOT NULL;ALTER TABLE phpbb_users ADD user_cell_enable_free INT(8) DEFAULT '0' NOT NULL;ALTER TABLE phpbb_users ADD user_cell_celleds INT(8) DEFAULT '0' NOT NULL;ALTER TABLE phpbb_users ADD user_cell_punishment TINYINT(1) DEFAULT '0' NOT NULL;  INSERT INTO phpbb_config (config_name, config_value) VALUES ('cell_allow_display_bars', '1');INSERT INTO phpbb_config (config_name, config_value) VALUES ('cell_allow_display_celleds', '1');INSERT INTO phpbb_config (config_name, config_value) VALUES ('cell_allow_user_caution', '1');INSERT INTO phpbb_config (config_name, config_value) VALUES ('cell_allow_user_judge', '1');INSERT INTO phpbb_config (config_name, config_value) VALUES ('cell_allow_user_blank', '1');INSERT INTO phpbb_config (config_name, config_value) VALUES ('cell_amount_user_blank', '5000');INSERT INTO phpbb_config (config_name, config_value) VALUES ('cell_user_judge_voters', '10');INSERT INTO phpbb_config (config_name, config_value) VALUES ('cell_user_judge_posts', '2');    

would that effect anything??

also... it didn't start over writing until the site went live... then it kicks in about 2-3 minutes later... when it's not live, everything's right.

[zenrei]

here's an update... disabling the hierarchy cache is what seems to be surpressing the subforums.

I uploaded another backup, this time with the forum caching turned off, and the subforums never pulled in.

why would it corrupt when it's live only??

what changes when there is a domain address directed to it as opposed to when you have a different file name than in the configuration??

[zenrei]

no. look in your db and make sure they are still there. When you re-sync, you sync your includes/def_tree.php to your db. So if they are gone from your db, re-syncing them will empty the def file. You may have to temporarily re-enable caching, then resync.

ahh, i see... so what i'm going to try when i get home is to change the folder name (because it seems to be able to cache when it's a different folder name) turn on caching, resynch... turn off caching and put it back on line.

Let me ask you something... I only need to cache the def_tree if i'm adding forums, right??

[Helter]

correct. You may also have some success just by chmodding def_tree.php to 644 AFTER you resync. Just remember youll have to change it back to add/remove forums

[zenrei]

correct. You may also have some success just by chmodding def_tree.php to 644 AFTER you resync. Just remember youll have to change it back to add/remove forums

helterskelter you RAWK HARD!!

It seems to have worked... this is what I did. I have 2 forums up (they're the same forum, just in 2 different folders) I edited the one that isn't "live"... i turned on the caching, then I pulled it up through my browser http://www.mysite.com/buforum/portal.php

Pulled in the subfolders... then i changed the CMOD for def_tree.php to 644 (I left the cache on, too, btw) and switched the folder names so the one i just worked on was live.

My subfolders are there... the cache isn't jacking up my def_tree.php and all is right with the universe.

I can't thank you enough for your help!! <img>

[zenrei]

whoa. I spoke too soon... even at 644 it over wrote.

i changed it to 444 and now i'm seeing what happens.

If i turn off the cache, though, the subfolders are pulled. do not pass go do not collect $200

[zenrei]

ok...

um... 444 didn't work either.

nothing's working.

[zenrei]

i tried setting all 3 to 444 and changing the hierarchy from true to false. No dice.

If i comment them out, it wipes out my subfolders.

WHY IS IT DOING THIS??

i had this site up for 3 months and this didn't happen. I'm going to remove the jail mod and drop the tables / values and see if that changes anything.

[zenrei]

ok!! i figured out how to make it work

thank you for your help, Helter, i really really appreciate it!!