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.

  • Potatos_are_not_friends@lemmy.world
    link
    fedilink
    arrow-up
    24
    ·
    5 months ago

    The difference between experienced devs and non experienced devs is that we have hundreds of stories like that under our belt. Hundreds of “Ah I wasted all this time because of a typo”, and now we know to check for it.

    It never stops. And after a while, a dev will share this exact scenario and you’ll look back and share the same bit to them.

    • MrOzwaldMan@lemmy.mlOP
      link
      fedilink
      arrow-up
      4
      ·
      5 months ago

      Thanks for sharing your experience, who knew a frustrating post written by me would give me lessons which i am going to take to heart.

    • vrek@programming.dev
      link
      fedilink
      English
      arrow-up
      4
      ·
      5 months ago

      I had that experience last week. I half blame the language though cause the way it works is you don’t initialize a variable, first time you use it the language automatically makes the variable and default value is 0.

      I had a variable countoot that I had a formula calculate. Then a simple if countoot > 0 do this else do that. The program kept doing that. I knew countoot should be 2. I manually did the formula … The answer was two.

      I did the same formula in 3 other programs and it worked correctly. I spent between 1.5 to 2 hours a day for like 3 days banging my head on the desk trying to figure out why it would work. Fourth day me and 2 other guys were trying to figure it out when I finally really looked closely. I realized the formula result was stored in ccountoot(notice 2 c) and the if statement was based on countoot(notice 1 c)…yeah I felt so stupid when correcting the typo fixed the problem.

      • leftzero@lemmynsfw.com
        link
        fedilink
        arrow-up
        1
        ·
        5 months ago

        first time you use it the language automatically makes the variable and default value

        Now, that’s just evil. 😨

    • leftzero@lemmynsfw.com
      link
      fedilink
      arrow-up
      1
      ·
      5 months ago

      The difference between experienced devs and non experienced devs is that when seeing “the experience that made me hate programming” and “date” in the same post experienced devs just stop reading (mostly due to the PTSD hit) and assume it must have been some date format issue or shudder timezone shenanigans between the database and the programming language…