UBB.Developers Forums UBB.threads 7 Development How Do I? delete users not posts

Greetings..

As currently set up..when we delete a user all the posts they have made are eliminated.

Is there a way to simple delete the user from the database..but keep their posts

In this case the person I deleted did not have a lot of big contentful posts and so it really has npt thrown the conversation off ..
Hopwever I can see where deleting all posts would throw the conversation off.

In addition if we want a record of what went on....when we delete a user its gone.


Best
Renee

Right now... when you delete a user... their posts do not go away.

The display name should stay....it just will no longer be clickable to a profile.

There is a separate function under "Post Management" which lets you delete all posts by users.

So normal threads function should function the way you describe.

Hmmm Josh that would make sense.

Here is what I did:
I went to show/edit users...then the username and clicked delete this user.

All this users posts have disappeared entirely

However if I do a search by username I can get a list of the posts this user had made...I cannot actually get to these either by clicking..nor by looking inthethread...the posts are not there

Thankx Renee

Hmmmm....

That might be a database issue.

I'm not sure.

You could try closing the forums, then do the optimize command from the Admin menu... see if that helps.

If not, you might need to run the SQL command REPAIR TABLE w3t_Posts and perhaps w3t_Users

I won't pretend I know. If it were me... I'd probably try it.... but I would always backup first.

But since you can see the posts, and they aren't appearing... I'm thinking it's a database thing that somehow the delete went wrong and the usernumbers are confused.

Maybe a bug... I don't know.

I'll defer.... maybe one of the Daves or Rick will have an idea.

It's possible your placeholder user isn't there. Try running the following SQL query:

SELECT U_Username FROM w3t_Users WHERE U_Number='1'

That should come up with **DONOTDELETE**

If not then try running

SELECT U_Number FROM w3t_Users WHERE U_Username='**DONOTDELETE**'

tHE FIRST GOT:

Your SQL-query has been executed successfully


SQL-query :
SELECT U_Username FROM w3t_Users WHERE U_Number='1' LIMIT 0, 30

tHE SECOND:

ur SQL-query has been executed successfully
SQL-query :
SELECT U_Number FROM w3t_Users WHERE U_Username='**DONOTDELETE**' LIMIT 0, 30

Those are the queries...

I think he'll want to know what results they returned.

LOL Josh

I know

what I think this means is NO nothing was found ;-)

Try this query:

SELECT U_Number,U_Username FROM w3t_Users WHERE U_Number=1 OR U_Username LIKE '%DONOTDELETE%'

If there is still no result, that probably means that you need to create a user#1. U_Number would be 1, and U_Username would be '**DONOTDELETE**'. I'm not sure if the other columns matter, so you should probably wait for Rick to explain what to do.

By the way, which version of UBB.threads are you using?

Ran it and again no results come up ...

Which version of UBB.threads are you using?

Its 6.1.1

Greetings!

Ok all fixed...
I ran these two sql commands:

First:

INSERT INTO w3t_Users (U_Username,U_Groups) VALUES ('**DONOTDELETE**','-4-')

Then:

UPDATE w3t_Users SET U_Number='1' WHERE U_Username='**DONOTDELETE**'

Thanx again
Renee