1
Hadesteam
newbb something wrong after synchronising
  • 2017/4/11 15:31

  • Hadesteam

  • Not too shy to talk

  • Posts: 162

  • Since: 2011/9/5 1


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/modules/newbb/viewtopic.php?topic_id=8572

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

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

Please help!

2
Bleekk
Re: newbb something wrong after synchronising
  • 2017/4/11 17:00

  • Bleekk

  • Theme Designer

  • Posts: 940

  • Since: 2002/12/14


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?

3
Hadesteam
Re: newbb something wrong after synchronising
  • 2017/4/11 18:43

  • Hadesteam

  • Not too shy to talk

  • Posts: 162

  • Since: 2011/9/5 1


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.

4
Bleekk
Re: newbb something wrong after synchronising
  • 2017/4/12 11:28

  • Bleekk

  • Theme Designer

  • Posts: 940

  • Since: 2002/12/14


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

5
Hadesteam
Re: newbb something wrong after synchronising
  • 2017/4/12 16:47

  • Hadesteam

  • Not too shy to talk

  • Posts: 162

  • Since: 2011/9/5 1


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

Login

Who's Online

216 user(s) are online (152 user(s) are browsing Support Forums)


Members: 0


Guests: 216


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Mar 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits