Jump to content
  • 0

[HELP] Error in cached and l2server


Question

Posted

Hello friends.

I have a new problem .. I have no items to create a character .. any items or weapons with which to start.,. And when I try to talk to a NPC, or kill a mob, I pulled the server, and I get an error in the l2server .. leave some screens of all errors that appear in the cached and l2server.

thank you very much.

greetings,

 

error3u.png

 

Uploaded with ImageShack.us

3 answers to this question

Recommended Posts

  • 0
Posted

Looks to me like a messed up stored procedure lin_CreateItem.

 

Were you editing storedprocedures lately?

Are you SURE sql queries you used to create database were ok (too old perhaps? it could result in compatibility problems).

 

Scenario to get an error like this would be:

- cached executes lin_CreateItem and sends values 1 2 3 4 5 to mssql.

- Stored procedure on mssql only has 4 variables, 1 2 3 4. Value 5 is excessive.

 

Edit: As I suspected. Your database is incompatible. You're missing updates.

http://www.maxcheaters.com/forum/index.php?topic=164583.0

Same problem as yours.

  • 0
Posted

Looks to me like a messed up stored procedure lin_CreateItem.

 

Were you editing storedprocedures lately?

Are you SURE sql queries you used to create database were ok (too old perhaps? it could result in compatibility problems).

 

Scenario to get an error like this would be:

- cached executes lin_CreateItem and sends values 1 2 3 4 5 to mssql.

- Stored procedure on mssql only has 4 variables, 1 2 3 4. Value 5 is excessive.

 

Edit: As I suspected. Your database is incompatible. You're missing updates.

http://www.maxcheaters.com/forum/index.php?topic=164583.0

Same problem as yours.

 

when I get home, I look if it works well.,.

thank you very much,

 

  • 0
Posted

when I get home, I look if it works well.,.

thank you very much,

 

Right, just run the sql that i have posted on the other threaad linked by embass,

its the official dvamp update sql,if you get more errors on the database just let me know

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

This community uses essential cookies to function properly. Non-essential cookies and third-party services are used only with your consent. Read our Privacy Policy and We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue..