xoops forums

Hadesteam

Not too shy to talk
Posted on: 4/11 11:31
Hadesteam
Hadesteam (Show more)
Not too shy to talk
Posts: 158
Since: 2011/9/5 7
#1

newbb something wrong after synchronising

I deleted from the database ONLY inactive users who never logged in, later I made a synchronization in the admin panel and disagreed with the username that the topic was, displayed in the topics view when I restored the old user database the problem still occurs. My version of xoops 2.5.7
http://www.kulturystyka.org.pl/module ... ewtopic.php?topic_id=8572

See this picture:
http://www.kulturystyka.org.pl/images ... c-przy-stronie/forum1.png
http://www.kulturystyka.org.pl/images ... c-przy-stronie/forum2.png

When I enter a topic, the user name is correct.

Please help!

Bleekk

Theme Designer
Posted on: 4/11 13:00
Bleekk
Bleekk (Show more)
Theme Designer
Posts: 898
Since: 2002/12/14
#2

Re: newbb something wrong after synchronising

Do I understand you correctly?

1. you did a backup of your database
2. then maybe a couple of days you changed your database
3. then you restored it from your backup
3. now some users are displayed as anonymous?

Hadesteam

Not too shy to talk
Posted on: 4/11 14:43
Hadesteam
Hadesteam (Show more)
Not too shy to talk
Posts: 158
Since: 2011/9/5 7
#3

Re: newbb something wrong after synchronising

Some people appear as anonymous because in 2007 I moved the forum from the SMF script. Now I've deleted only the users who have never logged in, and that's how it looks like I wrote before.

Strange because when it comes to the topic is the user name is valid, only in the view (topic viewforum) does not agree.

Bleekk

Theme Designer
Posted on: 4/12 7:28
Bleekk
Bleekk (Show more)
Theme Designer
Posts: 898
Since: 2002/12/14
#4

Re: newbb something wrong after synchronising

Do you find the username if you search for it in the database?

Hadesteam

Not too shy to talk
Posted on: 4/12 12:47
Hadesteam
Hadesteam (Show more)
Not too shy to talk
Posts: 158
Since: 2011/9/5 7
#5

Re: newbb something wrong after synchronising

i used this in sql:

SELECT * FROM `xoops_users` WHERE last_login = '' OR last_login IS NULL

and delete all who not login (not write on forum etc)

then, edit xoops_bb_topics in edit++ but only change Polish characters in name of topic