Has anyone else received an offer of 6 free capsules for completing a questionnaire for Nespresso? I just tried to complete it and the application crashed, luckily the error contained all the information I required to debug it for them:

Error Number: 1406

Data too long for column 'address_state' at row 1

INSERT INTO `milkexpertise` (`clubnumber`, `q2`, `q3`, `q4`, `q5`, `q6`, `q7`, `q8`, `q9`, `q10`, `q11`, `q12`, `q13`, `q14`, `q15`, `q16`, `q17`, `q18`, `title`, `firstname`, `lastname`, `phone`, `email`, `address_type`, `address_unit_number`, `address_building_name`, `address_property_name`, `address_street_number`, `address_street_name`, `address_street_type`, `address_city`, `address_state`, `address_postcode`, `address_update`, `newsletter`, `country`, `giftpack`, `created`, `ip`) VALUES ('*redacted*', 'Long black with a dash of milk', 'Nespresso coffee', '8', 'Mildly toasted / roasted', 'With my partner', 'Occasionally / Sporadically', 'Breakfast,Afternoon', 'Dulsao do Brasil', 'Never', 'Yes', 'Neither agree/disagree', 'Neither agree/disagree', '2', '*redacted*', '25 - 39', 'Male', '', 'MR', '*redacted*', '*redacted*', '*redacted*', '*redacted*', 'HSE', '', '', '', '1', '*redacted*', 'ST', 'DUNEDIN', 'SOUTH ISLAND', '0000', 0, 0, 'nz', 'LB Mild', '2014-07-17 08:03:39', '127.0.0.1')

Filename: /var/www/coffee-and-milk/questionnaire/codeigniter/application/models/signup.php

Line Number: 20


It's crashing on "SOUTH ISLAND" which comes from a drop down list, so it looks like no one in NZ will be completing the survey. Someone forgot to actually test their code and turn off debug mode for production. It's also interesting that it's recording my IP address as 127.0.0.1, that'll be super useful to them. I sent them friendly email suggesting they fix it and maybe think about testing and security.