Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

500: Interner Serverfehler

  • seppel
  • seppel's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
4 months 3 weeks ago - 4 months 3 weeks ago #252889 by seppel
500: Interner Serverfehler was created by seppel
Please help us help you and fill where relevant:
Your LimeSurvey version: 6.3.7
Own server or LimeSurvey hosting: Own
Survey theme/template: 
==================
Hello,

after i finished a survey i got this:
Code:
500: Interner Serverfehler CDbCommand konnte das SQL-Statement nicht ausführen: SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\xFA\xA6;\x93Wk...' for column 'error_message' at row 1

What's wrong?!?
Last edit: 4 months 3 weeks ago by seppel.

Please Log in to join the conversation.

  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
4 months 3 weeks ago #252891 by holch
Replied by holch on topic 500: Interner Serverfehler

Incorrect string value: '\xFA\xA6;\x93Wk...' for column 'error_message' at row 1


You have an incorrect string value... :-)

Whatever that means.

When you say you "finished a survey", does this mean you completed answering on of your surveys or you completed "programming" a survey?

Also, you have posted this in the installation and update section. So do you feel this has to do with a recent update? How is this connected?

I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.

Please Log in to join the conversation.

  • seppel
  • seppel's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
4 months 3 weeks ago #252897 by seppel
Replied by seppel on topic 500: Interner Serverfehler
I mean completing answering.

If this is a update Issue?
Unfortunately not. I have gone back on a trial basis, but there is no improvement in sight.

The wrong value also changes every time. In any case, I can no longer complete a survey.

Normally I would be asked whether the answers should be printed out. This does not appear, but this error message.

Please Log in to join the conversation.

  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
4 months 3 weeks ago #252907 by DenisChenu
Replied by DenisChenu on topic 500: Interner Serverfehler
Own hosting ?

Can you activate debug mode manual.limesurvey.org/Debug_mode ?
If you export and import this survey : do you have same issue with the new one ?

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.

Please Log in to join the conversation.

  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
4 months 3 weeks ago #252918 by holch
Replied by holch on topic 500: Interner Serverfehler

Normally I would be asked whether the answers should be printed out. This does not appear, but this error message.


This might be an interesting path to follow. So you ask them whether they want to print or not. How do you do that? Is there any custom script used?

Has there been any update/upgrade on the server itself (not Limesurvey)? Maybe some function that was there before and is now missing?

Also a good idea of what Denis suggested. Try to copy the survey and see what happens.

I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.

Please Log in to join the conversation.

  • seppel
  • seppel's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
4 months 3 weeks ago #253020 by seppel
Replied by seppel on topic 500: Interner Serverfehler
The error has been found.

But it's the most confusing and worst error message I've ever seen.
Please change this, it has cost me useless time just looking in the wrong place.

Cause: PHP-Mailer could not deliver emails. The TLS certificate of the mail server had changed.

I only got the idea because the following message was displayed in the debug:
Code:
CDbCommand konnte das SQL-Statement nicht ausführen: SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\xFA\xC4<\x18BN...' for column 'error_message' at row 1. The SQL statement executed was: INSERT INTO `lime_failed_emails` (`language`, `status`, `recipient`, `surveyid`, `responseid`, `email_type`, `error_message`, `created`, `updated`, `resend_vars`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, NOW(), :yp7, :yp8)

This made me realize that the server error only occurs if an email is to be sent at the end.

Horribly misleading. And I have already looked at PHP itself and the MySQL connection on the server...

Please Log in to join the conversation.

  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
4 months 3 weeks ago #253021 by DenisChenu
Replied by DenisChenu on topic 500: Interner Serverfehler
Can you report the issue please?

About the TLS certificate , if needed : gitlab.com/SondagesPro/coreAndTools/AllowSelfSignedSSLSmtp
You can report the issue too : i'm happy to move this plugin to core.

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.

Please Log in to join the conversation.

  • seppel
  • seppel's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
4 months 3 weeks ago - 4 months 3 weeks ago #253022 by seppel
Replied by seppel on topic 500: Interner Serverfehler
Sorry for this, but I don't have time to support a bug report.

If you want to report it, I'll leave you the two screenshots of the incident :)

 
 
Last edit: 4 months 3 weeks ago by seppel.

Please Log in to join the conversation.

  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
4 months 3 weeks ago #253023 by DenisChenu
Replied by DenisChenu on topic 500: Interner Serverfehler

Sorry for this, but I don't have time to support a bug report.
 
LOL !

OK, don't have time to fix issue then …

10 minutes to report VS 2 hours to fix …

If you want to report it, I'll leave you the two screenshots of the incident :)
 
You kidding ?
Right ?

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.

Please Log in to join the conversation.

  • seppel
  • seppel's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
4 months 3 weeks ago - 4 months 3 weeks ago #253027 by seppel
Replied by seppel on topic 500: Interner Serverfehler
You're asking if I can report it?

I say no, because I know what an effort it is to report a bug. 

But I'll also give you the opportunity to do it yourself if it's important.

And now I'm not allowed to say no without being held accountable?

Who's kidding who here...

Please close this topic 
Last edit: 4 months 3 weeks ago by seppel.

Please Log in to join the conversation.

  • Joffm
  • Joffm's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
4 months 3 weeks ago #253032 by Joffm
Replied by Joffm on topic 500: Interner Serverfehler

I say no, because I know what an effort it is to report a bug. 

You know? Really?
As far as I saw you never filed a LimeSurvey bug report so far.

But if it's too time-consuming for you to fill out this form with 6 mandatory questions...
 

You see, we do this work voluntarily in our free time.

And I do not see an issue here in 6.3.8.
 
 

Joffm

Volunteers are not paid.
Not because they are worthless, but because they are priceless

Please Log in to join the conversation.

  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
4 months 3 weeks ago - 4 months 3 weeks ago #253046 by holch
Replied by holch on topic 500: Interner Serverfehler

Sorry for this, but I don't have time to support a bug report.


This is quite a sad approach to supporting a open source project that you and your company seem to benefit from.

I don't see how filling the bug report form of Limesurvey can take you so long. It would probably have been quicker to report the bug than to write your post in the forum.

And it totally makes sense that the person that actually encounters the bug makes the bug report, not a third person based on what is written in the forum (e.g. if there are further questions from the developers).

I am not surprised when volunteer developers like Denis just say "no", because I know that it is a lot of work they put into this software.

You have the right to not report the report. But don't be surprised when the volunteers are not too happy about it.

We all have stuff to do in our life. I get it. But a bug report will take you maybe 5 minutes of your time. If you are a bit slow (or very, very detailed), maybe 10-15 Minutes. I don't think that is too much to give back to a software you can basically run for free. If everyone would have this attitude Limesurvey would be no where near its current state. So all Denis was asking you to take 5 minutes of your time to create a bug report. Surely fixing the bug will take Denis and other volunteer developers a lot more than 5-10 minutes.

As I said: No one can and will force you to create the bug report. This is totally up to you and it is voluntary. It is just sad to see this type of attitude in a volunteer run forum.

I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.

Last edit: 4 months 3 weeks ago by holch.

Please Log in to join the conversation.

Lime-years ahead

Online-surveys for every purse and purpose