You are not logged in. Please login or register.
PunBB Forums → PunBB 1.2 troubleshooting → Restoring the db after the Altan hack
Hey all,
Was hacked on Saturday morning and he deleted 3 of my forums.
I upgraded to 1.2.7, then put it in maintenance mode until my host restored the db.
They finally just emailed me and said they restored it - but I'm not seeing the 3 forums.
What should I be looking for in phpMyAdmin to see if they're really there, and if they are, how can I get punBB to recognize them again?
Thanks!
OK I just went in and I see the forums in the db, so they were restored. there's actually 4 forums that he deleted, the bastard.
so what do I have to edit in the punBB code to associate the forums?
id 7, 12, 16, 18 are the forums that were deleted.
Well, if you restored the full database, you should see them like it was before. I really can't tell without looking in the database.
well I'm thinking because I upgraded to 1.2.7 with the databases NOT in there at the time, now that they're restored - punBB doesn't see them?
I can give you access..
edit: I went from 1.2.4 to hacked (4 forums removed) to 1.2.7, then db restore.
Well, is the category id for it an existing category (I'm just guessing here)? If not, create a category with that ID, or switch the forums to new categories via MySQL
the db was restored to its previous state before it was hacked.
however, like I said, I updated from 1.2.4 to 1.2.7 between the time it was hacked and the time the db was restored.
so punbb thinks I have 4 less dbs than I really do.
so where in the punbb code can I poke around and make sure that it looks for forum ids 7, 12, 16, 18 (the forums that were deleted but are now restored) and stick those in there?
do i need to delete some cache files or something?
4 less dbs? o.O
Well, if you updated to 1.2.7 FILES but have a 1.2.4 for database, you should run 12_to_127_update.php or whatever it's called to update it (which is basically just incrementing the version).
That shouldn't do anything though. Like Rickard said, it's hard to tell without seeing the database
There were no database changes between 1.2.4 and 1.2.7 apart from the version number increment, so the fact that you updated the scripts has no effect what so ever. I guess you could try deleting the .php scripts in the cache-folder. I doubt it would do any good though.
@Smartys:
i ran the updater and it updated fine.
here's what's in my cache folder:
cache_bans.php
cache_config.php
cache_quickjump1.php
cache_quickjump3.php
cache_ranks.php
.htaccess
should i delete it all?
thanks for the help guys.. i just really want to get this thing back up and running. i have 750 users wondering wtf is up. 
All except the .htaccess
did that, but they're still not showing up.
I just took this screen shot of the admin. The ones in red are the ones that were deleted from the forum and are now restored, but not showing up on the site.
and as you can see from the dropdown, they're still being recognized.
I don't want to re-add that forum to the category that's not showing up on the site because I'm thinking it might wipe out what's in there, which I don't want.
Rickard whatever screen shots you need on phpMyAdmin, let me know.
Those are categories, not forums. There are no forums in those categories it seems
yeah there are..
and here's how it's showing on the site:
and cat_id is set correctly for them to an existing category id?
and cat_id is set correctly for them to an existing category id?
i guess? like i said, the db is restored back to normal, i updated punbb to 1.2.7.
how would i check that?
Check cat_id on the forums, then check the categories table to see if that's a valid ID
i'm a noob with phpmyadmin.. the cat IDs are listed in the screen shot.. here's what the categories are showing:
i'm leaving work but I'll be home shortly if you respond.. thanks for the help here so far.
OK, now what's the cat_id column of the forum table?
the one in post #14?
yeah, what values do they have in the cat_id column?
That's odd, it seems perfect :-/
Can you try clearing your cache (on your browser) or Ctrl-F5?
done that several times. 
And all of your files are clean 1.2.7 files?
PunBB Forums → PunBB 1.2 troubleshooting → Restoring the db after the Altan hack
Powered by PunBB, supported by Informer Technologies, Inc.
