My forums gone?

Hatz · Post by **Hatz** » Sun Feb 11, 2007 4:52 am

I just went into control panel and clear mysql data to reset server xp, I have uwc3. I did not however clear the website data.

My forums are down now and gives me this message:

phpBB : Critical Error

Could not query config information

DEBUG MODE

SQL Error : 1146 Table 'snk.phpbb_auto_config' doesn't exist

SELECT * FROM phpbb_auto_config

Line : 215
File : common.php

---------------------------------------

When i access my site through ftp, the files are all still there. What is wrong?

Hatz · Post by **Hatz** » Sun Feb 11, 2007 4:56 am

Oh wow.....please tell me that my tables I created, and all the post and registered users are not completely gone......

Nick|NFo · Post by **Nick|NFo** » Sun Feb 11, 2007 5:24 am

Phpbb stores all the users, posts, etc in mysql, the files you see are just the php files that access, write and modify the mysql database and its tables.

Yes, you did clear it. If you want to clear your uwc3 stats, you need to clear that table and only that table.

Hatz · Post by **Hatz** » Sun Feb 11, 2007 5:27 am

Ok wow.....is there no way to get it all back? And still, if it was all wiped, my website files are still there. Why can't i see my forums at all, even without users and posts anymore

Post by **Edge100x** » Sun Feb 11, 2007 10:00 am

Hatz wrote:Ok wow.....is there no way to get it all back?

We may have a backup. If you just did this, I'd recommend emailing to ask about that.

And still, if it was all wiped, my website files are still there. Why can't i see my forums at all, even without users and posts anymore

phpBB tries to connect to the database and load a table listing basic configuration information such as the name of the forums before it does anything else. If it can't retrieve the table, it dies.

Hatz · Post by **Hatz** » Sun Feb 11, 2007 12:02 pm

It's back today.....did any of you do this?

Post by **Edge100x** » Sun Feb 11, 2007 9:25 pm

Yup, we got your email and I had it restored from backups this morning. Sent you a reply, too

Hatz · Post by **Hatz** » Mon Feb 12, 2007 11:14 am

Edge I can't thank you enough man, you saved some1's life because if I had to remake all that shit....someone's life was gonna end lol. Thanks man.

IcEWoLF · Post by **IcEWoLF** » Mon Feb 12, 2007 3:54 pm

give him a hug, he deserves it.

/hug

BTW most companies charge you to backup ur stuff..which NFo graciously is not charging you to backup ur data.

Hatz · Post by **Hatz** » Sat Mar 10, 2007 12:08 pm

Not to bring back a dead topic, but with something you said earlier about mysql and it's tables. Where do i access my mysql tables? I don't even know where they are located. I am trying to fix a problem with the uwc3 mod on my server, some guys said this:

"Where is the sql table for uwc3 xp? I used my control panel to wipe out sql b4, and it deleted my effing website.....i assume this isnt the same sql"

Nick|NFo · Post by **Nick|NFo** » Sat Mar 10, 2007 12:23 pm

You can use this utility to maintain your mysql database, http://www.phpmyadmin.net. There are directions on the website that will explain everything in the documentation. There are only a few things you need to change to get it working, then there are a lot of advanced customizations you could do, but not necessary. All you would need to setup is username, password, hostname (localhost) and set it using cookie method so you have to login.

Hatz · Post by **Hatz** » Sat Mar 10, 2007 12:34 pm

Ok, is this the sql for my forums or my server? I want to access sql for my server. I also found the tables at this address ftp://206.253.195.194/forums/db/

but there doesn't appear to be a db section in ftp://206.253.195.194/server

shouldn't there be? Sql must have a table for my server to save the xp and it is working and has been for awhile. I can't seem to find this table that saves everyone's xp.

Nick|NFo · Post by **Nick|NFo** » Sat Mar 10, 2007 12:36 pm

You aren't going to see the database in your FTP, you never can. Mysql is on a different server, a mysql database server. That is why you need phpmyadmin to access and see it.

Hatz · Post by **Hatz** » Mon Mar 12, 2007 5:51 pm

This is the only way to do it? Just to delete the table and start fresh?

KILL3R · Post by **KILL3R** » Wed Mar 14, 2007 12:57 pm

Hatz wrote:This is the only way to do it? Just to delete the table and start fresh?

well like nick said yes