Nespresso questionnaire crashing

Forums › Off topic › Nespresso questionnaire crashing

meesham

973 posts

Ultimate Geek

#150277 17-Jul-2014 10:29

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.

jamesrt

1611 posts

Uber Geek

ID Verified

Trusted

Lifetime subscriber

#1090513 17-Jul-2014 10:32

Worked fine for me yesterday; I'll be enjoying my free capsules within a couple of weeks (allegedly!)

freitasm

BDFL - Memuneh
79279 posts

Uber Geek

Administrator

ID Verified

Trusted

Geekzone

Lifetime subscriber

#1090552 17-Jul-2014 11:18

I had this happen to me, and sent a tweet to Nespresso:

Hey @nespresso throwing DB errors to client browsers is security risk, bad configuration. And I guess no free coffee? pic.twitter.com/LnbJyPQFc9

— Mauricio Freitas (@freitasm) July 15, 2014

I don't expect much now and won't fill the survey again... I guess no free coffee for me.

meesham

973 posts

Ultimate Geek

#1090696 17-Jul-2014 13:53

I just received a response:

Thank you for contacting the Nespresso Club in regards to our questionnaire.

I am sorry to hear of your trouble completing the questionnaire meesham.

We are currently having some slight technical problems with the questionnaire, which will be resolved in the coming 48 hours.

If you would like, we can call you to complete the survey over the phone.

Please reply to this email if you would like us to contact you meesham.

Alternatively, please try completing the survey again in the coming 2 days.

I am delighted to have answered your query about our questionnaire meesham. Have a lovely day.

mattwnz

20157 posts

Uber Geek

#1090703 17-Jul-2014 13:56

meesham: I just received a response:

Thank you for contacting the Nespresso Club in regards to our questionnaire. I am sorry to hear of your trouble completing the questionnaire meesham. We are currently having some slight technical problems with the questionnaire, which will be resolved in the coming 48 hours. If you would like, we can call you to complete the survey over the phone. Please reply to this email if you would like us to contact you meesham. Alternatively, please try completing the survey again in the coming 2 days. I am delighted to have answered your query about our questionnaire meesham. Have a lovely day.

That is nice of them, they want to inconvenience you further, and this time over the phone which will no dount take a lot longer to answer the survey questions. Why don't they just ask for your address to send the free product to as you have already done it once.

freitasm

BDFL - Memuneh
79279 posts

Uber Geek

Administrator

ID Verified

Trusted

Geekzone

Lifetime subscriber

#1090708 17-Jul-2014 14:00

Yep, I reported this before (probably the first one) and not even an offer of free coffee (they were going to send the free coffee at the end of the survey anyway).

meesham

973 posts

Ultimate Geek

#1090710 17-Jul-2014 14:01

mattwnz:
That is nice of them, they want to inconvenience you further, and this time over the phone which will no dount take a lot longer to answer the survey questions. Why don't they just ask for your address to send the free product to as you have already done it once.

Exactly, I sent them back the following:

No I don't want you to call me, all of my answers to the questionnaire are in the error message I sent you. Will you be sending me the capsules as promised for filling in the questionnaire?

Batwing

673 posts

Ultimate Geek

Trusted

Subscriber

#1090712 17-Jul-2014 14:01

meesham: I just received a response:

Thank you for contacting the Nespresso Club in regards to our questionnaire. I am sorry to hear of your trouble completing the questionnaire meesham. We are currently having some slight technical problems with the questionnaire, which will be resolved in the coming 48 hours. If you would like, we can call you to complete the survey over the phone. Please reply to this email if you would like us to contact you meesham. Alternatively, please try completing the survey again in the coming 2 days. I am delighted to have answered your query about our questionnaire meesham. Have a lovely day.

Did anyone else have to sign up over the phone when first purchasing a machine because the online form did not work? According to the voice on the other end of the phone it had been down for over a week at that time. Had to have my card registered twice too, it was "partially registered" somehow. Took over two weeks for my initial purchase to show in the Android app.

All in all it seems technical issues are endemic, but I'm happy with the way they handle things when they do go wrong.

Wise

Send money globally for less with Wise - one free transfer up to NZ$900 (affiliate link).

mattwnz

20157 posts

Uber Geek

#1090714 17-Jul-2014 14:05

meesham:
mattwnz:
That is nice of them, they want to inconvenience you further, and this time over the phone which will no dount take a lot longer to answer the survey questions. Why don't they just ask for your address to send the free product to as you have already done it once.

Exactly, I sent them back the following:

No I don't want you to call me, all of my answers to the questionnaire are in the error message I sent you. Will you be sending me the capsules as promised for filling in the questionnaire?

Is it being managed in NZ. Or is it some overseas contact centre? Posting a quick complaint on their facebook page maybe an idea.

freitasm

BDFL - Memuneh
79279 posts

Uber Geek

Administrator

ID Verified

Trusted

Geekzone

Lifetime subscriber

#1090715 17-Jul-2014 14:06

They already know about the issue - via email (above) and via Twitter. The issue is being solved.

In the meantime they should contact whoever reported this and extend the offer. I won't bother filling the survey again however the free coffee was for a completed questionnaire.

meesham

973 posts

Ultimate Geek

#1090756 17-Jul-2014 14:34

All sorted...

Thank you for your reply.

We will process for you this manually once the error has been resolved.

Once this has been input, we do allow 4 weeks for these complimentary Grands Crus to be received.

I am delighted to have assisted with you questionnaire meesham. Have a lovely afternoon.

freitasm - it looks like they're more responsive with the "contact us" page on their website rather than social media (which is pretty silly of them).