Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Database help L2J 

Status
Not open for further replies.
Newbie Spellweaver
Joined
Nov 16, 2006
Messages
33
Reaction score
0
I am currently running

L2J Server Version: 478
L2J Datapack Version: 2548

I am receiving the following error after updating:

NPCTable: Error reading NPC drop data: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'category' in 'field list'

I have deleted the npc table and the npcskills table and imported them both from the sql folder and this seems to not have fixed the issue.

Anybody have any ideas

Thank you
 
Newbie Spellweaver
Joined
Nov 28, 2006
Messages
12
Reaction score
0
[Answer]Drom Arthakas

HI.Greetings.
==================================================
You have to a new columm in your droplist table.
If you want do it manully, i will explain you.
1.Open your mysql programm
2.Then go to the droplist table and do right click on it.
3.Select design table and add this:
Name:Category
Type: Int
Lenght: 11
Deciamals: 0
AllowNull: do not select it
Add a key into the last columm.
If you want do it more easy:
1.Download this
2.Do a backup of your droplist table.
3.Delete it.
4.Right click in your database and select Execute batch file.
5.Select the download file.
6.Restart you database.
===================================================
jasonkuehl - Database help - RaGEZONE Forums
 
Last edited:
Upvote 0
Status
Not open for further replies.
Back
Top