Welcome, Guest
Username: Password: Remember me

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

Data too long for column 'question' at row 1 3 years 7 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.

Re: Data too long for column 'question' at row 1 3 years 7 months ago #56784

  • DenisChenu
  • DenisChenu's Avatar
  • OFFLINE
  • Moderator Lime
  • Posts: 6362
  • Thank you received: 827
  • Karma: 245
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.

:)
The administrator has disabled public write access.

Re: Data too long for column 'question' at row 1 3 years 7 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.

Re: Data too long for column 'question' at row 1 3 years 7 months ago #56837

  • Mazi
  • Mazi's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 5325
  • Thank you received: 296
  • Karma: 249
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.115 seconds
Donation Image