Page 1 of 1

error after data pack update.

Posted: Mon Oct 30, 2006 4:59 pm
by jcbrello
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.

Posted: Mon Oct 30, 2006 6:17 pm
by msknight
Check your character table to see if the column "nobless" has been added. If not, then that is your problem.

Posted: Mon Oct 30, 2006 6:41 pm
by jcbrello
That was it, Thanks.

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

Thanks again.

Posted: Wed Nov 22, 2006 4:19 pm
by KnockOut
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..

:(

Posted: Wed Nov 22, 2006 4:28 pm
by Fulminus
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.

Posted: Wed Nov 22, 2006 4:33 pm
by KnockOut
Ok, but what is the Command for adding the "Nobless" table ???

Please..

Posted: Wed Nov 22, 2006 4:37 pm
by Enforcer
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.