Activity Points is erratic in its calculations

  • Hi, there. Our forum seems to have users that have negative activity points, and I'm pretty that shouldn't be possible. In general, the whole thing seems incredibly glitchy, as a lot of people seem to have strange totals that are unusually low.

    Is there any way to "refresh" the counts?

    EDIT: We also imported our data from vBulletin, if that makes any difference.

  • I already rebuilt the counters after importing, though. And I certainly don't want to do it from the ACP, given that we have about 8GB of data in the database.

    Is that really the problem, though? I know all the counters were updated.

  • Kann jemand der davon betroffen ist, bitte im ACP alle Anzeigen aktualisieren und dann folgende Datenbank-Abfrage ausführen?

    (Hinweis: U.U. muss man wcf1 durch wcf2 oder dergleichen ersetzen.)

    SQL
    SELECT		*
    FROM		wcf1_user_activity_point user_activity_point
    LEFT JOIN	wcf1_object_type object_type
    ON		(object_type.objectTypeID = user_activity_point.objectTypeID)
    WHERE		user_activity_point.userID = <userID>

    <userID> muss dabei durch die ID des Benutzers ersetzt werden, bei dem das Problem auftritt.

    This is from a German thread.
    Some other users had this error as well.

    Check the user id which shows negative points. And then do this sql query to find out which table is responsibile for the negative points.
    Come back with the results and we can have a furhter look.

    EDIT: --> If nothing shows up from thes sql querry
    ACP -> Users -> Users ->Acitivity Points ->

    hit the update points per activity button

    and then I'm afraid you would need to rebuild the data
    Have a look at this:
    CLI Import

    THis should be faster than using rebuild data via ACP

Jetzt mitmachen!

Sie haben noch kein Benutzerkonto auf unserer Seite? Registrieren Sie sich kostenlos und nehmen Sie an unserer Community teil!