Nespresso questionnaire crashing

Forums › Off topic › Nespresso questionnaire crashing

meesham

912 posts

Ultimate Geek
+1 received by user: 222

Subscriber

Topic # 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

696 posts

Ultimate Geek
+1 received by user: 223

Trusted

Subscriber

Reply # 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
60034 posts

Uber Geek
+1 received by user: 11121

Administrator

Trusted

Geekzone

Lifetime subscriber

Reply # 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.

Geekzone broadband switch | Amazon (Geekzone aff) | MightyApe (Geekzone aff) | Backblaze cloud backup (personal and business) | My technology disclosure

You can support content creators (and Geekzone) by using the Brave browser.

Try Wrike: fast, easy, and efficient project collaboration software

meesham

912 posts

Ultimate Geek
+1 received by user: 222

Subscriber

Reply # 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

13794 posts

Uber Geek
+1 received by user: 1717

Reply # 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
60034 posts

Uber Geek
+1 received by user: 11121

Administrator

Trusted

Geekzone

Lifetime subscriber

Reply # 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).

Geekzone broadband switch | Amazon (Geekzone aff) | MightyApe (Geekzone aff) | Backblaze cloud backup (personal and business) | My technology disclosure

You can support content creators (and Geekzone) by using the Brave browser.

meesham

912 posts

Ultimate Geek
+1 received by user: 222

Subscriber

Reply # 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

499 posts

Ultimate Geek
+1 received by user: 106

Trusted

Subscriber

Reply # 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.

mattwnz

13794 posts

Uber Geek
+1 received by user: 1717

Reply # 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
60034 posts

Uber Geek
+1 received by user: 11121

Administrator

Trusted

Geekzone

Lifetime subscriber

Reply # 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.

Geekzone broadband switch | Amazon (Geekzone aff) | MightyApe (Geekzone aff) | Backblaze cloud backup (personal and business) | My technology disclosure

You can support content creators (and Geekzone) by using the Brave browser.

meesham

912 posts

Ultimate Geek
+1 received by user: 222

Subscriber

Reply # 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).