CiviCRM Community Forums (archive)

We're attempting a first time install of CiviCRM 3.1.3 under Drupal 6 (separate CiviCRM database), with PHP 5.2 and MySQL 5.0, but we're getting...

=====
Building database schema and setup files...

Cannot execute INSERT INTO `civicrm_msg_template`
[snipped data]
DB Error: syntax error
=====

notes:
a) Pre-installation check shows Green/OK.
b) PHPMyadmin shows other Tables appear to be ok and populated correctly.
c) Drupal shows the CiviCRM module as enabled, but with the following error, which we assume is due to the Installation not having completed: The CiviCRM settings file (civicrm.settings.php) was not found in the expected location (sites/default/civicrm.settings.php)
d) We've repeated the process a couple of times (just in case), but with the same results.

Any thoughts on what we need to do?

Thanks,
seGAP

Thanks Eileen,

I had overlooked your post, and asked on IRC... dlobo helped by pointing me to /sites/all/modules/civicrm/sql/civicrm.mysql & civicrm_data.mysql.

His suspicion was that I was running an incompatible version of MySQL, but as soon as I looked at civicrm_data.mql I could see that it was corruped/truncated. So I simply reloaded that file, and the Install ran ok just a few moments ago.

So many thanks to both you and dlobo for your help.

Regards,
seGAP