• 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!
  • 2026 staff recruitment is open! Check it out and consider applying!

Phpmyadmin Account Problem

Lpe95

https://soundcloud.com/saintdmusic/sail-remix
Joined
Mar 3, 2013
Messages
308
Reaction score
12
Location
Music preformer.
Hey i made new database in phpmyadmin, and before i deleted my old one i downloaded my accounts after that i made new database, After it i want to put my old accounts database in phpmyadmin and this is coming. I also have tried to make new database and import accounts first after the tables but it happend same thing



PHP:
Error
SQL query:

-- -- Dumpning av Data i tabell `accounts` -- INSERT INTO `accounts` (`id`, `name`, `password`, `premdays`, `lastday`, `email`, `key`, `blocked`, `warnings`, `group_id`, `page_access`, `page_lastday`, `email_new`, `email_new_time`, `rlname`, `location`, `created`, `email_code`, `next_email`, `premium_points`, `nickname`, `avatar`, `about_me`) VALUES (1, '1', '1', 65535, 1362320533, '', '', 0, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), (2, '124124', '162734fec0b1cb988c0206946c0002a2387ac53f', 0, 1362321094, '[email protected]', '', 0, 0, 1, 6, NULL, NULL, NULL, 'Daniel', 'Somewher in sweden', NULL, NULL, NULL, 170, 'River', NULL, 'I won''t tell anything about me cause its not your bussines !'), (3, '4737390', 'c32d9cb2f11d990b8991dfea154543c39850ea1a', 0, 1362320533, '[email protected]', '', 0, 0, 1, NULL, NULL, NULL, NULL, '', '', NULL, NULL, NULL, 0, 'Gtttt', NULL, NULL), (4, '211955', '916c014031a7cd176ad393353f73429e8037e6c9', 0, [...]

MySQL said: 

#1062 - Duplicate entry '1' for key 'PRIMARY'

- - - Updated - - -

BUMP
 
It simply means you already have this table. Select your database, Go to Operations in Phpmyadmin and choose Drop Table, then try again
 
It simply means you already have this table. Select your database, Go to Operations in Phpmyadmin and choose Drop Table, then try again

It dosen't work to drop it

You are about to DESTROY a complete table! Do you really want to execute "DROP TABLE accounts"?

And then i click OK.


Error in Processing Request :
#1217 - Cannot delete or update a parent row: a foreign key constraint fails

I even tryed this but doesn't work



BUMP
 
It means that you are trying to cancel a row from one table, that contains a value present in at least one row in another table, and the foreign key constraint is there to avoid this from happening.
Drop the ENTIRE database, not just accounts.
 
Last edited:
It means that you are trying to cancel a row from one table, that contains a value present in at least one row in another table, and the foreign key constraint is there to avoid this from happening.
I asked you to drop the ENTIRE table, not just accounts.

i have done it and it happend same thing
 
Back
Top