Fatal MySQL error when registering.

Ok I just went into the database and the authorinfo table, and found thet both the 'Prmary' and 'Index' were attached to uid, so I just removed the 'Index' one but that doesn't seem to have fixed the error.

Ok I just turned off the show Profile setting adn that fixed the error issue, I'll check back to see if a fix for ths has been posted. Thanks 🙂

Hello

Website: www.slasheavenarts.com
eFiction version: 3.3

I found this thread in "solved" section, but it seems not to be solved.

https://efiction.org/forums/index.php?topic=5370.0

My problem is the same, I'll try to explain it properly:

1. I activated the gender option at profile, and add the fields "male" and "female"
2. I register a new user, and look at the fanfiction_authorinfo. The table  shows a 0 value  instead of the user ID.
3. I try to register a new user, and I get this error:

Query: INSERT INTO fanfiction_authorinfo(`uid`, `info`, `field`) VALUES('', 'No', '8');
Error: (1062) Duplicate entry '0-8' for key 1

The error is because the program is trying to register another "0" value, and of course it is duplicated.

So, the problem is the loss of the userID value while registering authorinfo.

I'd like to know if there is a solution. Thanks

Wow you're right! I just turned gender on today and after reading this I tried registering an account and got a Fatal MySQL error too. A lil different just because of the field value but caused by the same thing nonetheless.

Guess I better turn off gender for now then.  😐

Any idea how to fix this? Only happens when the gender field is enabled and it's quite bugging.

Ayesha, just download efiction anew and overwrite your user/editbio.php file with the one in the download. I just decided to try and do that since noone was offering a forthcoming explanation on this and not everone was having the problem. Anyways, uploading a fresh editbio.php fixed the issue.

^^ Thanks a lot

I will try to copy the editbio.php.

I'm wondering if anyone else encountered that glitch or if it's just me but whenever I go to update my profile, the gender field only shows up male and undisclosed and left the female out because it was the one I had previously selected. So basically, everytime I update something, I have to do that in 2 steps because the first step updates the info I wanted to add but changes my gender.... so I have to go into my profile a second time to switch the gender to female (since the gender field had updated to undisclosed, female is now given as an option).

Anyone else has that issue?

Usually when I got a "Duplicate entry '0-8' for key 1" type error it was because a profile field item was added more than once, or already existed. I used to have a lot upon first converting from eFiction 2.0 to 3.0 since the updater was relatively new then, but once I deleted the duplicates in the database, everything was fine.

I do not have the problem of updating gender in two steps.