Page 1 of 2
Forum loading error (twice now) [1062]
Posted: 02 May 2019, 22:39
by Alexandrea
Subject: Error messages when sending private messages [c]
Alexandrea wrote: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.
Re: Forum loading error after using mailbox
Posted: 04 May 2019, 17:20
by Mooncalf
First time I've ever seen this error. Has it happened again since?
Re: Forum loading error after using mailbox
Posted: 04 May 2019, 17:25
by Alexandrea
nope
Re: Forum loading error after using mailbox
Posted: 05 May 2019, 12:47
by 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
Re: Forum loading error (twice now) [1062]
Posted: 14 May 2019, 07:19
by 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)
Re: Forum loading error (twice now) [1062]
Posted: 15 May 2019, 19:55
by Azraeth
Did that happen in tandem with any other error or around the same time?
Re: Forum loading error (twice now) [1062]
Posted: 15 May 2019, 19:57
by Alexandrea
nope, not at all.
Re: Forum loading error (twice now) [1062]
Posted: 17 Jun 2019, 03:53
by 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
Re: Forum loading error (twice now) [1062]
Posted: 16 Aug 2019, 18:31
by 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?
)
Re: Forum loading error (twice now) [1062]
Posted: 17 Aug 2019, 14:39
by 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.