When I try to content/add content/survey in Drupal I get:

•Notice: Undefined index: fragment in limesurvey_sync_drupal_formated_url() (line 512 of /{PATH REMOVED FOR SECURITY REASONS}/public_html/sites/all/modules/limesurvey_sync/limesurvey_sync.inc).
•Recoverable fatal error: Argument 1 passed to drupal_http_build_query() must be an array, string given, called in /{PATH REMOVED FOR SECURITY REASONS}/public_html/includes/common.inc on line 2141 and defined in drupal_http_build_query() (line 477 of /{PATH REMOVED FOR SECURITY REASONS}/public_html/includes/common.inc).
The website encountered an unexpected error. Please try again later. .

The '{PATH REMOVED FOR SECURITY REASONS}' is added by me. The actual error message shows full path.

If I remove End URL in Lime Survey settings then the error doesn't show and I get the Create Survey page instead. After entering the details and clicking preview the table with settings shows up but I get a red cross in the 'LimeSurvey end URL, redirecting to this site after completion' section. If I save the survey post the options page shows for the post. If I then try to change any options and choose save content type I get:

•Notice: Uninitialized string offset: 0 in limesurvey_sync_rel2abs() (line 548 of /{PATH REMOVED FOR SECURITY REASONS}/public_html/sites/all/modules/limesurvey_sync/limesurvey_sync.inc).
•Notice: Uninitialized string offset: 0 in limesurvey_sync_rel2abs() (line 548 of /{PATH REMOVED FOR SECURITY REASONS}/public_html/sites/all/modules/limesurvey_sync/limesurvey_sync.inc).
•Notice: Uninitialized string offset: 0 in limesurvey_sync_rel2abs() (line 559 of /{PATH REMOVED FOR SECURITY REASONS}/public_html/sites/all/modules/limesurvey_sync/limesurvey_sync.inc).
•You should set on your LimeSurvey admin user interface :
◦'End URL' to 'http://{WEBSITE ADDRESS REMOVED FOR SECURITY REASONS}/?q=backfromsurvey/survey543674' (or an equivalent relative url),

If I at this time add end url in lime survey I get:

Error
The website encountered an unexpected error. Please try again later.

Error message
•Notice: Undefined index: fragment in limesurvey_sync_drupal_formated_url() (line 512 of /{PATH REMOVED FOR SECURITY REASONS}/public_html/sites/all/modules/limesurvey_sync/limesurvey_sync.inc).
•Recoverable fatal error: Argument 1 passed to drupal_http_build_query() must be an array, string given, called in /{PATH REMOVED FOR SECURITY REASONS}/public_html/includes/common.inc on line 2141 and defined in drupal_http_build_query() (line 477 of /{PATH REMOVED FOR SECURITY REASONS}/public_html/includes/common.inc).
. .
Uncaught exception thrown in session handler.

PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'sid' in 'where clause': SELECT 1 AS expression FROM {sessions} sessions WHERE ( (sid = :db_condition_placeholder_0) AND (ssid = :db_condition_placeholder_1) ) FOR UPDATE; Array ( [:db_condition_placeholder_0] => b0axXNjCve-vMJiOFNAovzhhjA3YbXhrHpVVGmOlYqU [:db_condition_placeholder_1] => ) in _drupal_session_write() (line 209 of /{PATH REMOVED FOR SECURITY REASONS}/public_html/includes/session.inc).

I tried all kinds of urls but I always get the same error message. My site uses different servers (FreeBSD) for drupal, lime and mysql. They all run drupal 7.14, lime 1.92, apache 2.2.22, php 5.3.10, and mysql 5.0.89. I have noticed that drupal uses utf8_general_ci and lime utf8_unicode_ci. Please advice.

CommentFileSizeAuthor
#3 limesurvey_sync_fix.zip6.72 KBthedut

Comments

thedut’s picture

thedut commented

Hi henrkmunch,

Thank you for reporting.
This issue may be same as this one.
I am going to provide a fix within a couple of days.

henrkmunch’s picture

henrkmunch commented

That is quite possible but I can't activate clean url for the site in question. Hopefully your patch will solve the problem. Let me know if I can help in any way.

thedut’s picture

thedut commented
StatusFileSize
new limesurvey_sync_fix.zip6.72 KB

Yes you can !
Tell me if the attached file fix this issue (For your information, this is the same file as the one provided into the other similar thread.
In order to help me to reproduce this issue, could you provide me :
- the LimeSurvey site url value available on the /admin/config/ls_sync page
- the survey end url value.
For privacy raisons, you may want to offuscate the strings, (as a example, replacing all letters by x). I need to know about their format.

henrkmunch’s picture

henrkmunch commented

It seems to have fixed the first problem but a new problem has showed up. All links that end up in {site url}/admin generates an 500 Internal Server Error. Links that go to {site url}/?q=admin work as they should. So I guess it's still a clean url problem.

The lime site path is just: http://www.survey.x.com
The end URL is: http://www.drupal.x.com/?q=backfromsurvey/survey534827

thedut’s picture

thedut commented

It doesn't seem to be an new issue to me :
As long as you disable the clean url feature, the {site url}/admin url should always fail.
If you don't meet any other issue, I guess we can set this issue to the "fixed" status.

henrkmunch’s picture

henrkmunch commented

That's correct but there are still parts of the module that needs to be rewritten so that they don't redirect you to the wrong url.

Btw, I tried a different instance of the server with clean urls and it works like a charm. To bad that it's not possible to do so on the production server.

thedut’s picture

thedut commented

there are still parts of the module that needs to be rewritten so that they don't redirect you to the wrong url.

Which part ?
If you are using :
- the 7.x-1.x-dev version
- with the limesurvey_sync.inc file provided on #3
The end url should always succeed.
I'm going to release a new stable release including thoses fixes.

Do you think about a new issue to report, especially concerning the End URL ?

thedut’s picture

thedut commented
Status: Active » Closed (fixed)
thedut’s picture

thedut commented

Fixes included into the 7-x.1.1 release.
@henrkmunch : Feel free to reopen this thread if something goes wrong.