• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Omg! Dmn tfs!

richux

Tibera.org
Joined
Aug 18, 2008
Messages
3,666
Reaction score
26
Location
---------
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!
 
lol i get it too

Code:
[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)
 
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.
 
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.
 
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.
 
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.
 
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.
 
Back
Top