How to get back the corrupt survey ?

More
4 months 2 days ago #156043 by himel2019
himel2019 created the topic: How to get back the corrupt survey ?
I made a survey and it was working fine, but suddenly i saw when i visit my survey it giving me a error message :

Internal Server Error

Question is corrupt: no type defined for question 478

An internal error occurred while the Web server was processing your request. Please contact the webmaster to report this problem.

any one help me pls..

Please Log in to join the conversation.

More
4 months 2 days ago #156045 by olle
olle replied the topic: How to get back the corrupt survey ?
Do you have access to the database? Maybe you can inspect the question rows in database table <prefix>_questions?

Please Log in to join the conversation.

More
4 months 2 days ago #156046 by himel2019
himel2019 replied the topic: How to get back the corrupt survey ?
i have access database..

Please Log in to join the conversation.

More
4 months 2 days ago #156049 by olle
olle replied the topic: How to get back the corrupt survey ?
MySQL? If yes, run this:

SELECT type FROM <prefix>_questions WHERE sid = <survey id>

Replace <prefix> with your database prefix (e.g. "lime"), and <survey id> with survey id.

If any result shows type as empty or null, you need to change it.

Please Log in to join the conversation.

More
4 months 2 days ago #156050 by olle
olle replied the topic: How to get back the corrupt survey ?
Or maybe better: Just visit question 478, and save it again (would overwrite previous type value).

Please Log in to join the conversation.

More
4 months 2 days ago #156051 by himel2019
himel2019 replied the topic: How to get back the corrupt survey ?
Thanks for your reply , in mysql my database name is : survey and the survey id is : 626596 ,

Please Log in to join the conversation.

More
4 months 2 days ago #156052 by himel2019
himel2019 replied the topic: How to get back the corrupt survey ?

Please Log in to join the conversation.

More
4 months 2 days ago #156053 by olle
olle replied the topic: How to get back the corrupt survey ?
Prefix is not the same as database name. If you run "show tables;", all tables should begin with a prefix. Standard is "lime_".

Please Log in to join the conversation.

More
4 months 2 days ago #156054 by himel2019
himel2019 replied the topic: How to get back the corrupt survey ?
I didn't find the table where it located ? question 478,

Please Log in to join the conversation.

More
4 months 2 days ago #156055 by olle
olle replied the topic: How to get back the corrupt survey ?
Sorry, I can't see the error since I don't have access to your installation. :) You can save the error as an HTML file and attach it, if you want to.

Please Log in to join the conversation.

More
4 months 2 days ago #156056 by olle
olle replied the topic: How to get back the corrupt survey ?
Run this database command to find your question:

SELECT * FROM <prefix>_questions WHERE qid = 478;

Please Log in to join the conversation.

More
4 months 2 days ago #156057 by himel2019
himel2019 replied the topic: How to get back the corrupt survey ?

Please Log in to join the conversation.

More
3 months 4 weeks ago #156182 by Mazi
Mazi replied the topic: How to get back the corrupt survey ?
Similar to re-starting MS Windows it often helps to copy such buggy questions or copy the whole survey. That sometimes fixes such problems automatically.


Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)survey-consulting.com'"

Please Log in to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now