fatal error when trying to add content->Survey [#1599210]

At first the module worked fine. I made a couple of new surveys and made some responses too.
Later on it just happened when i tried to add a new survey. Just a notice: i did uninstalled the module an reinstalled it with no luck to work properly as it did with the first surveys. I have tried the normal release as well as the dev.
The error:

Notice: Undefined index: fragment in limesurvey_sync_drupal_formated_url() (line 512 of C:\wamp\www\drupal-7.14\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 C:\wamp\www\drupal-7.14\includes\common.inc on line 2141 and defined in drupal_http_build_query() (line 477 of C:\wamp\www\drupal-7.14\includes\common.inc).

The website encountered an unexpected error. Please try again later.
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] => DVNb7382kfVE6_GzJ-D59bnKStXX79LckoBKZRBtcA4 [:db_condition_placeholder_1] => ) in _drupal_session_write() (line 209 of C:\wamp\www\drupal-7.14\includes\session.inc).

( ! ) Fatal error: Exception thrown without a stack frame in Unknown on line 0
Call Stack
# Time Memory Function Location
1 0.0017 368312 {main}( ) ..\index.php:0
2 0.3269 20369560 menu_execute_active_handler( ) ..\index.php:21
3 0.3296 20573840 call_user_func_array ( ) ..\menu.inc:516
4 0.3296 20574024 node_add( ) ..\menu.inc:0
5 0.3309 20581432 drupal_get_form( ) ..\node.pages.inc:66
6 0.3309 20581976 drupal_build_form( ) ..\form.inc:131
7 0.3309 20583552 drupal_retrieve_form( ) ..\form.inc:339
8 0.3324 20589504 call_user_func_array ( ) ..\form.inc:795
9 0.3324 20589792 node_form( ) ..\form.inc:0
10 0.3330 20597080 ls_survey_form( ) ..\node.pages.inc:137
11 0.3379 21015408 ls_survey_sid( ) ..\ls_survey.module:688
12 0.3545 21376864 limesurvey_sync_survey_properties( ) ..\ls_survey.inc:371
13 0.3974 22429200 limesurvey_sync_drupal_formated_url( ) ..\limesurvey_sync_api_survey.inc:144
14 0.4981 22479752 url( ) ..\limesurvey_sync.inc:512
15 0.4983 22480544 drupal_http_build_query( ) ..\common.inc:2141
16 0.4983 22481096 _drupal_error_handler( ) ..\bootstrap.inc:0
17 0.4983 22481096 _drupal_error_handler_real( ) ..\bootstrap.inc:2226
18 0.4991 22489344 _drupal_log_error( ) ..\errors.inc:90

Comment	File	Size	Author
#12	Untitled-1.jpg	234.79 KB	dustinrwh
#5	limesurvey_sync_fix.zip	6.72 KB	thedut
#1	limesurvey_sync.inc_.zip	6.83 KB	thedut

Comments

Comment #1

thedut commented 24 May 2012 at 20:59

Status	File	Size
new	limesurvey_sync.inc_.zip	6.83 KB

Hi !
This issue is well documented !
I'm not sure to understand the whole process.
The fatal error only appears because the LimeSuvey database connection was still alive before the bug occurs and so was not close.

Here some debug ways :
- When you have reinstalled the LimeSurvey sync module, did you check if the synchronization was correctly set on the /admin/config/ls_sync page ? What is the current status on that page ?
- Try to add survey with the new attached file : limesurvey_sync.inc and tell me if the page is succesfully loaded.

Comment #2

ioSmith commented 24 May 2012 at 21:06

Hi thedut! Great work with the module by the way!
Unfortunately the problem insists...

- When you have reinstalled the LimeSurvey sync module, did you check if the synchronization was correctly set on the /admin/config/ls_sync page ? What is the current status on that page ?
Everything is ok (ticked V)

- Try to add survey with the new attached file : limesurvey_sync.inc and tell me if the page is succesfully loaded.
Here are the results (i still use the dev version):
Recoverable fatal error: Argument 1 passed to drupal_http_build_query() must be an array, string given, called in C:\wamp\www\drupal-7.14\includes\common.inc on line 2141 and defined in drupal_http_build_query() (line 477 of C:\wamp\www\drupal-7.14\includes\common.inc).
The website encountered an unexpected error. Please try again later.

