Check out the LimeSurvey source code on GitHub!
Welcome, Guest
Username: Password:

TOPIC: Data too long for column 'question' at row 1

Data too long for column 'question' at row 1 5 years 5 months ago #56780

  • Oak
  • Oak's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 2
  • Karma: 0
I was just adding questions on a survey and after several questions got an error message after submitting one that said "Data too long for column 'question' at row 1". What is this and why am I getting it? I was adding a simple yes/no question, but even trying a couple different question types I still get the same error. Is there a maximum number of questions that can be asked or something?

Thanks,

Oak
The administrator has disabled public write access.

Data too long for column 'question' at row 1 5 years 5 months ago #56784

  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • Moderator Lime
  • Posts: 9293
  • Thank you received: 1327
  • Karma: 384
Hello,

it's the data , not the number of column.

question are in TEXT, and it's limited only by the server memory. Did you copy/paste something ?

Can you try with : $debug=1; in your config.php.

:)
Assistance on LimeSurvey forum and LimeSurvey core developpement are on my free time (Say thanks ?).
A bug not reported is a bug not corrected. | Please, read the documentation | La doc en français à besoin de vous
The administrator has disabled public write access.

Data too long for column 'question' at row 1 5 years 5 months ago #56809

  • Oak
  • Oak's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 2
  • Karma: 0
Argggg yes. :) Just found tons of MS Word code on the source screen. Thank you.
The administrator has disabled public write access.

Data too long for column 'question' at row 1 5 years 5 months ago #56837

  • Mazi
  • Mazi's Avatar
  • Offline
  • LimeSurvey Team
  • Posts: 5974
  • Thank you received: 366
  • Karma: 260
Please do never copy paste texts directly from MS Word, because at the background loads of style information is copied which you won't notice but might also break the survey design.

Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)limesurvey.org'"
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.541 seconds
Imprint                   Data Protection Statement                  Revocation information and revocation form