1
shalommemphi
Resetting the submitted news counter

Do to a problem I had with a module my submitted news counter is wrong. It did not reduce the count once I approved.

How would I go about resetting this counter in the sql database. Where would I find this field??
Helping each other with Knowledge

2
shalommemphi
Re: Resetting the submitted news counter

Still hoping to get help on where this field is to correct, my counter is off, due to a prior bug. Just need to set it to the correct number.
Helping each other with Knowledge

3
thepaul
Re: Resetting the submitted news counter
  • 2007/2/26 21:19

  • thepaul

  • Just popping in

  • Posts: 12

  • Since: 2006/6/20


Same issue here. Really need to reset the "submitted news" count to 0.

Can anyone point me in the right direction?

4
thepaul
Re: Resetting the submitted news counter
  • 2007/2/28 15:47

  • thepaul

  • Just popping in

  • Posts: 12

  • Since: 2006/6/20


Anyone .... anyone .... Beuler ....

5
stefan88
Re: Resetting the submitted news counter
  • 2007/2/28 16:18

  • stefan88

  • Community Support Member

  • Posts: 1086

  • Since: 2004/9/20


Hi,

First, when you play with database, you should DO BACKUP FIRST!!!

It should be table PREFIX_stories and the "storyid" value where PREFIX is the prefix you selected when installing xoops. It is autoincrement value.

Check if you control panel has an option to edit it.

If not, you still can change it with SQL command: ALTER TABLE tablename (this will be PREFIX_stories) AUTO_INCREMENT=*** where the *** is the next value you want.

And again DO BACKUP FIRST !!! If you are not shure about it, better don't do it, or try it on a test system first.

..

Login

Who's Online

482 user(s) are online (391 user(s) are browsing Support Forums)


Members: 0


Guests: 482


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