Notifications
Clear all

(SOLVED) New install. Error: (1062) Duplicate entry '1' for key 1

4 Posts
3 Users
0 Reactions
2,145 Views
(@anarchicq)
Posts: 115
Estimable Member
Topic starter
 

I searched for "Error: (1062) Duplicate entry '1' for key 1" but all the problems concerned uploading fic or new users. I can't even finish setting up a fresh archive.

I was on step 7 of installing when I got this error:

A fatal MySQL error was encountered.
Query: INSERT INTO `repofic_fanfiction_messages` VALUES (1, 'welcome', '', 'This is your welcome message. It appears on the index page. Include it in your .tpl files with {welcome}.');
Error: (1062) Duplicate entry '1' for key 1

Everything I had been installing I had been doing automatically. I haven't even gotten to the point where I can make an admin account yet, so I'm stuck in maintenance.

url: http://repo.deleted-scenes.com

EDIT: I managed to get out of maintenance mode, but I'm still screwed.


Silent Hill & Repo!
eFiction:3.5.1
Latest Patche(s):Yes
bridged?:No
modified?:Yes.
PHP:2.11.9.4
MySQL:5.0.32

 
Posted : 09/01/2010 7:47 pm
(@lyndsie)
Posts: 1263
Member Moderator
 

Looks like it's trying to add the same contents twice. Check in phpmyadmin it matches what install/install.php says it should. Add it manually if it doesn't and then skip to the next step. (You can do so by manipulating the url.)


 
Posted : 09/01/2010 7:54 pm
(@anarchicq)
Posts: 115
Estimable Member
Topic starter
 

I went to http://repo.deleted-scenes.com/install/install.php?step=7 and deleted the 'automatic' and then did everything manually and it worked!


Silent Hill & Repo!
eFiction:3.5.1
Latest Patche(s):Yes
bridged?:No
modified?:Yes.
PHP:2.11.9.4
MySQL:5.0.32

 
Posted : 09/01/2010 7:56 pm
(@tammy)
Posts: 2577
Member Moderator
 

That will happen if you try to do that step twice (maybe by reloading the page).  For future reference, you can just continue on to step 8 if that happens.


 
Posted : 09/01/2010 9:49 pm
Share: