HWBOT
  1. HWBOT
  2. HWBOT-982

Fix the results that lost attached screenshots after editting

    Details

    • Type: Improvement Improvement
    • Status: Closed Closed
    • Priority: Minor Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: hwbot v5.5.0
    • Labels:
      None

      Description

      I've attached a list with all the results that are affected by this. I'll try to parse the logs in such a way that we can manually update the image_id's again. 289 results though so this will be quite a pain to do.

      To find them in the database, use this query:
      SELECT date, result_id, a.name, nickname, r.user_id, r.image_id
      FROM result r JOIN application a USING (application_id)
      WHERE date > '2013-01-01' AND r.image_id = 0 AND data_file_required = 'Y'
      1. affected.html
        87 kB
        Dennis Devriendt
      2. imageIds.txt
        61 kB
        Dennis Devriendt

        Activity

        Hide
        Dennis Devriendt added a comment -
        I've attached a list of possible imageIds (very rough so there are a lot more IDs in this file).
        How to fix them:
        - check imageIds for a timestamp that is roughly equal to the timestamp in affected.html
        - check if the username matches
        - set image_id in the database to the corresponding number in ImageIds.txt

        I'll get started on this but 289 results is a lot..
        Show
        Dennis Devriendt added a comment - I've attached a list of possible imageIds (very rough so there are a lot more IDs in this file). How to fix them: - check imageIds for a timestamp that is roughly equal to the timestamp in affected.html - check if the username matches - set image_id in the database to the corresponding number in ImageIds.txt I'll get started on this but 289 results is a lot..
        Hide
        Dennis Devriendt added a comment -
        Example:
        samt.bsb -> 891213
        M1K41L -> 891266
        Dancop -> 891287
        etc.
        Show
        Dennis Devriendt added a comment - Example: samt.bsb -> 891213 M1K41L -> 891266 Dancop -> 891287 etc.

          People

          • Assignee:
            Dennis Devriendt
            Reporter:
            Dennis Devriendt
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: