I can not log as admin or user

[vivid]

I have no backup

any tool there can fix databases?

[Deprecated]

Unless somebody better than I can help you out, and there are plenty of those people on this site, I think you're screwed.

You have now probably learned the lesson to backup your site, and you should do it frequently. I like to explain it this way:

There are two kinds of data: data you have backed up, and data you will lose forever some day.

I hope I'm wrong about your data being permanently borked. If so you are just going to have to start over, all your posts gone and all your members having to join new.

My advice for you is that you should get somebody in your forum administration that has a better understanding of how to operate the technical side of the forum.

[metallica48423]

Theres nothing further we can do to investigate if you cannot gain access to your hosting control panel to manage your mysql database.  As I said, you need to contact your host to gain said access so that the database can be checked into.

[Deprecated]

Yeah, Metallica. I told him he needs cpanel access and you told him he needs cpanel access.

I think we are facing two issues here, that the OP appears to be technically challenged, and he also appears to be language challenged. I think we're facing an unsolvable problem unless one of those changes.

Actually it appears that his db is totally hosed and I doubt even with full technical and language competence that his problem can be fixed. He's probably facing a full reinstall and starting over from a scratch. Thus my lament about lost data, a good enough idea to occupy my signature line for a while.

[metallica48423]

True enough, though I largely prefer to avoid classing members (yes, i am aware that makes me either inexperienced or saintlike in the big picture of support ) by their technical or communicative abilities.  I find it best not to judge i guess.  I try to work with everyone.

I like to check first though to be sure.  I have had circumstances arise before where database oddities are just a technical misunderstanding.  That said.. yeah, it doesn't sound too pretty

[Deprecated]

I certainly meant no slight to the OP, just was stating my opinion of why the solution of this problem is not progressing.

Actually, those who know the least benefit the most from the SMF site, particularly those whose technical skills are at a beginner level. They would have no hope at all of solving their problems without access to somebody with technical skills, and SMF is undeniably the mothership of SMF knowledge.

As far as the language, well that's just a different theme installed on the basic 1.0 human, right? I believe I made comment earlier that the OP might ask in one of SMF's language boards although I believe their main purpose is to localize SMF for their language. Perhaps the OP might find somebody who speaks his own language who might guide him through the process.

I agree that the case isn't 100% unlikely to be fixable as I too have seen a hopeless situation turn into a good save, but without better information on the actual state of the OP's database it appears unlikely to be resolved.

I'm going to assume at this point that unless we can convince the OP to get access to his cpanel it's probably a lost cause.

[vivid]

I can access there. I should change my password there also
but still my child forums my topic all cracked. the frontpage seem half-blank

[vivid]

I change my password in phpmyadmin
but still I can not acess. all my members also can not access.

Password security has recently been upgraded. Please enter your password again.

[Deprecated]

You can't just change your forum password using phpMyAdmin because the passwords are encrypted. If you put a plain text password in your database it will decrypt to something meaningless.

Verify that your account email address is correct, and then use the forum's "Forgot your password?" feature. You should be able to login to your forum that way.

Let us know if this works.

[vivid]

You can't just change your forum password using phpMyAdmin because the passwords are encrypted. If you put a plain text password in your database it will decrypt to something meaningless.

Verify that your account email address is correct, and then use the forum's "Forgot your password?" feature. You should be able to login to your forum that way.

Let us know if this works.

already tried it
but useless

I did al plossible things

the most dengrous thing is that my topics child forums
seem gone with wind

[Deprecated]

Okay, it is possible to take a plain text password and encode it, then put that in your database for admin password. My understanding is that SMF passwords are encoded using the PHP function sha1(). In theory some code could be written that would turn a plain text password into SMF's sha1 encoded format. Unfortunately I'm not skilled enough to write it, but perhaps one of the SMF code experts might help you.

Hey SMF coding experts! Is there any utility already written to turn a plain text password into the SMF sha1 encoded password? Or is anybody interested in writing one?

I don't know if we'll ever get vivid's forum back without it.

[metallica48423]

Its pretty simple.

take the username, turn it all lowercase.  prepend it to the password.  Hash it with sha1.

for example

User: Metallica48423
Pass: smfpwnsj00 (and no -- this is not my password -- don't bother trying it )

unhashed: metallica48423smfpwnsj00
hashed: 551e74401705a0067eac85cf90d37f1f7d4c04e9

You can do it in phpmyadmin.  Go into the members table and find the row for the member.  Click on the edit button.  In the password field, enter the unhashed value.  In the left dropdown, select sha1.  Save.  It'll hash the password

Alternatively, you CAN also hash just the password in md5 -- but you'll have to enter it twice so SMF can rehash it.  But MD5 is not as secure, so it will not allow you to fully login until it is properly entered and rehashed

[Deprecated]

Wow, that's brilliant Metallica! I was reading the code and now this makes more sense:

Code Select Expand

sha1(strtolower($user_settings['member_name']) . un_htmlspecialchars($_POST['passwrd']))

Vivid, let us know if you understand what Metallica said in his post above. Can you do it?

If you don't understand it, tell us what your admin account name is and we can encode the password for you and post it here. (Don't post your password. We'll pick a temporary one.) You should then change it immediately after logging in, or otherwise anybody reading this thread would be able to login to your account.


ETA: Yeah, I tried it on my test account and it worked perfectly.

[vivid]

nothing new
same problem

can somebody from smf help me
I am ready to sign as charter member

plz my forum is so productive

[ccbtimewiz]

nothing new
same problem

can somebody from smf help me
I am ready to sign as charter member

plz my forum is so productive

Well if you don't have cpanel access, what exactly are we able to do?

[Deprecated]

nothing new
same problem

Were you able to change your admin password using phpMyAdmin as described above?

[metallica48423]

sir, we can unfortunately not help you if you cannot answer the questions for the information we need to know in order to be able to figure out the problem, its cause, or a solution.

I do not say this to be rude in the least bit and such is not my intent but without the proper information there is nothing that we can do.  The same would be true with a charter membership -- we simply do not have access to anyone's boards or hosts without being provided with such information by the owner of the board/hosting account.

If you'd like any of us to check on your database then you need to provide the means for us to gain access to it, preferably by private message.

[vivid]

plz check your inbox

[vivid]

nothing new
same problem

Were you able to change your admin password using phpMyAdmin as described above?

yes, I followed all your instructions

[Deprecated]

Good luck and I hope Metallica fixes your problem.

He is your last, best chance.