HOUSE LIST FIX -- step by step --

[Exiled Pain]

HOUSE ACCESS LIST FIX -- step by step --

Sup every one.

Have a very special request.
I’ve seen many places some post asking this, and yes I now it’s possible the failture is in my database or something like that. That`s why I would like to ask some of you more experienced users some detail advice on this or even a complete “tutorial” on how to fix this.

I’ve been struggling with this for quite some time, and people get frustrated on my server when this happens. Would really appreciate this and I now some other starting users like me (noobs) in this matter of the sql databases would be really thank full.

NOW THE PROBLEM

When ever anyone get’s into their house and use the:

• aleta sio
• aleta grav

using both as an example, I get this in my server screen.

[25/03/2008 18:10:05] > MySQL ERROR mysql_real_query: INSERT INTO `house_lists` (`house_id` , `listid` , `list`)
VALUES (243,256,'kakaroto the cruel\neternal oblibion\ngoku\nteto\ncenturion'),(243,14,'eternal oblibion') Duplicate
entry '243' for key 1
[25/03/2008 18:10:05] > MySQL ERROR mysql_real_query: INSERT INTO `house_lists` (`house_id` , `listid` , `list`)
VALUES (243,256,'kakaroto the cruel\neternal oblibion\ngoku\nteto\ncenturion'),(243,14,'eternal oblibion') Duplicate
entry '243' for key 1
[25/03/2008 18:10:05] > MySQL ERROR mysql_real_query: INSERT INTO `house_lists` (`house_id` , `listid` , `list`)
VALUES (243,256,'kakaroto the cruel\neternal oblibion\ngoku\nteto\ncenturion'),(243,14,'eternal oblibion') Duplicate
entry '243' for key 1


This keeps on coming out every few minutes in the server window. And when the server is reset, everything in the houses is saved, and ok, but all HOUSE LIST (the ones of the spells) are erased.
So the option here for the players has been to,

•Not invite any other players to their house,
•Invite them but leave the door open

Those kind of things…. In one word…. Just use one of the HOUSE spells to add someone to the list.
This gets more “sucky” in guild houses.

So before anything else:•Yes I use the different DOOR ID each different door in the house or guild house
•Yes I’ve used and tried different doors and get the same result, same with doors with looks on them or regular doors.

WHAT AM I USING

Server: TFS 2.10
ACC : AF-AAC v. 2.2 (AVARIANS)
PhpMyadmin: Version 2.11.3 (used in xampplite)

THE REQUEST

So could someone pull out some of their knowledge and help me out. I’ve tried its not that I’m lazy, its just that I’m starting out with this. Not so into the databases stuff yet.
I also know this may not be the best example but hope I can express my point. So the deeper the feedback gets the more you would help me.
Ones more, thanks.

P.S. Bare with me and my English, I give it my best shot.

 

[Exiled Pain]

Anyone?? Please, need some help solving this.

 

[Exiled Pain]

So......
No one up for this??

Too bad, really would it helped....

 

[Master-m]

Sorry I can't help you =(

 

[Exiled Pain]

Sorry I can't help you =(

Yeah!! Np man, but thanks anyway for taking your time to read the post and see if you could help. Apreciated anyway.
^_^

Anyone else?? Please

 

[Master-m]

i look at this thread for the 3rth time but nobody can help? =(

 

[Decent60]

Change the affected door's number again. Instead of 1 change it like 2 or 3 (whatever is available for that house/guild hall). Or does it do it for all the doors? Are you setting a Door ID or a unique ID?

 

[Exiled Pain]

I'm using door IDs, and yes it does the same no matter what number I set in the door, and yes it’s a different number for each door in the house/guild. Always starting from number 1 on the main door of each house. (Just as a note, is it possible to put a different number other than 1 on each main door?, this could probably fix the problem by numbering different each manin door with a different number but I don't know if its possible)

You think I could fix it if I set a different uniqueID for each door?? and what number should I start from??

Anyone else anyother ideas??