Community AlphaAlpha MUADMINS
ENEnglish
Sign in
On MuADMINSConfig ScannerDrop your files zip: rates, drops, spots, limitsOpenOn MuADMINSMeet us on DiscordAsk for help, share what you are building and talk MU with other server owners.Open
← All solutions

Characters do not save and the DataServer log shows State (42S22)

✓ Confirmed by the topic starter

SQL state 42S22 means a column was not found: the server files query a column your database does not have, so the save fails.

  1. Open the DataServer log and read which table and column the failing query uses (here the marriage columns of the Character table).
  2. Look for the .sql queries that came with the files and run the one that adds those columns.
  3. If that query fails, add the missing columns by hand in SQL Server Management Studio (table > Design) with the type the query expects.
  4. Restart DataServer and check that the log is clean, then test that a level change is saved.

The topic starter confirmed that this worked.

Original words (Spanish)

“Ahí las agregue manualmente y funciona bien, gracias!!”

The topic starter, 2021-03-24 (original words)
TUServerMU · 2021-03-24
Did this help?

Still stuck? Search MuGPS Ask the MU Assistant

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