Failed to found the LimeSurvey survey table error when configuring limesurvey_sync module [#2405909]

After installing limesurvey_sync on my drupal 7 site without any issue, I clicked on the configure link to check if there is any other thing I need to configure in order to ensure that everything is ok.

I noticed that the LIMESURVEY DATABASE CONNECTION is still showing a red cross.

When I clicked on 'Rewrite the settings.php file' link (with lime_ as the entry for the LimeSurvey site
table prefix), The error at the top of the page read:

Failed to found the LimeSurvey survey table. The server reports the following message: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'websitename_dru1.lime_surveys' doesn't exist.

I have tried changing the prefix to fiy_ (which was the prefix I saw when I checked limesurvey database) but the error still persist.

I have also tried appending the connection information into the 'sites/default/settings.php' file but after refreshing the page, it totally prevented me from accessing the website so I had to revert to what it was before the change.

(Also note: The LimeSuvey site and this Drupal site are using the same hosting server, database type (mysql) and database)

Please what else do I need to do?

Comments

Comment #1

thedut CreditAttribution: thedut commented 16 January 2015 at 13:54

Hello nicechap !

I have also tried appending the connection information into the 'sites/default/settings.php' file but after refreshing the page, it totally prevented me from accessing the website so I had to revert to what it was before the change.

I guess it is a conflict regarding the file permissions on the settings.php file
Read this page for helping.

About appending LimeSurvey information connexion into the settings.php file : if the LimeSuvey site and this Drupal site are using the same hosting server, database type (mysql) and database) and your settings.php file contains something like this :

$databases = array (
  'default' => 
  array (
    'default' => 
    array (
      'database' => 'my_dp_database',
      'username' => 'my_dp_username',
      'password' => 'my_dp_password',
      'host' => 'localhost',
      'port' => '',
      'driver' => 'mysql',
      'prefix' => 'dp_',
    ),
  ),
);

Add after this line

$databases['ls']['default'] = array(
 'database' => 'my_dp_database',
  'username' => 'my_dp_username',
  'password' => 'my_dp_password',
  'host' => 'localhost',
  'port' => '',
  'driver' => 'mysql',
  'prefix' => 'fiy_',
);