News:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord

Main Menu

User Deleted on database

Started by playdiune, December 16, 2010, 09:47:12 AM

Previous topic - Next topic

playdiune

Hello
Today i Deleted a user account and then i changed An existing user to the name of the user i Deleted before. Now the user exists on the statistics but i cant edit the profile . I allways get the redor saying the user doesnt exist.
What can i do on database to keep this user active ?
My personal forum is now improving thanks to the Power of SMF

http://www.new-digital.net

playdiune

SOLVED !!

I deleted this user, then i created another one.

then i went to phpmyadmin and i aplied this code

UPDATE smf_messages SET ID_MEMBER='NEW_MEMBER_ID' WHERE postername='OLD_MEMBER_USERNAME';

its ok for now !

thanks
My personal forum is now improving thanks to the Power of SMF

http://www.new-digital.net

cicka

You should run a query for the topics table too. That is if that user had created topics so they will also get them back.

Advertisement: