Bad value found in email_setting.user_id - Mozilla

This is a discussion on Bad value found in email_setting.user_id - Mozilla ; After an upgrade to 2.20.1 from 2.20 via CVS on Windows, I get these errors in a sanity check: Bad value 13 found in email_setting.user_id Bad value 22 found in email_setting.user_id Bad value 24 found in email_setting.user_id Bad value 25 ...

+ Reply to Thread
Results 1 to 5 of 5

Thread: Bad value found in email_setting.user_id

  1. Bad value found in email_setting.user_id

    After an upgrade to 2.20.1 from 2.20 via CVS on Windows, I get these
    errors in a sanity check:

    Bad value 13 found in email_setting.user_id
    Bad value 22 found in email_setting.user_id
    Bad value 24 found in email_setting.user_id
    Bad value 25 found in email_setting.user_id
    Bad value 26 found in email_setting.user_id

    Not sure if its related but I ran a checksetup after the upgrade and got
    this at the end of it:
    SQL fragment found in the 'fielddefs' table...
    Old field name: (TO_DAYS(NOW()) - TO_DAYS(bugs.delta_ts))
    Fixing the 'fielddefs' table...
    New field name: days_elapsed
    Repairing broken series... 34... 36... 38... 40... 42... 44... 46...
    48... 50...
    52... 54... 56... 58... 61... 63... 65... 67... 69... 71... 73...
    75... 77... 7
    9... 81... 83... done.

    Anyone have an idea of where I could look to fix this?

  2. Re: Bad value found in email_setting.user_id

    Irwin,

    2006/2/27, Irwin Fletcher :
    > After an upgrade to 2.20.1 from 2.20 via CVS on Windows, I get these
    > errors in a sanity check:
    >
    > Bad value 13 found in email_setting.user_id
    > Bad value 22 found in email_setting.user_id
    > Bad value 24 found in email_setting.user_id
    > Bad value 25 found in email_setting.user_id
    > Bad value 26 found in email_setting.user_id


    Using SQL, remove the stray email_setting table entries.

    > Not sure if its related but I ran a checksetup after the upgrade and got
    > this at the end of it:


    It's not related. What you're seeing is a report of Bugzilla repairing itself.

    Kind regards
    Marc

    --
    http://wurblzap.net/
    Bugzilla hosting and professional support

  3. Re: Bad value found in email_setting.user_id

    That fixed it - thanks.

    In case anyone's interested, after a bit of research it looks like this
    is a direct result of the fix from this bug:
    https://bugzilla.mozilla.org/show_bug.cgi?id=319943

    Also, I'm assuming (but not sure) that this is a result of deleting users.

    Marc Schumann wrote:
    > Irwin,
    >
    > 2006/2/27, Irwin Fletcher :
    >> After an upgrade to 2.20.1 from 2.20 via CVS on Windows, I get these
    >> errors in a sanity check:
    >>
    >> Bad value 13 found in email_setting.user_id
    >> Bad value 22 found in email_setting.user_id
    >> Bad value 24 found in email_setting.user_id
    >> Bad value 25 found in email_setting.user_id
    >> Bad value 26 found in email_setting.user_id

    >
    > Using SQL, remove the stray email_setting table entries.
    >
    >> Not sure if its related but I ran a checksetup after the upgrade and got
    >> this at the end of it:

    >
    > It's not related. What you're seeing is a report of Bugzilla repairing itself.
    >
    > Kind regards
    > Marc
    >
    > --
    > http://wurblzap.net/
    > Bugzilla hosting and professional support


  4. Re: Bad value found in email_setting.user_id

    Irwin,

    2006/2/27, Irwin Fletcher :
    > In case anyone's interested, after a bit of research it looks like this
    > is a direct result of the fix from this bug:
    > https://bugzilla.mozilla.org/show_bug.cgi?id=319943


    no. The fix of the bug you mention is making you aware of the
    inconsistency, it doesn't cause it.

    > Also, I'm assuming (but not sure) that this is a result of deleting users..


    Yes, this is true.

    Regards
    Marc

    --
    http://wurblzap.net/
    Bugzilla hosting and professional support

  5. Re: Bad value found in email_setting.user_id

    Yeah, that's what I meant. The fix made me aware of a problem (that I
    was not aware of before), it didn't cause it.

    Marc Schumann wrote:
    > Irwin,
    >
    > 2006/2/27, Irwin Fletcher :
    >> In case anyone's interested, after a bit of research it looks like this
    >> is a direct result of the fix from this bug:
    >> https://bugzilla.mozilla.org/show_bug.cgi?id=319943

    >
    > no. The fix of the bug you mention is making you aware of the
    > inconsistency, it doesn't cause it.
    >
    >> Also, I'm assuming (but not sure) that this is a result of deleting users.

    >
    > Yes, this is true.
    >
    > Regards
    > Marc
    >
    > --
    > http://wurblzap.net/
    > Bugzilla hosting and professional support


+ Reply to Thread