Error when creating a Matrix or installing a Plugin We have 2 computers with a new Craft Pro trial installation. The files are exactly the same on both computers. We both use the same DB with the same db.php config settings.  We can both see the site and login to the /admin section.

The only issue is that on 1 computer I can not create a Matrix field or install a plugin. Then I get the error:

CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'COLLATE=' at line 8


The other computer has no problem creating a Matrix field or installing a plugin. Any suggestions? Thanks!
Check to make sure you have a db.php file here:

craft/app/etc/config/defaults/db.php


If not, download a fresh copy of the version of Craft you're using and replace your craft/app folder with the one you just downloaded.

This file was missing in my Git repository because the .gitignore file was set to ignore all db.php files on the site, not just the one they wanted to ignore in the craft/config folder.

If that's the case, make sure your .gitignore file uses a line like this:

craft/config/db.php


Instead of just this:

db.php