Admin Tools
Maintenance and diagnostic tools for platform administrators(v2026.01.12)
NFT Metadata Check
Scan all NFTs for malformed metadata that may trigger wallet warnings
Database Backup
Export current database contents (data only, no structure)
Weekly Backup Recommended
- • Exports all table data as SQL INSERT statements
- • Does not include table structure or schema
- • Safe to run while platform is active
- • File size depends on current data volume
Restore Instructions:
- Keep the backup file in a safe location
- To restore, use database management UI or CLI
- Run:
mysql -u user -p database < backup.sql
Transaction Backfill
Recover missing transaction records for NFT tokens that were minted but not recorded in the transactions table
Loading stats...
How it works:
- • Finds NFT tokens without corresponding transaction records
- • Creates synthetic transaction records using artwork price data
- • Uses current timestamp (original mint time not available)
- • Safe to run multiple times - won't create duplicates
Sales Volume Recalculation
Recalculate user sales volumes and tiers from actual transaction data (fixes backfilled transactions that didn't update volumes)
Loading stats...
How it works:
- • Calculates actual sales volume from transactions table
- • Calculates actual spending from transactions table
- • Updates totalSalesVolumeScbk and totalSpentScbk fields
- • Recalculates artist tier based on combined contribution
- • Tier thresholds: New (0-99K), Active (100K-999K), Pro (1M+)
Data Integrity
Monitor and repair artwork-NFT synchronization issues
Checking data integrity...
How it works:
- • Detects NFT tokens without matching artwork records
- • Fetches metadata from Solana blockchain via Helius API
- • Recreates artwork records from on-chain data
- • Links restored artworks to their creators and owners
About Malformed NFTs
What are malformed NFTs? These are NFTs where the metadata JSON is missing required fields like files, links.image, description, or category.
Why does it matter? Phantom wallet and other services perform security checks on NFT metadata. Missing fields trigger warnings that prevent listing on secondary markets.
What to do? Most malformed NFTs were created during the testing phase. You can:
- Advise creators that these NFTs cannot be listed
- Hide affected artworks from marketplace (admin can hide any artwork)
- Future mints use the correct format and won't have this issue