Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x

SugarCRM

161

Solutions

277

Contributors

SugarCRM produces the web application Sugar, a customer relationship management (CRM) system that is available in both open-source and commercial open-source applications. Sugar's functionality includes sales-force automation, marketing campaigns, customer support, collaboration, Mobile CRM, Social CRM and reporting.

Share tech news, updates, or what's on your mind.

Sign up to Post

Hi Everyone,

I have a question to find some simple clarification.
I did do a upgrade of VTiger 6.4 to 6.5 and get a deadlock error when creating a new lead. After researching I saw that it could have something to do with the vtiger_version.

I did restore it all back to Version 6.4 and all if running fine there. Before I retry the upgrade from 6.4 to 6.5 I noticed that the vtiger_version table indicated the following:
old_version: 5.4.0
current_version:  5.4.0

This VTiger install was initially installed on 5.4 years ago. Than it was upgraded to version 6 by and later to 6.4.

Long story short, my question is: As I am running version 6.4 now for many month, but what should the correct vtiger_version table say? Its clear it should be current_version:  6.4.0 but what should be in old_version? Should it be 6.0 since I uprated from 6 to 6.4 or should it contain the original installed version which was 5.4.0? or maybe 6.4.0 as this is what I run now.

I hope the question makes sense.
0
Free Tool: Subnet Calculator
LVL 11
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Hello,

You will have to forgive me here as I am in no way a sugar or php expert :)

I have just changed the IP of our sugar instance (web server and db) as part of a larger piece of work. I can no longer access the sugar site, instead I get a 'this page cannot be displayed' error.

Looking at the sugar log I see errors such as:

08/19/17 00:48:06 [1968][-none-][FATAL] Could not connect to server xxxxxx as xxxxxx.
08/19/17 00:48:06 [1968][-none-][FATAL] Unable to retrieve system settings Query Failed:SELECT category, name, value FROM config WHERE category = N'tracker'::: Database Is Not Connected

I have modified a php script to test connection to the database server using the creds specified in config files and it passes.

Name resolution on each server works fine.

I have been through various config files that I could find and replaced any legacy IP's but still get this error, there may be more config files to adjust but I have no idea where they are.

The environment is Windows Server 2008R2 and SQL Server 2008R2 (sorry!), separate servers.

Please do let me know what extra info you may need.

Please could someone help :)
0

SugarCRM

161

Solutions

277

Contributors

SugarCRM produces the web application Sugar, a customer relationship management (CRM) system that is available in both open-source and commercial open-source applications. Sugar's functionality includes sales-force automation, marketing campaigns, customer support, collaboration, Mobile CRM, Social CRM and reporting.

Top Experts In
SugarCRM
<
Monthly
>

No Top Experts for this time period. Answer questions to earn the title!