looking for help with an Error.

jcbrello · Post by **jcbrello** » Wed Oct 04, 2006 1:55 am

heya all

I deleted a clan out of the clan data, now when the server starts it starts up and runs ok, but it says :

Error while restoring clan java.sql.SQLException: Unknown column 'power_grade' in 'field list'

any idea on how to remedy this?

the server runs fine otherwise.

but I cannot seem to get to the source of this error.

Thanks for your time

Post by **Hexa** » Wed Oct 04, 2006 3:55 am

what revision of L2J server are you using?

AliasRequired · Post by **AliasRequired** » Wed Oct 04, 2006 10:47 am

That error is unrelated to deleation. You are using new character table with old, custom, or modified l2server.jar.

Post by **Fulminus** » Wed Oct 04, 2006 2:13 pm

That error is unrelated to deleation. You are using new character table with old, custom, or modified l2server.jar.

Indeed the error is unrelated to deletion, but quite contrary to the previous post, the error is due to using a new, updated, or modified/custom l2jserver.jar with an old character table.
Basically, the java side has a query that contains a field which is missing from your database.

That being said, I do not recommend deletion a clan via the database. First of all, the server caches all clan info at boot time (almost

most is actually loaded when the first player logs in). So if you delete a clan from the database while the server is running, you'll run into various issues.
If you delete the clan while the server is offline, you need to also make sure to delete all info related to the clan:
change the clan_id and priviledges of all members of that clan to 0.
wipe all clan castle, clan hall, and clan war issues.
wipe any (possible) clan quests that are still ongoing...

jcbrello · Post by **jcbrello** » Wed Oct 04, 2006 5:55 pm

Thanks for the Help,

I understand what happened now so I wont make that mistake again

I'll Try fixing it with the server down ASAP.

When I did it I thought that having all the Clan members log out would be good enough.

This all started because The Clan Leader no longer plays and people wanted to continue using it, So I tried to switch Leader ID numbers but that started causing player unguilded problems Ect.

Thanks again for the Fast Replys