Quick StartMost PopularNew StuffPeopleTagsAbout Us

Bugs that lurk in your code for a long, long, time

Rate this:
By JV (Contact - View My Woyano)
Published Tue 20 Mar 2007, 702 Views, 4 Comments

Them old old bugs

Wow.

I've been using ezSQL day in day out for over 4 years, and one functions that hasn't changed since ezSQL V1 is $db->get_col()

I've used the function many times, it makes it easy to create a 1 dimensional array directly from a query.

For the first time ever today I got a notice about an undefined variable in this function.

(I always set my php dev system to errors E_ALL so I get notices etc.)

Aparently in all the times I have used the function It has never returned an empty result set either in a dev environment or in production!

The undefined variable notice only happens when an empty result set is returned.

And now I'm wondering what other four year old bugs are lurking in my code...



This Item
Category: Blogs, JV
Tags: ezsql, php
Share it
Link to this item:
Bookmark this item: RSS Feed

People who liked this item

    4 Comments

  1.  
    teqqles ~ 14 months ago
    0 votes thumbs up thumbs down
    They sneak up on you when you least expect it, at least you've found and fixed it. Think I should get into the habit of setting my dev box to E_ALL (when I haven't used it as a donor for another ailing system) :)
    [ reply ]
    1.  
      Strolen ~ 14 months ago
      0 votes thumbs up thumbs down
      I went so far as to hard code E_ALL for my login on my production site just in case something crops up. OK, E_ALL^E_NOTICE anyway. Some things are just not meant to be fixed. :)
      [ reply ]
      1.  
        JV ~ 14 months ago
        0 votes thumbs up thumbs down
        We leave E_NOTICE on, they are trapped on our dev box and production environment.

        Basicly our goal is to have a 100% notice free codebase.

        The reason why it makes sense is because when you browse through notices that are logged in your production environmet it brings your attention to things that you might not have otherwise noticed.

        Well worth the pain :)
        [ reply ]
        1.  
          SGD ~ 13 months ago
          0 votes thumbs up thumbs down
          That brings back memories. I used ezSQL on a property price site I built and I fixed that bug - because I frequently got empty set answers. Can't remember how I did it now.

          I really liked the functionality and help it did everything I needed and coped well with mega traffic til I had the site recoded.
          [ reply ]
          1.  
            AdGuy
            22 votes thumbs up thumbs down
            This is my two cents...

               
            Hey you know AdGuy always gets the last word! ;)

          Please Login to Add Your Comment   ..or..  

          Replying to comment by