XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Modules Support forums / 
  3. Module troubleshooting 
  4.  / newbb something wrong after synchronising
Register
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: 941

  • 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: 941

  • 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

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

389 user(s) are online (307 user(s) are browsing Support Forums)

Members: 0

Guests: 389

more...

Donat-O-Meter

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

Latest GitHub Commits