Community AlphaAlpha MUADMINS
ENEnglish
Sign in
On MuADMINSContributeHelp out and earn Community PointsOpenOn MuADMINSEvent schedulesBlood Castle, Devil Square, invasions on one weekly gridOpen
← All solutions

DarksTeam 97d: accounts created on the web show NULL columns in the database and characters do not show up properly. How to fix it?

✓ Confirmed by the topic starter
  1. Back up the MuOnline database first.
  2. Open a new query on MuOnline in SQL Server Management Studio.
  3. Run: UPDATE Character SET CtlCode = 0 WHERE CtlCode IS NULL
  4. Restart the servers. Characters with an empty CtlCode now load as normal players.
  5. Make your web registration fill these columns with default values so new rows are not left NULL.

The topic starter confirmed that this worked.

Original words (Spanish)

“Solucione que aparescan todos los personajes del mu poniendo esta querry UPDATE CHARACTER SET CTLCODE=0 WHERE CTLCODE IS NULL”

The topic starter, 2018-10-15 (original words)
TuServerMU · 2018-10-15
Did this help?

Still stuck? Search MuGPS Ask the MU Assistant

MuADMINS Community Alpha: free and community made, in active development.