MyBB Community Forums

I have prostats installed and reset my members referral count to 0 using this.
UPDATE mybb_users SET referrals = ''
Now, In the prostats column for top referrals it still says I have 19 and my profile says 0 whats wrong? I de-activated and re-activated the plugin already

Truncate the table too.

(2010-11-20, 09:05 PM)iBf Wrote: [ -> ]Truncate the table too.

How?

You can do it from phpmyadmin - watch the whole video.
http://www.youtube.com/watch?v=JQ8bDL4AySc
im not quite sure however, but from what i know this is it. This empties the table and resets it back to 0

However from this, this confirms it

Quote:In SQL, the TRUNCATE TABLE statement quickly removes all data from a table, typically bypassing a number of integrity enforcing mechanisms.
en.wikipedia.org/wiki/Truncate_(SQL)

What is the table called?

Bump.