1
Hatrix
Resetting Post Count
  • 2007/5/13 16:30

  • Hatrix

  • Just popping in

  • Posts: 27

  • Since: 2005/3/12


Hey guys..

For some reason the post count on my sites have reset to -1.

Do you know why it did that and do you know how to reset it back to the original numbers?

2
fosterm
Re: Resetting Post Count
  • 2007/5/22 21:35

  • fosterm

  • Just popping in

  • Posts: 93

  • Since: 2005/8/7 2


I just realized today that my site also has all of the posts reset to -1.

running 2.2.4

Anyone else having this issue or know what causes it?

3
Will_H
Re: Resetting Post Count
  • 2007/5/23 1:10

  • Will_H

  • Friend of XOOPS

  • Posts: 1786

  • Since: 2004/10/10


module/vers?

4
fosterm
Re: Resetting Post Count
  • 2007/5/23 2:40

  • fosterm

  • Just popping in

  • Posts: 93

  • Since: 2005/8/7 2


Hi Biteronboard

The posts field in what I guess would be a basic XOOPS db table are all set to -1. The db table is user_profile. All 200+ entries in that table have the posts = -1.

I know that recently in the last week or so that this was not this way.

I noticed the issue first while perusing my forum which is cbb 3.01.

I assume I can go to a recent DB backup and restore the posts field, but I am curious as to what caused this.

UPDATE:

I have found an old db backup that has the correct number of posts listed. The question is now, how do I go about inserting the data from the old db for the posts field into my current db?

Thanks for the help.

5
organix
Re: Resetting Post Count
  • 2007/5/29 9:13

  • organix

  • Just popping in

  • Posts: 8

  • Since: 2003/11/5


I have the same problem. All post counts resetted to -1.
Running XOOPS 2.2.4 and CBB Version 3.07.

What are the odds, that some people here have currently the same problem.

Ok, for now I have found a script here on xoops.org to sync the users.




thanks
Markus

6
riosoft
Re: Resetting Post Count
  • 2007/5/29 11:28

  • riosoft

  • Not too shy to talk

  • Posts: 191

  • Since: 2003/11/8


esxoops.com (xoops 2.2.x) recently got the same problem!
Could be an unknow vulnerability? Is very casual the same issue at same time and ofcourse in different sites.

Greetings
...

7
gtop00
Re: Resetting Post Count
  • 2007/5/29 12:08

  • gtop00

  • Friend of XOOPS

  • Posts: 498

  • Since: 2004/11/13


XoopsGreece has the same problem too: Running XOOPS 2.2.4 and CBB Version 3.04.

8
irmtfan
Re: Resetting Post Count
  • 2007/5/29 16:14

  • irmtfan

  • Module Developer

  • Posts: 3419

  • Since: 2003/12/7


yeap, im nearly sure its a complicated XOOPS 2.2 bug
sync_users_xoops22_xoops20
upload it to modules/profile/admin/sync.php and run directly in your browser.of course you should be logged in as webmaster.

9
fosterm
Re: Resetting Post Count
  • 2007/5/30 3:41

  • fosterm

  • Just popping in

  • Posts: 93

  • Since: 2005/8/7 2


Hi again :)

Thanks for confirming this is an issue.

I hand entered my posts information into my database to correct the error. It has now occurred again. It seems to coincide with a bogus registration by what I would call a spam bot that posts in the comment section of my news stories in my News module.

This bot just recently came and left a couple of post and lo and behold I have the -1 posts again.

I tried the script and it seemed to work well on the lower level post, but as for my posts (350+) it only restored that count to about 160.

Does anyone have a way to prevent this from happening yet? Can anyone confirm that it is linked to bot spam?

Just found this thread.....it is the same guy that I referred to as a spam bot. go here https://xoops.org/modules/newbb/viewto ... hp?topic_id=59144&forum=7

10
plusangel
Re: Resetting Post Count
  • 2007/5/30 5:03

  • plusangel

  • Just popping in

  • Posts: 90

  • Since: 2005/2/2 1


Just want to confirm

Quote:
It seems to coincide with a bogus registration by what I would call a spam bot that posts in the comment section of my news stories in my News module.

This bot just recently came and left a couple of post and lo and behold I have the -1 posts again.


happens to xoopsgreece aswell.

So we talk about the same story :(
The official greek support site for xoops

Login

Who's Online

67 user(s) are online (53 user(s) are browsing Support Forums)


Members: 0


Guests: 67


more...

Donat-O-Meter

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

Latest GitHub Commits