Page 1 of 1

[SOLVED THANKFULLY :) ] Site Down: SQL Error !

PostPosted: Thu Jan 03, 2008 9:21 pm
Author: spaniel
Your phpBB Version: 2.0.
phpBB Type: Integramod 141
MODs: No
Your knowledge: Beginner
Board URL: [url]http://[/url]

PHP Version: 4.4.7
MySQL Version: 5


What was done before the problem appeared?
trying to figure out the customs rank feature, in list_special_rank i accidentally changed the table [RANKS_SPECIAL] to [CUSTOM_RANKS] and not surprisingly i'm gettin the error (see below)


What was done to try to solve the problem?
i don't know how to fix SQL errors so i'm stuck



De.scription and Message

i'm now getting the following db error msg across the whole site:

[code]General Error  Could not read list informations  DEBUG MODE  SQL Error ]


How do i fix the db to get the site up again?


Many thanks.

Re: Site Down: SQL Error !

PostPosted: Fri Jan 04, 2008 1:14 am
Author: CaNNon
For a quick, fix swapping the tables back could get it running again.

If I follow what you have done there still intac you just put the names back.

changed the table [RANKS_SPECIAL] to [CUSTOM_RANKS]

Re: Site Down: SQL Error !

PostPosted: Fri Jan 04, 2008 1:41 am
Author: Helter
he may have actually corrupted a few of his cache files.
check your chmods on
profilcp/def/def_userxxxxxx.php
they all need to be set to 666

as a last resort, rename the folder
root/profilcp/def to def1
upload a new copy of this file and set your "def" folder permissions to 777 and your file permissions in it to 666

PostPosted: Fri Jan 04, 2008 2:05 am
Author: spaniel
Oh what a relief !! My god was i having kittens!

I'd backed up my def files a couple of days ago so i did what u suggested and everything's back to normal.

But that SQL is scary stuff. I shan't be going near that again in a hurry. <img>


Thanks for all your advice, it's very much appreciated.