URL to your eFiction: http://hc.potteritus.net/fanfiction
Version of eFiction: 2.0.7 (upgrading to 3.3)
Have you bridged eFiction, if so with what?: No
Version of PHP: 4.4.2
Version of MySQL: 4.1.22
Have you searched for your problem: yes
If so, what terms did you try: Query: INSERT INTO and Error: (1062)
State the nature of your problem:
A fatal MySQL error was encountered.
Query: INSERT INTO hcfanfiction_classtypes (`classtype_name`, `classtype_title`) VALUES('genres', 'Genres');
Error: (1062) Duplicate entry 'genres' for key 2
I actually found a thread about this. Apparently there's a duplicate in my database. Only I don't know how to fix it. I'm very new to Mysql and I don't know how to go about deleting the duplicates from the database. I played around with it, but I can't seem to figure it out. I would have just asked the question at the bottom of the thread, but it's an old thread and I think (can't remember) it was for 3.2. Can anyone help me? Thanks
Do you have a test account for us? No
If you have access to phpMyadmin you can delete it there. 🙂
archive:
site:
Available for skin/mod commission! 🙂
yes, but how?
In phpadmin there's classtype_id followed by 1 & 2, then classtype_name followed by genres & warnings, then classtype_title followed by Genres & Warnings. What gets deleted? Is it the table that gets deleted? . . . see my dilemma?
lol. okay. Well, I tried deleting one of the tables. that didn't work. It actually made everythjing worse. So I re-installed the backups and when I tried the upload again. I breezed through the upgrade with not one problem. Three's the charm, I guess. But thank you Jenny for trying to help me. I appreciate it 🙂
