Welcome to the LimeSurvey Community Forum

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

Help! We have a problem with MySQL database

  • YolandaJolly
  • YolandaJolly's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
9 months 1 week ago #256000 by YolandaJolly
Replied by YolandaJolly on topic Help! We have a problem with MySQL database
Hi DenisChenu!

Finally, I created an index using MySQLWorkbench, on the only field in the lime_answer table that did not have an index: assessment_value

I still don't know if this has worked, because I just allowed users access and also the surveys that were causing problems are in the new installation with a clean database.
I'm waiting to see if everything goes well. I'll tell you.

Thank you so much.
The following user(s) said Thank You: DenisChenu

Please Log in to join the conversation.

  • YolandaJolly
  • YolandaJolly's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
8 months 1 week ago #258531 by YolandaJolly
Replied by YolandaJolly on topic Help! We have a problem with MySQL database
HI DenisChenu!

I just wanted to give a little feedback about my problem.

I don't know if it was due to indexing the database field, or because I moved the surveys that caused the problem to version 6 (with another database in which I also indexed the same field just in case), but the problem has not occurred again.

Thank you vey much!
The following user(s) said Thank You: DenisChenu

Please Log in to join the conversation.

  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team & Official Partner
  • LimeSurvey Community Team & Official Partner
More
8 months 1 week ago #258534 by DenisChenu
Replied by DenisChenu on topic Help! We have a problem with MySQL database
I need to report this as a DEV issue …

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member. - Professional support - Plugins, theme and development .
I don't answer to private message.

Please Log in to join the conversation.

  • YolandaJolly
  • YolandaJolly's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
8 months 1 week ago #258538 by YolandaJolly
Replied by YolandaJolly on topic Help! We have a problem with MySQL database
OK
Is there anything I can do?

By the way, I'm going to report another possible bug about version 6.4.5+240205.

Thank you!

Please Log in to join the conversation.

Moderators: holchtpartner

Lime-years ahead

Online-surveys for every purse and purpose