Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1
  • 2

TOPIC: Internal server error when i import a survey

Internal server error when i import a survey 1 year 9 months ago #92820

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
The administrator has disabled public write access.

Internal server error when i import a survey 1 year 9 months ago #92821

  • helper
  • helper's Avatar
  • OFFLINE
  • Expert Lime
  • Posts: 126
  • Thank you received: 18
  • Karma: 0
Would you attach your survey and let us know what version of LimeSurvey you use? Thanks!
The administrator has disabled public write access.
The following user(s) said Thank You: paulinevieillard

Internal server error when i import a survey 1 year 9 months ago #92827

you will find my survey in attachment .
I use the Version 2.00+ Limesurvey.

Thanks
Attachments:
The administrator has disabled public write access.

Internal server error when i import a survey 1 year 9 months ago #92848

  • helper
  • helper's Avatar
  • OFFLINE
  • Expert Lime
  • Posts: 126
  • Thank you received: 18
  • Karma: 0
I see the same issue - opened a bug: bugs.limesurvey.org/view.php?id=7316
The administrator has disabled public write access.

Internal server error when i import a survey 1 year 9 months ago #92849

  • helper
  • helper's Avatar
  • OFFLINE
  • Expert Lime
  • Posts: 126
  • Thank you received: 18
  • Karma: 0
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: 1 year 9 months ago by helper.
The administrator has disabled public write access.

Internal server error when i import a survey 1 year 9 months ago #92850

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.
The administrator has disabled public write access.

Internal server error when i import a survey 1 year 9 months ago #92860

  • helper
  • helper's Avatar
  • OFFLINE
  • Expert Lime
  • Posts: 126
  • Thank you received: 18
  • Karma: 0
These guys here are great for fixing bugs!

See bugs.limesurvey.org/view.php?id=7316
The administrator has disabled public write access.

Internal server error when i import a survey 1 year 9 months ago #92863

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.
The administrator has disabled public write access.

Internal server error when i import a survey 1 year 9 months ago #92872

  • helper
  • helper's Avatar
  • OFFLINE
  • Expert Lime
  • Posts: 126
  • Thank you received: 18
  • Karma: 0
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.
The administrator has disabled public write access.

Internal server error when i import a survey 1 year 9 months ago #92880

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?
The administrator has disabled public write access.
  • Page:
  • 1
  • 2
Moderators: ITEd
Time to create page: 0.222 seconds
Donation Image