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:
UPDATE smf_settings SET value=FALSE where variable="use_secure_login";
Please help me, because none of my forum users can login.
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
When i installed the forum i remember it was smf_
try
UPDATE `smf_settings` SET value=FALSE where variable="use_secure_login";
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
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
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fimg187.imageshack.us%2Fimg187%2F4572%2Fsqlya5.th.png&hash=c3d1f3ebb7cf9b93c79b4c684ba47ba592a20e69) (http://img187.imageshack.us/my.php?image=sqlya5.png)
Im putting it in the right place, thats it right?
that is the right place
are you in the right database?
is the database where you store smf definately called smf?
This is the database name: b24_897878_smf
I just noticed this, i clicked queries and it shows no tables:
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fimg247.imageshack.us%2Fimg247%2F6693%2Fsql2ze9.th.png&hash=fc1a703b225faefaacbf06b309f6df4eec3f851e) (http://img247.imageshack.us/my.php?image=sql2ze9.png)
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)
Are you kidding me? I can never login again? My forum was like three days old, so i didnt bother making a back-up!
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)
Quote from: karlbenson on August 17, 2007, 08:23:50 PM
try
UPDATE `smf_settings` SET value=FALSE where variable="use_secure_login";
I think it should be in that way:
UPDATE `smf_settings` SET use_secure_login = '0' ;
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.
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.