I read years ago in comp.risks about a similar story. A guy in 1979(!) requested a personalized plate "SAILING", with second choice "BOATING". He didn't want a customized plate if he couldn't get those, so for his third choice he put down "NO PLATE". Of course, he ended up with "NO PLATE". He ended up getting 2500 parking tickets, since cars with no plate had "NO PLATE" written on the ticket. References: http://www.m…
NULL license plate not such a bright idea
91–100 of 484 posts
Re: NULL license plate not such a bright idea
#92I have a family member who's license plate started with "&". The DMV accepts it, plates were ordered online fine, but police systems can't handle it apparently, to my family members ultimate discomfort. I commonly joke it probably gets the individual out of automated tickers for speeding and red lights, but when an officer pulls them over we sometimes need to explain that the "&" is dropped in the system (or so we've…
Any word on whether the plate without the preceding '&' is in circulation? I'd be curious if your records in the police systems would be merged with the records of the owner of that plate.
Re: NULL license plate not such a bright idea
#93Shout out to all the Python programmers from the other frontpage thread who are responsible for bugs like this with their crappy scripting languages.
Re: NULL license plate not such a bright idea
#94Earlier quoted context omitted.
On top of that, if anything, forcing the government to fix it's bad code ( insert snarky ambiguity between software code and legal code ) can't be a bad thing. I'd buy the guy a beer.
The problem is it's a "a privately operated citation processing center" that's causing the problem. They might even be instructed to hand-enter a NULL for these cases. I'm don't really see an incentive for the govt agency to do anything about it. It's no skin off their nose. They'll just keep sending the tickets.
Re: NULL license plate not such a bright idea
#95This isn't even a coding error, NULL is apparently valid license plate, and for some reason there is a private processing center typing it in to the government system. First of all they are accidentally committing fraud (libel?) against this guy. But more importantly, why is there a private processing center? Don't the officers type this in as they fill out the ticket? or even just scan the plates? If there aren't pl…
I assume the government entry system doesn't have an explicit way to set the data as missing, so they work around it like this.
Re: NULL license plate not such a bright idea
#96At least his story brings to light the poor quality of software the DMV is using.
I'm curious about the other, unintended consequences of naming things null in other web applications; maybe its time to explore ...
Re: NULL license plate not such a bright idea
#97Earlier quoted context omitted.
Nah, because it's not unsanitized SQL at fault, but people writing a literal NULL in the license plate field when there isn't one.
Actually, I think it's doubtful the folks at the private processing facility are actually writing 'NULL', but my guess is the DB field is just not set (i.e. left as NULL), and then when the info is read out somewhere it's just printed as the string literal value.
Re: NULL license plate not such a bright idea
#98Earlier quoted context omitted.
Relevant xkcd comic https://xkcd.com/1105/
In the Starcraft 2 community it is called barcoding. Basically, I 1 | l are all accepted characters for a name and I think some do look actually identical on most fonts used in the game. So yeah, one person doing that you call "barcode", 2 persons doing that, you already have deniability. Be more than 10, and that's a crowd.
Re: NULL license plate not such a bright idea
#99Earlier quoted context omitted.
Court isn't cheap. You're paying for it with a lawyer or with your own time
> Droogie contacted the DMV who told him to change his plate. He refused because he didn't do anything wrong. While they wiped the fines off his record, unfortunately for him, they didn't fix the problem in the system so once again, Droogie has accrued another $6,000 in tickets that he had nothing to do with. He says he won't be paying those either. Except he just contacted the DMV. No lawyers necessary.
Re: NULL license plate not such a bright idea
#100I own a rare collector car with a three-digit VIN. This has caused endless hassles at the DMV as well as the insurance office. Sometimes we find success by prepending the necessary number of zeros, before the VIN. Other instances in the same system require appending zeros after the VIN. The true VIN has a hyphen but that never makes it into the DMV's system. One time I got stuck in a particularly nasty loop where the…