Have installed Commons3.0 (Drupal 7) distribution and Limesurveys 2 on XAMPP and I am trying to enable limesurveys_sync module. There is an exception which is thrown (provided below). The module installation does proceed if we comment out the calling code for the function limesurvey_sync_fake_survey is commented out..

Error message

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'xxxx.surveys' doesn't exist: INSERT INTO {surveys} (sid, active, listpublic, owner_id, admin, language, datecreated) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6); Array ( [:db_insert_placeholder_0] => 462 [:db_insert_placeholder_1] => Y [:db_insert_placeholder_2] => Y [:db_insert_placeholder_3] => 1 [:db_insert_placeholder_4] => The LimeSurvey Sync module [:db_insert_placeholder_5] => en [:db_insert_placeholder_6] => 2013-07-19 20:07:32 ) in limesurvey_sync_fake_survey() (line 551 of C:\xampp\htdocs\commons\sites\all\modules\limesurvey_sync\ls_api\limesurvey_sync_api_sync.inc).

CommentFileSizeAuthor
#3 PDO_Exception_when_enabling_Limesurveys_Sync_Modules-2045883-3.patch2.32 KBthedut
#3 limesurvey_sync.inc_.zip9.11 KBthedut

Comments

thedut’s picture

thedut commented

I need to check this !
As a workarround, the limesurvey_sync_fake_survey() function is not important, you can disable it (commenting it).
I will dig on this issue, thanks.

vispateresa’s picture

vispateresa commented

Hello, I'm having the same problem with Drupal 7 and LimeSurvey Sync.
I tryed the solution to disable the function limesurvey_sync_fake_survey() and now it's working

thedut’s picture

thedut commented
Assigned: thedut » Unassigned
Status: Patch (to be ported) » Active
StatusFileSize
new limesurvey_sync.inc_.zip9.11 KB
new PDO_Exception_when_enabling_Limesurveys_Sync_Modules-2045883-3.patch2.32 KB

This issue returns a fatal error.
It occurs on specific conditions :

  • if you have installed the LimeSurvey software into a folder named 'limesurvey', next to the Drupal folder
  • and you have not set the settings.php file, adding the LimeSurvey software connexions database informations
  • and you enable then the LimeSurvey Sync module (or go to the synchonization setting page)
  • on limesurvey_sync module versions : 7.x-1.3 or 6.x-1.3 (not the previous versions)

Here is the patch fixing this issue (or the corresponding modified file : the limesurvey_sync.inc file).
I will include this fix into the next limesurvey_sync release.

thedut’s picture

thedut commented
Assigned: Unassigned » thedut
Status: Active » Patch (to be ported)
thedut’s picture

thedut commented
Assigned: Unassigned » thedut
Status: Active » Closed (fixed)

Fixed into the 7.x-1.4 and 6.x-1.4 LimeSurvey Sync module releases.