Hi
Finally got the connection established, but took a while.
Found this error in error_log at the root of my site:
[15-Dec-2013 17:37:07 America/Denver] PHP Parse error: syntax error, unexpected ''collation'' (T_CONSTANT_ENCAPSED_STRING), expecting ')' in /home4/xxxx/public_html/sites/default/settings.php on line 238

by removing the collation entry from the db connection info, the WSOD went away and I got a nice green checkmark in the limesurvey sync config settings page.

I'm on drupal 7.23

This is now my relevant settings.php stuff:


$databases = array (
  'default' => 
  array (
    'default' => 
    array (
      'database' => 'zzzz',
      'username' => 'zzzz',
      'password' => 'zzzz',
      'host' => 'localhost',
      'port' => '',
      'driver' => 'mysql',
      'prefix' => '',
    ),
  ),
);
/* limesurvey port was 3306 */
/* removed  'collation' => 'utf8_general_ci' since this was causing 'unexpected' error */

$databases['ls']['default'] = array( 
'database' => 'wwww', 
'username' => 'wwww', 
'password' => 'wwww',
'host' => 'localhost',
'port' => '', 
'driver' => 'mysql', 
'prefix' => 'ebi_'
);
CommentFileSizeAuthor
#1 limesurvey_sync_easy_inital_settings.png67.58 KBthedut

Comments

thedut’s picture

Component: Code » User interface
Assigned: Unassigned » thedut
Category: Bug report » Feature request
Priority: Critical » Normal
StatusFileSize
new67.58 KB

Hello hanksterr7,

Finally got the connection established, but took a while.

This is not a bug from the LimeSurvey_sync module : editing the setting.php file is not so easy, because the administrator (setting the synchronization) needs to know basic php syntax.
I'm working on a great evolution making this initial step very easy.
I attach a screenshot as a preview for this new feature, coming into the next LimeSurvey_Sync module release !

hanksterr7’s picture

Hi thedut,
I'm not sure you appreciated my issue. Your sample db connection string contained a "collation" entry. This entry was preventing drupal from connecting to Lime Survey. Once I removed it, everything worked fine. There was nothing I saw in the instructions suggesting that some drupal installations might need to have the collation entry removed from the lime survey db connection string. Have others had this issue with "collation"? Sounds great that you are working on an "evolution" that will simplify the initial setup :)
Thanks
-- Hank

thedut’s picture

Status: Active » Closed (fixed)

Fixed into the LimeSurvey Sync 7.x-1.6 release.
You can try it on the demo site (just click on the picture).