Forum loading error (twice now) [1062]

[Alexandrea]

Subject: Error messages when sending private messages [c]

just had this happen to me again, just once tho. Next try it worked just fine.

BUT. (and I'll make a sep. report for this) The next link I clicked (view unread posts) gave me this:

"General Error
SQL ERROR [ mysql4 ]

Duplicate entry 'f40404f558d0d509226290f134f805fd' for key 'PRIMARY' [1062]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.
Please notify the board administrator or webmaster: david@mooncalfstudios.com

Powered by phpBB® Forum Software © phpBB Group"

instead of the forum page.

[Mooncalf]

First time I've ever seen this error. Has it happened again since?

[Alexandrea]

nope

[Azraeth]

Well that's weird. That error should only pop up when a duplicate value violates the primary key constraint (primary values have to be unique).

I'm not sure what would have caused it. It normally happens when values are manually added to a table.

If it's not persisted, it shouldn't be a problem. But if it does persist, there are some ways to fix it.

My guess is this bug is somehow related to the first if it's not persisting. I'm not sure exactly what that value is for though. I wish it said in the error message

[Alexandrea]

General Error
SQL ERROR [ mysql4 ]

Duplicate entry 'f40404f558d0d509226290f134f805fd' for key 'PRIMARY' [1062]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.
Please notify the board administrator or webmaster: david@mooncalfstudios.com

Powered by phpBB® Forum Software © phpBB Group

this time I had exited the message area so I don't think it's related... although I suppose it still could be.

And it happened when I clicked on the view your own posts link this time
(http://www.mooncalfstudios.com/pathofth ... =egosearch)

[Azraeth]

Did that happen in tandem with any other error or around the same time?

[Alexandrea]

nope, not at all.

[Alexandrea]

This happened today again, 1062.

I was in the outbox of the private messages at the time and the link I clicked was the 'view your posts' on the purple goth skin

[Alexandrea]

General Error
SQL ERROR [ mysql4 ]

Duplicate entry '5ef0a3e1f0722036bc051d6cea3fa352' for key 'PRIMARY' [1062]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.
Please notify the board administrator or webmaster: david@mooncalfstudios.com

Powered by phpBB® Forum Software © phpBB Group


I was in a private forum and clicked the 'view your posts' link. No other error (that I know of) had occurred on the forum or grid today. (yet? )

[Mooncalf]

I've run a repair function on the forum database. I'm hoping that fixes it, but if not I'll take a deeper look.