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
    26·
    17 days 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
      4·
      17 days 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.devEnglish
      4·
      17 days 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
        1·
        17 days ago

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

        Now, that’s just evil. 😨

    • leftzero@lemmynsfw.com
      1·
      17 days 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…