I won't name the site because I don't want crackers looking into this, but here's a fascinating error message I received when trying to create an account.
alter table users_new add column 39b6c79e6a45fa57dfefca048bb1d0ce' in 'where clause' varchar(255) null Unknown column '39b6c79e6a45fa57dfefca048bb1d0ce' in 'where clause'
Obviously, I did not write this software :)
That’s worthy of a DailyWTF submission.
Re:DailyWTF
Ovid on 2009-02-23T08:50:25
Can I be snarky and mention that the extension on the page was
.php? :) I'm still trying to figure out exactly what the heck they were thinking.
Re:DailyWTF
Aristotle on 2009-02-23T09:14:50
You sure can.
:-P And yeah, one column per user? WTH?
Re:DailyWTF
Ovid on 2009-02-23T11:02:38
I was thinking that too, but it can't be it. This particular web site has a moderate amount of traffic and for them to use it, they have to be authenticated. So a table with that many columns is just going to fall over. I'm guessing (hoping) this is some database migration SQL which somehow is trying to get applied per user.
I hope Little Bobby Tables never signs up for that site, for their sake
Re:Little Bobby Tables
Ovid on 2009-02-24T11:51:05
Heh
:) XKCD for the win. (I tried thinking of a more subtle reply, but couldn't. Sigh)
