Fatal Error with Favorite Author

eFiction doesn't create a test account by default.  We'd still need the password.

Hmm... but that error.  Check the indexes for the fanfiction_favorites table?

Incidentally, that's line 50 of user/favau.php.

Hi,

Thanks for replying.

I went through the fanfiction_favorites table again but I really couldn't find a duplicate. There aren't many entries and I've searched the table by uid and by item twice...

When you say "Incidentally, that's line 50 of user/favau.php"... I went to the file and saw the code but I'm not sure if you meant I should do something to it and if so what.

After this post I tried uploading the user/favau.php file again but that didn't work out. Any ideas on what I should do next?

About the account, I was under that impression since I didn't created myself and it has the eFiction email addie associated to it. I guess at some point one of the mods created it. I'd rather not change the password and send it, so if you really need it, I'd appreciate if you could retrieve it through the email account.

Thanks.

I was just telling you the line so you knew where to look.  Not sure what you should do.

The error's pointing to the 'on duplicate key' part.  Here's a better explanation than I could give: If you specify ON DUPLICATE KEY UPDATE, and a row is inserted that would cause a duplicate value in a UNIQUE index or PRIMARY KEY, an UPDATE of the old row is performed. (From here.)

So what I suggested is to verify that your indexes are correct.  For fanfiction_favorites they should be the following:
  UNIQUE KEY `byitem` (`item`,`type`,`uid`),
  UNIQUE KEY `byuid` (`uid`,`type`,`item`)

It might also have something to do with your version of MySQL.

OH, and, we can't use the lost password feature.  At least I can't, since I have no idea who made the account and I don't have access to whatever email address they use, so there's no way for me to retrieve the password.

Sorry for the double-posting, just wanted to make it clear this was a new topic.

I found some references that say that ON DUPLICATE KEY UPDATE was added in MySQL 4.1.0.  You've got an earlier version.  The best solution all around would be to see if your host will upgrade to a newer version, but barring that, try replacing line 50 of user/favau.php with.

$result = dbquery("REPLACE INTO ".TABLEPREFIX."fanfiction_favorites(uid, item, type, comments) VALUES ('".USERUID."', '$a', 'AU', '$comment')");

Not sure about dbquery vs mysql_query for your version, one of the reasons why you should prod your host to update.

Source

Hi,

I tried upgrading to PHP 5 but that didn't do the trick.

Replacing line 50 with the code you gave me, however, worked perfectly.

Thanks for your help. 🙂

Tal

Not sure about dbquery vs mysql_query for your version, one of the reasons why you should prod your host to update.

dbquery() is a custom version of mysql_query() (or mysqli_query()). I think its purpose be for debugging.

I had trouble with dbquery () when we were at a previous version of MySQL, but I think it was only in the RSS feed, so it might have been a special situation.  Replacing it was mysql_query() fixed it and I think I remember reading dbquery() had been added later?  *memory is sketchy*

Anyway, to the OP, glad I could help!  Just wanted to let you know that upgrading your PHP version wouldn't help, it's the MySQL version that's the problem.  You'd need 4.1.0 or higher, for this at least.  It's possible you might run into other issues so it might require a higher version.  I think the latest release is 5.1.

Gotcha! I talked to my providers about the MySQL upgrading but they want me to make a new plan and transfer everything so for now I'll avoid the complication and keep my fingers crossed. 😉

Thanks!