Updating an mcp server metadata does not work

[twdsilva]

Describe the bug
Updating an mcp server currently does not work. This is because the index in mongodb name_1_versiondetail.version_1 is created with the old column name. The columns was renamed in this commit.
5c238ec

To Reproduce
Steps to reproduce the behavior:

1. Post mcp server metadata

 {
      "name": "tdsilva",
      "description": "Integrate the Productboard API into agentic workflows via MCP",
      "repository": {
        "url": "https://github.com/kenjihikmatullah/productboard-mcp",
        "source": "github",
        "id": "939104710"
      },
      "version_detail": {
        "version": "0.0.1",
        "release_date": "2025-05-16T19:12:44Z",
        "is_latest": true
      }
    }

2. Update mcp server metadata

 {
      "name": "tdsilva",
      "description": "Integrate the Productboard API into agentic workflows via MCP",
      "repository": {
        "url": "https://github.com/kenjihikmatullah/productboard-mcp",
        "source": "github",
        "id": "939104710"
      },
      "version_detail": {
        "version": "0.0.2",
        "release_date": "2025-05-16T19:12:44Z",
        "is_latest": true
      }
    }

We get an error
Failed to publish server details: record already exists

Expected behavior
Update should suceed
Logs
If applicable, add logs to help explain your problem.

Additional context
Add any other context about the problem here.

[gss2002]

I had the same issue its caused by incorrect mongodb index on older version it was fixed by this PR: #199

Problem: Go struct uses version_detail.version (with underscore) but MongoDB index was created as versiondetail.version (without underscore), causing uniqueness checks and version comparison to fail.

Root Cause:

Go struct: VersionDetail field with bson:"version_detail" tag creates path version_detail.version
MongoDB index: Created as versiondetail.version
Mismatch prevented proper duplicate detection and version comparison

Solution Applied:
docker exec -it $(docker ps --filter "name=mongo" --format "{{.ID}}") mongosh
// use mcp-registry
use mcp-registry
// Dropped incorrect index
db.servers_v2.dropIndex("name_1_versiondetail.version_1")

// Created correct index matching Go struct
db.servers_v2.createIndex(
{"name": 1, "version_detail.version": 1},
{"unique": true}
)
// Verify Index is correct
db.servers_v2.getIndexes()

Status: Index now correctly shows name_1_version_detail.version_1 with underscore.

[twdsilva]

Fixed in #199