Omg! Dmn tfs!

[richux]

mysql_real_query(): INSERT INTO `server_motd` (`id`, `world_id`, `text`) VALUES (1, 0, 'Welcome to Selencia!'); - MYSQL ERROR: Duplicate entry '1-0' for key 'id' (1062)

This is what I get when someone logins in my ot. And the strange thing is that only one player can login in my ot. Others cant. CAn someone please explain me what does that error above mean? I need help deadly fast!

 

[Grehy]

Change your MOTD to something else, it worked for me

 

[Rala Knighta]

lol i get it too

[26/05/2009 18:16:37] mysql_real_query(): INSERT INTO `server_motd` (`id`, `world_id`, `text`) VALUES (1, 0, 'Welcome Choose your character!'); - MYSQL ERROR: Duplicate entry '1-0' for key 'id' (1062)

 

[ExibeR]

mysql_real_query(): INSERT INTO `server_motd` (`id`, `world_id`, `text`) VALUES (1, 0, 'Welcome to Selencia!'); - MYSQL ERROR: Duplicate entry '1-0' for key 'id' (1062)

This is what I get when someone logins in my ot. And the strange thing is that only one player can login in my ot. Others cant. CAn someone please explain me what does that error above mean? I need help deadly fast!

Clearly states that you already have an account ID 1.
You will have to either remove it, or make so your AAC picks a new ID each time a player create an account.

 

[kehato]

i dont understand..how to fix it?

 

[Magictibiaman]

Okay two things i would reccomend.
go to Oftans -> distributions -> download a forgotten server

also go into configuration files and check your Sqlite or MySql setting in the section called SqlType.

 

[ExibeR]

Okay two things i would reccomend.
go to Oftans -> distributions -> download a forgotten server

also go into configuration files and check your Sqlite or MySql setting in the section called SqlType.

Fail...

You need to reset your Database and fix yourself a new AAC. The current AAC you use duplicated the unique ID's.

 

[richux]

Okay two things i would reccomend.
go to Oftans -> distributions -> download a forgotten server

also go into configuration files and check your Sqlite or MySql setting in the section called SqlType.

uber fail.


@exiber
Is there other way how to do it, I can't afford to reset database lol? And please, if you explain something, do it so noobs could understand it. I didnt understand you first post, and no, that error does not clearly say anything for me.

 

[ExibeR]

uber fail.


@exiber
Is there other way how to do it, I can't afford to reset database lol? And please, if you explain something, do it so noobs could understand it. I didnt understand you first post, and no, that error does not clearly say anything for me.

Go inside your database.
Press on the server_motd table.
Click browse, and delete all entries.
Restart the server.