Community AlphaAlpha MUADMINS
FILFilipino
Mag-sign in
Sa MuADMINSConfig ScannerI-upload ang zip ng mga file mo: rate, drop, spot, limitBuksanSa MuADMINSMakipagkita sa amin sa DiscordHumingi ng tulong, ibahagi ang ginagawa mo at makipag-usap tungkol sa MU sa ibang may-ari ng server.Buksan
← Lahat ng solusyon

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

✓ Kinumpirma ng nagsimula ng topic

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.

Kinumpirma ng topic starter na gumana ito.

Orihinal na salita (Espanyol)

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

Ang nagsimula ng topic, 2021-03-24 (orihinal na salita)
TUServerMU · 2021-03-24
Nakatulong ba ito?

Naipit pa rin? Maghanap sa MuGPS Magtanong sa MU Assistant

MuADMINS Community Alpha: libre, gawa ng komunidad, at patuloy na dine-develop.