user598241
user598241

Reputation: 91

How can I find out the current version of the CIVICRM database schema

How can I find out the current version of the civicrm database schema?

Upvotes: 0

Views: 967

Answers (1)

Andie Hunt
Andie Hunt

Reputation: 705

Look in the civicrm_domain table for the column version - that'll tell you what version the database is in. (It's updated as one of the last steps in the upgrade process.)

SELECT version FROM civicrm_domain

If you have multiple CiviCRM domains running from the same data set, you'll see multiple entries, but for 99% of organizations, there'll just be the one result.

Meanwhile, if you want to see the codebase version (hopefully they're the same), it's in your civicrm directory in the file civicrm-version.php and displayed at the bottom of each page in the back end of CiviCRM.

Upvotes: 6

Related Questions