Forum Discussion

WiderMouthOpen's avatar
WiderMouthOpen
Esteemed Contributor
3 years ago

Where did all my posts go?

So I went to go sign in today and it gave me either 1 of 2 errors(see below). I dumped my cookies and tried a different browser and PC and still the same. Waited about 20mins and now I can login norm...
WiderMouthOpen's avatar
WiderMouthOpen
Esteemed Contributor

Yea, I thought a Supervisor/Manager I met on Reddit was going to post or DM me some info but they have gone missing. Sorry for the false alarm.

WiderMouthOpen's avatar
WiderMouthOpen
Esteemed Contributor
2 years ago

FYI: I sent another email asking for a update. Nothing so far.

  • TiffanyR's avatar
    TiffanyR
    Former Moderator
    2 years ago
    Hello WiderMouthOpen,

    Thank you so much for your patience. I understand that this has been going on for a while and that can be frustrating. Our leadership team is still working with our Forum Provider to find a resolution. We will let you know as soon as we have an update.

    Tiffany R.
    Cox Support Forum Moderator
    • CurtB's avatar
      CurtB
      Valued Contributor III
      2 years ago

      @TiffanyR, For this discussion, assume a forum database with a "User" table of forum users and a "Reply" table of questions and discussions.  Also, assume a unique User.UserID field and a Reply.CreatedBy field set to User.UserID of the forum user who created the Reply record.

      ... User Join Reply on User.UserID = Reply.CreatedBy...

      Two months ago, WiderMouthOpen experienced an error while logging in, that I suspect corrupted his User record.  That could have caused a new User record to be created with a different User.UserID value than the Reply.CreatedBy value of Reply records he created before the error (pre-error); breaking the join between them.  The display query doesn't include Reply records without a matching User.UserID.  In normal operation, Reply records are probably deleted during the delete User process.  But Reply records orphaned by an unexpected event might still exist.

      Determine if his pre-error Reply records are still in the database.  

       <previous User.UserID> could be obtained from a pre-error User table backup.

      SELECT * FROM Reply WHERE Reply.CreatedBy = <previous User.UserID>;

      If records are found, that would confirm my theory.  The fix would be:

      UPDATE Reply
      SET Reply.CreatedBy = <current User.UserID> 
      WHERE Reply.CreatedBy = <previous User.UserID>;

      That should re-establish the join between his User and pre-error Reply records.

      Two months without a fix is not good.  Your provider's IT department needs to wash their hands so they don't get boogers on the keyboard.

      • TiffanyR's avatar
        TiffanyR
        Former Moderator
        2 years ago
        Hello CurtB,

        I do appreciate your insight. I am not sure that this would be the problem as we have identified some further issues. I have also had a couple of my responses disappear as well. I understand that this is extremely frustrating, especially with the amount of time this has been going on for. I can assure you, we are still working on the issue.

        Tiffany R.
        Cox Support Forum Moderator