Check out the LimeSurvey source code on GitHub!

Internal server error when i import a survey

More
3 years 10 months ago #92820 by paulinevieillard
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
3 years 10 months ago #92821 by helper
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
3 years 10 months ago #92827 by paulinevieillard
you will find my survey in attachment .
I use the Version 2.00+ Limesurvey.

Thanks
Attachments:

Please Log in to join the conversation.

More
3 years 10 months ago #92848 by helper
I see the same issue - opened a bug: bugs.limesurvey.org/view.php?id=7316

Please Log in to join the conversation.

More
3 years 10 months ago - 3 years 10 months ago #92849 by helper
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: 3 years 10 months ago by helper.

Please Log in to join the conversation.

More
3 years 10 months ago #92850 by paulinevieillard
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
3 years 10 months ago #92860 by helper
These guys here are great for fixing bugs!

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

Please Log in to join the conversation.

More
3 years 10 months ago #92863 by paulinevieillard
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
3 years 10 months ago #92872 by helper
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
3 years 10 months ago #92880 by paulinevieillard
Thanks for these details but i work directly on the free limeService.com.
Thus i can not change this code.

Do you think it is possible to warn the persons of limeservice to change the code?

Please Log in to join the conversation.

More
3 years 10 months ago #92881 by helper
Wow... not sure what version they actually use there. Maybe Schmitz will catch the difference.

Please Log in to join the conversation.

More
3 years 10 months ago #92883 by c_schmitz
LimeService always runs the latest build. If you have problems please contact LimeService Support at www.limeservice.com .

Best regards

Carsten Schmitz
LimeSurvey project leader

Please Log in to join the conversation.

More
3 years 10 months ago #92890 by paulinevieillard
I submited this issue at limeService support (Ticket Number : T000380)

Thanks

Please Log in to join the conversation.

More
3 years 10 months ago #92894 by holch
Pauline: Carsten (they guy who has solved the problem) is the same guy who is running Limeservice.

So if he fixed the problem, I am sure it will be included into Limeservice, once the next release is roled out.

Have a look at the manual! It is a really valuable source for information. Here some helpful links:
Manual (EN) | Question Types | Workarounds

Please Log in to join the conversation.

More
3 years 10 months ago #92896 by paulinevieillard
Ah ok.
Thanks, and do you know when will be the next release?

Please Log in to join the conversation.

Imprint                   Privacy policy         General Terms & Conditions         Revocation information and revocation form