( ! ) Fatal error: Exception thrown without a stack frame in Unknown on line 0
Call Stack
# Time Memory Function Location
1 0.0004 368640 {main}( ) ..\index.php:0
2 0.3024 21098600 menu_execute_active_handler( ) ..\index.php:21
3 0.3050 21302888 call_user_func_array ( ) ..\menu.inc:516
4 0.3050 21303072 node_add( ) ..\menu.inc:0
5 0.3062 21310480 drupal_get_form( ) ..\node.pages.inc:66
6 0.3062 21311024 drupal_build_form( ) ..\form.inc:131
7 0.3062 21312600 drupal_retrieve_form( ) ..\form.inc:339
8 0.3066 21316344 call_user_func_array ( ) ..\form.inc:795
9 0.3066 21316632 node_form( ) ..\form.inc:0
10 0.3069 21323576 ls_survey_form( ) ..\node.pages.inc:137
11 0.3130 21741904 ls_survey_sid( ) ..\ls_survey.module:688
12 0.3279 22109208 limesurvey_sync_survey_properties( ) ..\ls_survey.inc:371
13 0.3597 23161504 limesurvey_sync_drupal_formated_url( ) ..\limesurvey_sync_api_survey.inc:144
14 0.3598 23162824 url( ) ..\limesurvey_sync.inc:513
15 0.3599 23163664 drupal_http_build_query( ) ..\common.inc:2141
16 0.3599 23164216 _drupal_error_handler( ) ..\bootstrap.inc:0
17 0.3599 23164216 _drupal_error_handler_real( ) ..\bootstrap.inc:2226
18 0.3602 23178480 _drupal_log_error( ) ..\errors.inc:90

Comment #3

thedut commented 25 May 2012 at 08:38

Ok, this bug should only occurs
- on the drupal 7 version,
- with clean url desactivated (it is not the default configuration).
But I am not able to reproduce it.

This comment provides helps on that issue.
As a quick workarround : you should activate clean url (go to /admin/config/search/clean-urls).
On wamp, you may need to activate the rewrite module (left click on the wamp icon located into the Windows system tray > Apache > Apache modules > rewrite module).
I hope I will have more time next week to investigate on that issue.

Comment #4

ioSmith commented 25 May 2012 at 14:10

Version:

7.x-1.x-dev

» 7.x-1.0

I did the two steps (clean urls + rewrite module in Apache), i uninstalled the module, reintalled the module (the release version):

*Notice: Undefined index: fragment in limesurvey_sync_drupal_formated_url() (line 512 of C:\wamp\www\drupal-7.14\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 C:\wamp\www\drupal-7.14\includes\common.inc on line 2141 and defined in drupal_http_build_query() (line 477 of C:\wamp\www\drupal-7.14\includes\common.inc).

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

( ! ) Fatal error: Exception thrown without a stack frame in Unknown on line 0
Call Stack
# Time Memory Function Location
1 0.0008 367840 {main}( ) ..\index.php:0
2 0.9634 21074104 menu_execute_active_handler( ) ..\index.php:21
3 0.9706 21278392 call_user_func_array ( ) ..\menu.inc:516
4 0.9706 21278576 node_add( ) ..\menu.inc:0
5 0.9760 21285992 drupal_get_form( ) ..\node.pages.inc:66
6 0.9760 21286536 drupal_build_form( ) ..\form.inc:131
7 0.9761 21288112 drupal_retrieve_form( ) ..\form.inc:339
8 0.9795 21294056 call_user_func_array ( ) ..\form.inc:795
9 0.9795 21294344 node_form( ) ..\form.inc:0
10 0.9809 21301560 ls_survey_form( ) ..\node.pages.inc:137
11 0.9957 21719888 ls_survey_sid( ) ..\ls_survey.module:688
12 1.0508 22072880 limesurvey_sync_survey_properties( ) ..\ls_survey.inc:371
13 1.1747 23125256 limesurvey_sync_drupal_formated_url( ) ..\limesurvey_sync_api_survey.inc:144
14 1.3073 23175808 url( ) ..\limesurvey_sync.inc:512
15 1.3075 23176600 drupal_http_build_query( ) ..\common.inc:2141
16 1.3075 23177152 _drupal_error_handler( ) ..\bootstrap.inc:0
17 1.3076 23177152 _drupal_error_handler_real( ) ..\bootstrap.inc:2226
18 1.3084 23185400 _drupal_log_error( ) ..\errors.inc:90

Then i used the file from your previous post ("Try to add survey with the new attached file : limesurvey_sync.inc and tell me if the page is succesfully loaded."):

Recoverable fatal error: Argument 1 passed to drupal_http_build_query() must be an array, string given, called in C:\wamp\www\drupal-7.14\includes\common.inc on line 2141 and defined in drupal_http_build_query() (line 477 of C:\wamp\www\drupal-7.14\includes\common.inc).
The website encountered an unexpected error. Please try again later.
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] => GrfYk59vbc90Rm7dt3Lhhs9LOLyvNTlT5p8892vyDEs [:db_condition_placeholder_1] => ) in _drupal_session_write() (line 209 of C:\wamp\www\drupal-7.14\includes\session.inc).

