[guide] Database Limit 65535 fix

[darren]

[glow=purple,20,700]Having problem adding that mob to your Database? do you get the error that the npc id has to be 65535 and under? well here is how you fix this.[/glow]

 

[glow=red,2,300]This doesn't have to be edit in core just your tables..[/glow]

 

[glow=maroon,2,300]Step 1:[/glow] [glow=teal,2,300]Open your Navicat.[/glow]

 

[glow=maroon,2,300]Step 2:[/glow] [glow=teal,2,300]Go to the table you have 65535 limit on.[/glow]

 

[glow=maroon,2,300]Step 3:[/glow] [glow=teal,2,300]Right click on the table and go to Design.[/glow]

 

[glow=maroon,2,300]Step 4:[/glow] [glow=teal,2,300]A box will pop up, there you will see rows and colums. Look for the Idtemplate row, once you see this, look under the Type colum.[/glow]

 

[glow=maroon,2,300]Step5:[/glow] [glow=teal,2,300]Change what ever it is to mediumint.[/glow]

 

[glow=maroon,2,300]Step 6:[/glow] [glow=teal,2,300]Save and exit the table.[/glow]

 

[glow=maroon,2,300]Step 7:[/glow] [glow=teal,2,300]Restart your Gameserver.[/glow]

 

[glow=red,2,300]This has been tested on Custom_Npc table only, But I'm sure it will work on any other Table, just has not been tested on any other. also remeber that this will work with other types, exp: npc id.

anyhow good luck and enjoy![/glow]

[Hardstyle]

this fix is shared on mxc allready ...i say'd it 2 time i think...you should mention this is a fix for the bug when you get the error "blablabla out of range  at colum id" or something similar 2 that on your gs... i had this on my spawnlist table ...

and thx:)

[Francisko]

If u set it to "mediumint" u will have the same proble shortly, better put BIGINT :D

[Simmo]

It is 65535 for a reason, because it is the highest number that can act as an unsigned 16-bit binary number.

 

God knows what errors will approach in the future if you change this value, it is the same reason why Microsoft Excel has 65535 cells (2006 and below (Last time i used excel :P) )

[darren]

It is 65535 for a reason, because it is the highest number that can act as an unsigned 16-bit binary number.

 

God knows what errors will approach in the future if you change this value, it is the same reason why Microsoft Excel has 65535 cells (2006 and below (Last time i used excel :P) )

 

 

if you have any exp with navicat, and l2 server, than you would know you have have higher numbers for npc and mobs.

[Simmo]

The database was obviously designed to use 16-bit integers for npc IDs, so that must mean that the core was more than likely designed around this too right?

 

You can change whatever you want in the database but if you didn't change the core too then it won't work in any other table.