Internal server error when i import a survey

More
4 years 6 months ago #92820 by paulinevieillard
paulinevieillard created the topic: Internal server error when i import a survey
I have previously exported a survey structure and now I want import it from the "New Survey" screen.
My survey contains various question groups.

The new survey does not generate and the error message appears :

Internal Server Error
The value for the column "gid" is not supplied when querying the table "groups".

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

Thank you.

How can I do to import the survey with all groups ?
Thanks

Please Log in to join the conversation.

More
4 years 6 months ago #92821 by helper
helper replied the topic: Internal server error when i import a survey
Would you attach your survey and let us know what version of LimeSurvey you use? Thanks!
The following user(s) said Thank You: paulinevieillard

Please Log in to join the conversation.

More
4 years 6 months ago #92827 by paulinevieillard
paulinevieillard replied the topic: Internal server error when i import a survey
you will find my survey in attachment .
I use the Version 2.00+ Limesurvey.

Thanks
Attachments:

Please Log in to join the conversation.

More
4 years 6 months ago #92848 by helper
helper replied the topic: Internal server error when i import a survey
I see the same issue - opened a bug: bugs.limesurvey.org/view.php?id=7316

Please Log in to join the conversation.

More
4 years 6 months ago - 4 years 6 months ago #92849 by helper
helper replied the topic: Internal server error when i import a survey
I just discovered that even though I received the error - after I signed off and back on to LimeSurvey the survey now appears and there are many errors (76 total) in the survey.
Last Edit: 4 years 6 months ago by helper.

Please Log in to join the conversation.

More
4 years 6 months ago #92850 by paulinevieillard
paulinevieillard replied the topic: Internal server error when i import a survey
Indeed I also have a new survey (even if the error message appears) in my list but it contains errors and I cannot use it.

Please Log in to join the conversation.

More
4 years 6 months ago #92860 by helper
helper replied the topic: Internal server error when i import a survey
These guys here are great for fixing bugs!

See bugs.limesurvey.org/view.php?id=7316

Please Log in to join the conversation.

More
4 years 6 months ago #92863 by paulinevieillard
paulinevieillard replied the topic: Internal server error when i import a survey
I still have the bug ...

Internal Server Error
The value for the column "gid" is not supplied when querying the table "groups".

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

Thank you.

Please Log in to join the conversation.

More
4 years 6 months ago #92872 by helper
helper replied the topic: Internal server error when i import a survey
The LimeSurvey crew have not merged the changes to the release version yet. To fill the gap I took the changes and applied them manually. Here is a step by step:

1. In your favorite editor (for example, notepad) open .../application/helpers/common_helper.php
2. Find "if (strcmp($description,$qentry) !=0 ||" (this should be at line 6270)
3. Replace the following:
        if (strcmp($description,$qentry['description']) !=0  ||
        strcmp($gpname,$qentry['group_name']) !=0)
        {
            // Update Fields
 
            $data = array(
            'description' => $description,
            'group_name' => $gpname
            );
 
            $where = array(
            'gid' => $gid,
            'language' => $language
            );
 
            Groups::model()->update($data,$where);
 
        } // Enf if modified
    } // end while qentry
with the following (this is the changed code from LimeSurvey):
        if (strcmp($description,$qentry['description']) !=0  || strcmp($gpname,$qentry['group_name']) !=0) {
            $where = array(
                'gid' => $gid,
                'language' => $language
                    );
            $oGroup = Groups::model()->findByAttributes($where);
            $oGroup->description= $description;
            $oGroup->group_name= $gpname;
            $oGroup->save();
 
        } // Enf if modified
     } // end while qentry

Once you have the code change, try your import again.

Please Log in to join the conversation.

More
4 years 6 months ago #92880 by paulinevieillard
paulinevieillard replied the topic: Internal server error when i import a survey
Thanks for these details but i work directly on the free LimeSurvey Professional (previously LimeService).com.
Thus i can not change this code.

Do you think it is possible to warn the persons of LimeSurvey Professional (previously LimeService) to change the code?

Please Log in to join the conversation.

More
4 years 6 months ago #92881 by helper
helper replied the topic: Internal server error when i import a survey
Wow... not sure what version they actually use there. Maybe Schmitz will catch the difference.

Please Log in to join the conversation.

More
4 years 6 months ago #92883 by c_schmitz
c_schmitz replied the topic: Internal server error when i import a survey

Best regards

Carsten Schmitz
LimeSurvey project leader

Please Log in to join the conversation.

More
4 years 6 months ago #92890 by paulinevieillard
paulinevieillard replied the topic: Internal server error when i import a survey
I submited this issue at LimeSurvey Professional (previously LimeService) support (Ticket Number : T000380)

Thanks

Please Log in to join the conversation.

More
4 years 6 months ago #92894 by holch
holch replied the topic: Internal server error when i import a survey
Pauline: Carsten (they guy who has solved the problem) is the same guy who is running LimeSurvey Professional (previously LimeService).

So if he fixed the problem, I am sure it will be included into LimeSurvey Professional (previously LimeService), once the next release is roled out.

I'm not a LimeSurvey GmbH member. I answer at the LimeSurvey forum in my spare time. No support via private message.
Some helpful links: Manual (EN) | Question Types | Workarounds

Please Log in to join the conversation.

More
4 years 6 months ago #92896 by paulinevieillard
paulinevieillard replied the topic: Internal server error when i import a survey
Ah ok.
Thanks, and do you know when will be the next release?

Please Log in to join the conversation.

Did you already participate in our customer survey?

Don't miss your chance for great prices.

Please click here to participate:

Start now

Start now!

Just create your account and start using Limesurvey today.

Register now