How to find sugarcrm version number, if I only have a database?

How to find sugarcrm version number, if I only have a database? Current database does not support version we have on our server, and I do not know the version number, what previous host had on their server. Web browser says now: "Sugar CRM 6.5.24 Files May Only Be Used With A Sugar CRM 6.5.24 Database." , but it doesn't tell which version should I have. Previous host refuse to give any other files or even tell a version number.

0 Mehul Bhandari over 8 years ago

hi Jouni Kokkonen
login with admin user then you can know from profilemenu > about page.
Cancel
Vote Up +3 Vote Down

Sign in to reply

Verify Answer

Cancel

0 Ajay Kumar over 8 years ago

Hi Jouni,

You can try executing below mysql query .

select * from config where category='info';

It will give you something like below.Here value portion is holding sugar version.

mysql> select * from config where category='info';
+----------+---------------+---------+----------+
| category | name          | value   | platform |
+----------+---------------+---------+----------+
| info     | sugar_version | 7.6.1.0 | NULL     |
+----------+---------------+---------+----------+

Hope this helps.

0 Vincent Amari over 3 years ago in reply to Ajay Kumar

Could you get this version via an API call instead?

.

CRM Business Consultant
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Jeroen Somhorst over 3 years ago in reply to Vincent Amari

If you have the files you could simply go to https://<yoursugarinstance/sugar_version.json
Cancel
Vote Up +2 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Kishan Singh over 1 year ago

Hi Jouni Kokkonen,

you can get the sugar version in PHP using

global $sugar_config;

$sugar_version = $sugar_config['sugar_version'];
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel