Table Prefix

[Sfx23]

Ok so I use a free host (byethost). I use a cpanel. I installed a mod in which i shouldn't have. So the person who made it told me to go PHPAdmin and then click SQL. Well when i insert the code that they gave me it says this:

Error

SQL query:

UPDATE smf_settings SET value = FALSE WHERE variable = "use_secure_login"

MySQL said: Documentation
#1146 - Table 'b24_897878_smf.smf_settings' doesn't exist

=============================================
Then the person said change the table prefix which i remember was Smf_

how can i change the query/code they gave me to make it go into the correct prefix

Here is the Query:

Code Select Expand

UPDATE smf_settings SET value=FALSE where variable="use_secure_login";

Please help me, because none of my forum users can login.

[karlbenson]

what prefix did you install the forum with?

did you use smf_ or your own?

Look to the left hand side (frame) of php my admin at the tables in your database
Do they have smf_{tablename} or something else

[Sfx23]

When i installed the forum i remember it was smf_

[karlbenson]

try

UPDATE `smf_settings` SET value=FALSE where variable="use_secure_login";

[Sfx23]

Nope.
====================
Error

SQL query:

UPDATE `smf_settings` SET value = FALSE WHERE variable = "use_secure_login"

MySQL said: Documentation
#1146 - Table 'b24_897878_smf.smf_settings' doesn't exist

[karlbenson]

try to find the row manually then

select your database

Select smf_settings table

Goto the last page (hopefully your variable will be there)

Click edit, type false or 0

[Sfx23]

[nofollow]

Im putting it in the right place, thats it right?

[karlbenson]

that is the right place
are you in the right database?

is the database where you store smf definately called smf?

[Sfx23]

This is the database name: b24_897878_smf

[Sfx23]

I just noticed this, i clicked queries and it shows no tables:

[nofollow]

[karlbenson]

then its screwed up your forum completely as its wiped ALL of your tables from your database

you'll have to revert to your backup. (I hope you took a recent one)

[Sfx23]

Are you kidding me? I can never login again? My forum was like three days old, so i didnt bother making a back-up!

[karlbenson]

your tables contain
> all your settings
> all your posts
> all your member info
> all your pms
> all your stats
pretty much everything except the images, themes, and php files.

Before installing/testing ANY modification you should always take a backup of both your database and files. (that goes with ANY forum software, because things can go wrong)

I backup my forums database EVERY day or so. (or more often if I'm making changes)

[voy-tech]

try

UPDATE `smf_settings` SET value=FALSE where variable="use_secure_login";

I think it should be in that way:

Code Select Expand


UPDATE `smf_settings` SET use_secure_login = '0' ;


[Dragooon]

No because user_secure_login is not a Column in that database table, variable and value are. So we are setting value the value required where the variable is user_secure_login.

[Rumbaar]

If it was three days old, then it will hopefully only have lost a little bit of information.  I've never know a mod to totally DROP all tables from a db tho, what was the mod and how did you install it?

Did you try anything db related yourself?

You can get the sql file from the install package and run the install.php file.  This should at least recover the base fresh install of the forums db.