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_'
);
Comments
Comment #1
thedut commentedHello hanksterr7,
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 !
Comment #2
hanksterr7 commentedHi 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
Comment #3
thedut commentedFixed into the LimeSurvey Sync 7.x-1.6 release.
You can try it on the demo site (just click on the picture).