Rmoved User Still Has User ID Link

[alexwriting]

Hi All,

I went into the admin control panel and removed a user, but kept the posts he made. In the "Thread Starter" column of the posts, his name remains linked to a now non-exsistant user ID:

http://www.domain.com/forum/member.php?action=getinfo&userid=238

Is there anyway way to undo that so it is unlinked, as if he were only a guest who posted?

Many thanks,

Alex

[Admin]

Run this query:

UPDATE thread SET postuserid=0 WHERE postusername='hisUserName';

(hisUserName is the delete user's name)

[alexwriting]

Sounds like just what I need! Where do I run that? From the admin panel? Thanks a million, Firefly

[Xanthine]

Run it from phpmyadmin.