Solved Mysql error

Mera Mero · Jan 28, 2015

Hello ,i've got deathlist system and i've sql the query on my phpmyadmin and i found problem with it when i checked the deathlist
QUERY

Code:

CREATE TABLE death_list (
    id          INTEGER NOT NULL,
    player_id   INTEGER NOT NULL,
    date        INTEGER NOT NULL,
    level       INTEGER NOT NULL,
    killer_name INTEGER NOT NULL,
    PRIMARY KEY ( id )
);

and when i check the deathlist found this error

Code:

[28/01/2015 14:15:25] mysql_real_query(): INSERT INTO `death_list` (`player_id`, `date`, `level`, `killer_name`) VALUES ('5', '1422447325', '115', 'Morgaroth. '); - MYSQL ERROR: Duplicate entry '0' for key 'PRIMARY' (1062)

any ideas about it?

yoyo? anyone here?

may someone help me? !

Limos · Jan 28, 2015

That table is for SQlite, run this for MySQL.
Drop the old table first:

Code:

DROP TABLE `death_list`;

Then create it again:

Code:

CREATE TABLE `death_list` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `player_id` int(11) NOT NULL,
  `date` bigint(20) unsigned NOT NULL,
  `level` int(11) NOT NULL,
  `killer_name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB;

Mera Mero · Jan 28, 2015

Limos said:

That table is for SQlite, run this for MySQL.
Drop the old table first:

Code:

DROP TABLE `death_list`;

Then create it again:

Code:

CREATE TABLE `death_list` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `player_id` int(11) NOT NULL,
  `date` bigint(20) unsigned NOT NULL,
  `level` int(11) NOT NULL,
  `killer_name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB;

thx its working good now

but what is the difference between them? and how can i change mysql query if it is sqlite?
and i got another problem most time when i open my forgotten console run something happen with it and comes laggy after then not responding after then close automatic ? may i know the reason please?

Limos · Jan 28, 2015

Could be your pc can't handle running your server at that moment, maybe to many things running.
To change a SQLite query to a MySQL query you can use your mysql schema as example, look what is used for ids, normal numbers, big numbers, small numbers, text etc.

Mera Mero · Jan 28, 2015

Limos said:
Could be your pc can't handle running your server at that moment, maybe to many things running.
To change a SQLite query to a MySQL query you can use your mysql schema as example, look what is used for ids, normal numbers, big numbers, small numbers, text etc.

okey thanks honey

but my pc got 4GB Ram isn't it enough? and when i open my console my cpu ups to 80!! and sometime 100 lol

frenzy02 · Apr 3, 2025

[Error - mysql_real_query] Query: INSERT INTO player_deaths (player_id, time, level, killed_by, is_player) VALUES (1, 1743649284, 132, 'field item', 1)
Message: Field 'mostdamage_by' doesn't have a default value

Solved Mysql error

Mera Mero

Guess Who?

Limos

★

Mera Mero

Guess Who?

Limos

★

Mera Mero

Guess Who?

frenzy02

Member

Similar threads