Matthew1980 - 9:17 pm on Mar 3, 2013 (gmt 0)
@Camilord: in the WHERE clause, you've got that as 'id', and it's down as a bigint, and I can't help but notice, so I thought I'd point it out: you're doing the update and turning it into a string - with the help of those single quotes.
Addressing updates using strings & asking for int's isn't really good practice, just knock the single quotes off, and the sql engine will treat that as the (big)int as it's intended to be.
Sorry to be a bore :)
But yes, like @coopster, I'm guessing that number 4 wasn't there. We've all done that before ;)