error after data pack update.

jcbrello · Post by **jcbrello** » Mon Oct 30, 2006 4:59 pm

Im looking for a little direction please,

I Just updated my server with the Data pack, with 10-29-06

now when I start the server it all loads perfect , but when anyone tries to log in the server shouts

"Could not restore Char data: Java.sql.SQLException: Unknown column 'nobless' in field list"

"could not restore in slot:0" (or sometimes slot:4 ect.)

"Character could not be loaded (slot:0)"

any Idea what can be causeing this?
this is the first time I had this happen

Thanks guys.

Post by **msknight** » Mon Oct 30, 2006 6:17 pm

Check your character table to see if the column "nobless" has been added. If not, then that is your problem.

jcbrello · Post by **jcbrello** » Mon Oct 30, 2006 6:41 pm

That was it, Thanks.

Although I really dont know why it didnt make it in the first place.

Thanks again.

KnockOut · Post by **KnockOut** » Wed Nov 22, 2006 4:19 pm

Yo i have also that problem.. but how make a table and than is the table empty is that good or what?

please help i cant fix it, i dont know what i must to do..

:(

Post by **Fulminus** » Wed Nov 22, 2006 4:28 pm

The updater won't update tables it can't wipe and redo (such as the character table). You have to run the queries in "\sql\updates\" for that.

KnockOut: If you mean that your characters table has no entries (rows) but has the correct structure, you probably wiped it...If you have a backup, you can restore it and then add the columns.
If you don't have a backup, I pity the players.

KnockOut · Post by **KnockOut** » Wed Nov 22, 2006 4:33 pm

Ok, but what is the Command for adding the "Nobless" table ???

Please..

Post by **Enforcer** » Wed Nov 22, 2006 4:37 pm

You have to run the queries in "\sql\updates\" for that.

What isn't clear here?
If you don't know how to use a MySQL query take some time and learn.
This forum is for problems related to datapack, not MySQL learning class.