Support Thread

Fix: Cannot Edit or Add New User Ranking Records in APG vNext Admin

Fix: Cannot Edit or Add New User Ranking Records in APG vNext Admin — APG vNext Guide

Some administrators encountered an issue where clicking Edit or Add New in the Admin Panel → Members → User Rankings page produced no result or a silent failure.

Symptoms

  • Clicking "Add New Rank" opens a form but saving does nothing
  • Editing an existing rank shows the form but changes are not saved
  • No error message is displayed
  • Issue often occurs with Internet Explorer or older browser versions

Cause

The User Ranking edit form uses JavaScript for inline editing. The issue was caused by a JavaScript event binding problem that affected older browsers (IE8/9) and certain Chrome versions with strict mode enforcement.

Fix

  • Try a different browser: Switch to Chrome or Firefox latest version.
  • Upgrade APG vNext: This was fixed in APG vNext 4.4 — see the 4.4 release notes.
  • Workaround: Use the direct SQL approach — insert a new row into the APG_UserRankings table via SQL Server Management Studio as a temporary workaround.

See also: User Rankings Configuration Guide.

Cannot Edit or Add New Record in User Ranking - APG vNext Fix

The User Ranking editor in Admin Panel sometimes fails to save new or edited ranking records. This is typically caused by duplicate threshold values, a CSRF token mismatch, or a missing database index.

Fix 1 - Remove Duplicate Thresholds

-- Check for duplicates:
SELECT PostCountMin, COUNT(*) AS Cnt
FROM   apg_UserRankings
GROUP  BY PostCountMin
HAVING COUNT(*) > 1;

-- Remove duplicates:
WITH CTE AS (
  SELECT *, ROW_NUMBER() OVER (PARTITION BY PostCountMin ORDER BY RankID) rn
  FROM apg_UserRankings
)
DELETE FROM CTE WHERE rn > 1;

Fix 2 - Add Rankings Directly via SQL

INSERT INTO apg_UserRankings (RankName, PostCountMin, RankOrder)
VALUES
  ('New Member',     0,   1),
  ('Member',        10,   2),
  ('Senior Member', 50,   3),
  ('Veteran',      200,   4);

Fix 3 - CSRF Token (APG vNext < 4.3)

In versions before 4.3, the ranking form's CSRF token expired after 30 minutes. Refresh the admin panel page before editing to get a fresh token.

Related Resources

Cannot Add or Edit User Ranking Records in APG vNext

If the User Rankings editor in Admin Panel returns an error or fails to save new ranking records, the cause is almost always one of three things: insufficient database permissions on apg_UserRankings, a uniqueness constraint violation on the rank threshold, or a validation error that the UI is not clearly displaying.

Step 1 — Check Database Permissions

-- Verify app pool identity has write permission on apg_UserRankings:
SELECT HAS_PERMS_BY_NAME('apg_UserRankings', 'OBJECT', 'INSERT') AS CanInsert,
       HAS_PERMS_BY_NAME('apg_UserRankings', 'OBJECT', 'UPDATE') AS CanUpdate,
       HAS_PERMS_BY_NAME('apg_UserRankings', 'OBJECT', 'DELETE') AS CanDelete;
-- Expected: 1,1,1 — if any are 0, grant the missing permission:
GRANT INSERT, UPDATE, DELETE ON apg_UserRankings TO [IIS AppPool\YourAppPool];

Step 2 — Check for Duplicate Threshold Values

Each user ranking must have a unique post count threshold. If two rankings share the same threshold, the insert will fail with a uniqueness constraint error:

-- Identify duplicate thresholds:
SELECT PostThreshold, COUNT(*) AS Count
FROM   apg_UserRankings
GROUP  BY PostThreshold
HAVING COUNT(*) > 1;

-- Fix: update the duplicate threshold to a different value
UPDATE apg_UserRankings
SET    PostThreshold = 500  -- change to a unique value
WHERE  RankID = [duplicate RankID];

Step 3 — Validate Rank Name Uniqueness

-- Rank names must also be unique:
SELECT RankName, COUNT(*) AS Count
FROM   apg_UserRankings
GROUP  BY RankName
HAVING COUNT(*) > 1;

Configuring User Rankings in APG vNext

User rankings (e.g., Newbie, Member, Senior Member, Expert) are displayed alongside member avatars in post views. They motivate participation by giving members visible recognition as they contribute more to the community. Configure as many ranking tiers as makes sense for your community — typically 5 to 10 tiers provide sufficient granularity without overwhelming members with too many categories.

Recommended Default Rankings

Rank Name        Min Posts    Icon
-----------      ---------    ----
Newcomer         0            ⭐
Member           10           ⭐⭐
Regular          50           ⭐⭐⭐
Contributor      200          🥉
Senior Member    500          🥈
Expert           1,000        🥇
Community Leader 5,000        🏆

Rank Icons and Customisation

User ranking labels can include emoji, plain text, or HTML-encoded special characters. For image-based rank icons (stars, badges, shields), upload rank images to /assets/images/ranks/ and reference them in the rank configuration. Rank images display next to the member's username in post views, providing a visual hierarchy that helps members identify experienced contributors quickly.

User Ranking Display in Posts and Profiles

Once user rankings are correctly configured and saved, they appear automatically in two locations: beneath the member's avatar in thread post views, and in the member's public profile page. The ranking title is shown in a styled badge that inherits the forum skin's colour scheme. Administrators can customise ranking badge colours per tier to create a visual progression that members find aspirational — a gold badge for Expert status, for example, encourages members to post more to achieve the visible recognition. Ranking updates happen in real-time as members' post counts cross each threshold, requiring no manual intervention once the ranking tiers are defined and saved correctly.

Related Resources

Looking for more help? Browse the support forum or check the Knowledge Base.