MySQL Error

[president vankk]

Help :thumbup:

 

[Rexxar]

Seems to me like it's trying to insert items into a house that does not exist in the database.

Did you manually edit houses in the DB recently?

 

[president vankk]

no,no

 

[Rexxar]

Well, the server is trying to save an item inside a house; World ID 0 and House ID 15. But this house does not exist in the "Houses" table, and thus it fails to save the item, and throws this error.

 

[president vankk]

how to fix this error

 

[Rexxar]

Compare the houses XML with the houses table in your database, and make sure the house that the server is trying to save items in, is actually present in the database/XML file respectively. If not, add it manually.

 

[president vankk]

not understand
:S

 

[Rexxar]

Check data/world/<mapname>-house.xml and compare to "houses" table in the database. Make sure the house with ID 15 exists.

 

[president vankk]

  <house name="Silver Street 13" houseid="15" entryx="370" entryy="400" entryz="7" rent="0" townid="1" size="18"/>

@EDIT

Hail Post 1,000 ~
GRATZ

 

[Rexxar]

  <house name="Silver Street 13" houseid="15" entryx="370" entryy="400" entryz="7" rent="0" townid="1" size="18"/>

And is this house also present in the database table "houses"?

 

[president vankk]

yes

 

[president vankk]

Bump?