SQLyog Error 1062 - WoW MANGOS Server Problem

[CherryCoke]

Alright, the problem is when after I am on SQLyog, and I select my REALMD database, and input the code to create a new account for the server, I execute the query and I get a message that says

" Error Code : 1062
Duplicate Entry '1' for key 1
(0 ms taken) "


If there is already a thread about this then please direct me to it.
Thank you.

[MentaL]

[blu3link]

Use navicat instead of SQLyog. Worked for me:)

[Tobin]

I have the MaNGOS 2729b Revision. I have my DBC files created with WinMPQ. I have my Map files created with Ad.exe and placed in the correct folders. I have the "SDB Full version 0.5.3 revision 303" Batched into the correct DBs and edited Realmlist and Accounts. I followed the Tutorial on Mangos-Files.de

I deleted the four already created accounts after realmd303.sql is batched and created my account the way it says in the website above.

SELECT realmd;
INSERT INTO `account` VALUES (1,'desired login name','desired password',GM level,'','0','0','','2006-04-25 10:18:56',0,'127.0.0.1',0,0,'0000-00-00 00:00:00',0);

This worked for my account. I can play on my server perfectly from my computer. My problem is when I create an account for my friend this way; it is added onto the account list and everything. When I try to log into it on my server from my computer I get stuck on the Connected screen or keep getting sent back to the Realmlist screen. The same problem happens when my friend tries to get on the server from his computer.
I have gotten him to change his Realmlist to my IP as I have set up in SQLyog. So I know that isn't the issue. The server runs fine for just my account but I cannot create any others. I have also tried to create accounts through mangosd.exe but I get the same problem.
If there is any solution to this issue or another thread on it please let me know, I would be much appreciated.

-Tobin

[CherryCoke]

I am Tobin's friend. :)