Title before edit: I hate programming, why did i choose this field

TL;DR: Stupid mistake, made by hours waste.

Basically, I was extracting date from the SQL db, and it was not displaying. I tried everything, heck I even went to chatgpt, and copilot. Two and half hours of trying every single thing under the sun, you know what was the issue?

SELECT task, status, id FROM mainWorkSpace WHERE user_id = @user_id

I FUCKING FORGOT TO ADD ‘date’ TO THE DAMN QUERY. TWO AND HALF HOURS. I was like, “Ain’t no way.” as I scrolled up to the query and there it was, a slap in the face, and you know what was the fix?

SELECT task, status, date, id FROM mainWorkSpace WHERE user_id = @user_id

Moral of the story, don’t become a programmer, become a professional cat herder instead.

  • slazer2au@lemmy.world
    link
    fedilink
    English
    arrow-up
    9
    ·
    5 months ago

    Get yourself a debug rubber ducky mate, talk to it when you are troubleshooting might fire off a coupe more pathways to identify the problem sooner.

        • barsquid@lemmy.world
          link
          fedilink
          arrow-up
          3
          ·
          5 months ago

          Tech support duck looks like he’s checking out some delicious bread crumb photography on that palmtop.

    • pantyhosewimp@lemmynsfw.com
      link
      fedilink
      arrow-up
      2
      ·
      5 months ago

      Long before the duck gained popularity – and I still can’t talk to a toy – I walk around and explain things to a phantom off in the corner of my mind, and I use bold hand gestures.

      • Solemarc@lemmy.world
        link
        fedilink
        arrow-up
        1
        ·
        5 months ago

        Bruh, I do this all the time! Can’t solve a problem? Get up and walk around the house while I explain the issue to imaginary people!

    • Elias Griffin@lemmy.world
      link
      fedilink
      English
      arrow-up
      1
      ·
      5 months ago

      So this is the second mention of a rubber duck. I’m trying to fiercely convince myself that talking to a toy on your desk was absolutely not a real thing for adults and that this is some satire I’m missing.

      If it’s true, that’s beyond shameful for an adult. I would quit if I were next to that person’s office/cubicle so that they didn’t infect me.

      In fact, if this was a real thing, don’t even tell me. I don’t want to live with that kinda shame for my species.

      • slazer2au@lemmy.world
        link
        fedilink
        English
        arrow-up
        2
        ·
        5 months ago

        I feel as though you are missing a key part. Some people are verbal debuggers, we speak what we wrote to understand it better. Now in an office environment what is more acceptable, talking to yourself or talking to a toy on the desk?

        https://en.m.wikipedia.org/wiki/Rubber_duck_debugging

        I have done this where you read the problem in your internal monologue but nothing new sparks, yet when you speak what is going on it activates different parts of your brain for the debugging process.