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')
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.