( ! ) Fatal error: Exception thrown without a stack frame in Unknown on line 0
Call Stack
# Time Memory Function Location
1 0.0008 368496 {main}( ) ..\index.php:0
2 0.3610 21074872 menu_execute_active_handler( ) ..\index.php:21
3 0.3642 21279160 call_user_func_array ( ) ..\menu.inc:516
4 0.3642 21279344 node_add( ) ..\menu.inc:0
5 0.3653 21286760 drupal_get_form( ) ..\node.pages.inc:66
6 0.3654 21287304 drupal_build_form( ) ..\form.inc:131
7 0.3654 21288880 drupal_retrieve_form( ) ..\form.inc:339
8 0.3668 21294824 call_user_func_array ( ) ..\form.inc:795
9 0.3668 21295112 node_form( ) ..\form.inc:0
10 0.3674 21302328 ls_survey_form( ) ..\node.pages.inc:137
11 0.3731 21720648 ls_survey_sid( ) ..\ls_survey.module:688
12 0.4002 22075040 limesurvey_sync_survey_properties( ) ..\ls_survey.inc:371
13 0.4417 23127360 limesurvey_sync_drupal_formated_url( ) ..\limesurvey_sync_api_survey.inc:144
14 0.4418 23128680 url( ) ..\limesurvey_sync.inc:513
15 0.4419 23129520 drupal_http_build_query( ) ..\common.inc:2141
16 0.4419 23130072 _drupal_error_handler( ) ..\bootstrap.inc:0
17 0.4420 23130072 _drupal_error_handler_real( ) ..\bootstrap.inc:2226
18 0.4424 23144336 _drupal_log_error( ) ..\errors.inc:90

I don't know what to say...It used to work well! :)
thedut, i will be waiting for your update. Many thanks for your effort.

PS.: I just remembered the problems started when i tried to set the properties of the survey to be in an iFrame. It didn't work (i don't remember why - i am new on drupal). Then when i tried to make a new survey, the problems began to happen...

Comment #5

thedut commented 7 June 2012 at 23:20

Status	File	Size
new	limesurvey_sync_fix.zip	6.72 KB

Hi,

At last !
Try this fix (replacing the limesurvey_sync.inc file by the one in the archive) and tell me if this issue is fixed.
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.

Comment #6

ioSmith commented 12 June 2012 at 21:43

Hey thedut! I tried your fix but i didn't work. I just did Add Content-->Survey.
Take a look at the error:

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'limesurvey.lime_tokens_84242' doesn't exist in limesurvey_sync_survey_properties() (line 61 of C:\wamp\www\drupal-7.14\sites\all\modules\limesurvey_sync\ls_api\limesurvey_sync_api_survey.inc).
The website encountered an unexpected error. Please try again later.

( ! ) Fatal error: Exception thrown without a stack frame in Unknown on line 0
Call Stack
# Time Memory Function Location
1 0.4399 23092768 _drupal_exception_handler( ) ..\bootstrap.inc:0
2 0.4400 23093848 _drupal_log_error( ) ..\bootstrap.inc:2244

I will provide you with the info you ask ASAP. :)

Comment #7

thedut commented 17 June 2012 at 11:25

I'm sorry but I don't understand this issue. This error message doesn't help me.
As I can't reproduce this issue, I guess your personnal configuration may be involved.
I suggest you to provide me a copy of your site (files, database and a copy of your phpinfo available on the admin/reports/status/php page). My email is into the module README.txt file.

Comment #8

ioSmith commented 18 June 2012 at 15:41

Hey thedut! Here is what i did:
I searched my database and deleted all lime_tokens_84242 (they were some old tokens table). The problem persisted. Then i decided to search for the problematic survey (quite painful!). I did found it and i made a new tokens table. Now it works fine!
Hope it helps you resolve the bug (if it's one!)
à bientôt! :)

Comment #9

thedut commented 20 June 2012 at 08:53

Hi ioSmith,

I'm glad every works fine now. It confirms that your personnal configuration were involved.
The fix seems ok to me.
I'm going to release the new limesurvey_sync stable version including this fix.

Comment #10

thedut commented 20 June 2012 at 08:54

Status:

Active

» Closed (fixed)

Comment #11

thedut commented 20 June 2012 at 10:15

Fixes included into the 7-x.1.1 release.

Comment #12

dustinrwh commented 27 July 2012 at 23:37

Status	File	Size
new	Untitled-1.jpg	234.79 KB

Just wanted to let everyone know that I had a similar error happen to me when attempting to import a survey into Drupal. The reason this was happening is because I did not create a tokens table in the database in LimeSurvery.

So, the moral of the story is.....

Make sure to click on "Tokens Management" for the survey so that LimeSurvey creates a table in the database for the survey.

This is what was causing my error, so hope it helps someone out :)

Comment #13

thedut commented 3 August 2012 at 07:49

Status:

Closed (fixed)

» Closed (cannot reproduce)

Hi,

I disagree with this moral : you should be able to choose either to use a token table or to not use a token table.
(Your best shot should to use one, this will allow advanced features).
I have just succeed in creating a new survey with no token table on fresh drupal install.
I maintain this thread as closed as I can't reproduce it.
Feel free to reopen it if you find more informations in order to reproduce this issue.
As a example you may provide the error message for de 7.x-1.1 (the error line may have changed) as the actual error message is for the 7.x-1.0 version.

Comment #14