Annoying Poll
Moderator: General Moderators
Annoying Poll
Well, you can probably guess I am doing some coding, and I am getting hit with a lot of annoying typo's. So I was curious, what is your most hated typo?
What about your worst bug ever? Or stupidest moment? We've all had them, that moment where you suddenly realized the very easy fix after having spent many hours (or days) trying to find the problem.
What about your worst bug ever? Or stupidest moment? We've all had them, that moment where you suddenly realized the very easy fix after having spent many hours (or days) trying to find the problem.
-
malcolmboston
- DevNet Resident
- Posts: 1826
- Joined: Tue Nov 18, 2003 1:09 pm
- Location: Middlesbrough, UK
Re: Annoying Poll
The day i came onto devnetwork asking for why my insert script was'nt working it was something likejason wrote:Or stupidest moment?
Code: Select all
$query = "INSERT INTO blah whatever";
$affected_rows = mysql_affected_rows($result);Re: Annoying Poll
No?malcolmboston wrote:you should'nt spend 16+ hours solid coding.
Damn!
heh, my stupidest error was in SQL query:
It was supposed to be:
It has updated entire someothertable (about 1.5M records...) instead of just 1. Thank God it was on development db server.....
Code: Select all
update sometable inner join someothertable set sometable.value1='something', someothertable.value2=999999 where sometable.id=$somethingCode: Select all
update sometable inner join someothertable
ON sometable.somefield1=someothertable.somefield2
set sometable.value1='something', someothertable.value2=999999 where sometable.id=$somethingHeh, the first time I used SQL I got my results back (after the n-th error) , was proud like Uncle George and then needed to sort them.
So I started writing a bubble-sort in PHP... and after about one hour thought: "Wait! These mySQL-people must have something similar..."
One of those days when you look into the mirror and think: "That guy there, yeah, you who's looking at me: you're stupid. S T U P I D!"
So I started writing a bubble-sort in PHP... and after about one hour thought: "Wait! These mySQL-people must have something similar..."
One of those days when you look into the mirror and think: "That guy there, yeah, you who's looking at me: you're stupid. S T U P I D!"
-
mexiconsin
- Forum Newbie
- Posts: 1
- Joined: Thu May 20, 2004 9:40 am
- Location: Royal Oak, Michigan
clobbered file
I work on three computers at home with Windoze/Samba networking and spent a whole day tweaking a database. I work from multiple monitors and never remember which box has the actual file. After several hours of myriad tweaks, I decided to "back up" my master copy and copied the file in the wrong direction.jason wrote:hawleyjr: And then you realize you have been overwriting the live server's copy, not the development...and that you don't have a backup...
You cannot recover a network-clobbered file! Fortunately, there is a happy ending. After two hours of panic, I finally found my file in a different directory. Since then, I've reorganized my directory structure and think long and hard before transferring files in Network Neighborhood.
- Bill H
- DevNet Resident
- Posts: 1136
- Joined: Sat Jun 01, 2002 10:16 am
- Location: San Diego CA
- Contact:
Or this one always cracks me up when I do it.And so on until I realize I was moving the wrong file to the server.
After repeated uploads and tests WS_FTP times out and disconnects. No, I don't fail to notice that and reconnect. I reconnect and fail to upload the modified file! Then I can't figure out why my change didn't work. Seems I somehow think that merely reconnecting is all I need to do!
-
spectre013
- Forum Newbie
- Posts: 5
- Joined: Wed Jul 09, 2003 9:09 am
- Location: Colorado, USA

