• 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!

Need help with a code

Rab

Member
Joined
Feb 23, 2009
Messages
468
Reaction score
9
Location
ARGENTINA!
Code:
Error

consulta SQL:

INSERT INTO `accounts`
VALUES ( 1, '1', '1', 65535, 1273810370, '', '0', 0, 0, 1 ) ;

MySQL ha dicho: Documentación
#1062 - Duplicate entry '1' for key 'PRIMARY'
[ Volver ]
La conexión para controluser, como está definida en su configuración, fracasó.

I get this error when i try to import my homemade mysql schema into xampp... I've followed the steps to change from sqlite to mysql, been hours doing it and got this... What can i do? I can't post the code because its too long, i don't know if i am allowed to upload it here with a download link....
 
If it helps, i'll write an example of how i've made every quote.

CREATE TABLE `server_motd`
(
`id` INT UNSIGNED NOT NULL,
`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
`text` TEXT NOT NULL,
UNIQUE (`id`, `world_id`)
) ENGINE = InnoDB;

INSERT INTO `server_motd` VALUES (1, 0, 'Welcome to The Forgotten Server!');
INSERT INTO `server_motd` VALUES(1,0,'Welcome to The Forgotten Server!');
INSERT INTO `server_motd` VALUES(2,0,'Gamerzot 8.54!');
INSERT INTO `server_motd` VALUES(3,0,'Phoenix Ot 8.55!');
INSERT INTO `server_motd` VALUES(4,0,'Phoenix Ot 8.55!
*
-God Phoenix-');
INSERT INTO `server_motd` VALUES(5,0,'Phoenix Ot 8.55!
*');
 
Back
Top