SugarCRM

every time I force the synchronization I get 5 errors. they are as follows:

PHP

25 October 2013 01:58 PM (
3m 48s
)Router: http://helpdesk.computerproserie.com:81/helpdesk/api/index.php?/Base/UserSearch/Post
Undefined index: query (C:/inetpub/wwwroot/helpdesk/__swift/apps/base/api/class.Controller_UserSearch.php:25)

PHP

25 October 2013 01:58 PM (
3m 48s
)Router: http://helpdesk.computerproserie.com:81/helpdesk/api/index.php?/Base/UserSearch/Post
Undefined index: query (C:/inetpub/wwwroot/helpdesk/__swift/apps/base/api/class.Controller_UserSearch.php:24)

PHP

25 October 2013 01:58 PM (
3m 48s
)Router: http://helpdesk.computerproserie.com:81/helpdesk/api/index.php?/Base/UserSearch/Post
Undefined index: query (C:/inetpub/wwwroot/helpdesk/__swift/apps/base/api/class.Controller_UserSearch.php:23)

PHP

25 October 2013 01:58 PM (
3m 48s
)Router: http://helpdesk.computerproserie.com:81/helpdesk/api/index.php?/Base/UserSearch/Post
Undefined index: query (C:/inetpub/wwwroot/helpdesk/__swift/apps/base/api/class.Controller_UserSearch.php:22)

PHP

25 October 2013 01:58 PM (
3m 48s
)Router: http://helpdesk.computerproserie.com:81/helpdesk/api/index.php?/Base/UserSearch/Post
Undefined index: query (C:/inetpub/wwwroot/helpdesk/__swift/apps/base/api/class.Controller_UserSearch.php:21)

Please try to replace

$_query = '';
if (isset($_POST['query']) && !empty($_POST['query'])) {
$_query = $_POST['query'];
}

$_userIDList = array();
$_userContainer = array();

$this->Database->Query("SELECT * FROM " . TABLE_PREFIX . "useremails AS useremails
LEFT JOIN " . TABLE_PREFIX . "users AS users ON (useremails.linktypeid = users.userid)
LEFT JOIN " . TABLE_PREFIX . "userorganizations AS userorganizations ON (users.userorganizationid = userorganizations.userorganizationid)
LEFT JOIN " . TABLE_PREFIX . "usergroups AS usergroups ON (users.usergroupid = usergroups.usergroupid)
WHERE useremails.linktype = '" . SWIFT_UserEmail::LINKTYPE_USER . "' AND
((" . BuildSQLSearch('useremails.email', $_POST['query'], true) . ")
OR (" . BuildSQLSearch('users.fullname', $_POST['query']) . ")
OR (" . BuildSQLSearch('users.phone', $_POST['query']) . ")
OR (" . BuildSQLSearch('userorganizations.organizationname', $_POST['query']) . ")
OR (" . BuildSQLSearch('usergroups.title', $_POST['query']) . "))");

with

$_query = '';
if (isset($_POST['query']) && !empty($_POST['query'])) {
$_query = $_POST['query'];
}

$_userIDList = array();
$_userContainer = array();

$this->Database->Query("SELECT * FROM " . TABLE_PREFIX . "useremails AS useremails
LEFT JOIN " . TABLE_PREFIX . "users AS users ON (useremails.linktypeid = users.userid)
LEFT JOIN " . TABLE_PREFIX . "userorganizations AS userorganizations ON (users.userorganizationid = userorganizations.userorganizationid)
LEFT JOIN " . TABLE_PREFIX . "usergroups AS usergroups ON (users.usergroupid = usergroups.usergroupid)
WHERE useremails.linktype = '" . SWIFT_UserEmail::LINKTYPE_USER . "' AND
((" . BuildSQLSearch('useremails.email', $_query, true) . ")
OR (" . BuildSQLSearch('users.fullname', $_query) . ")
OR (" . BuildSQLSearch('users.phone', $_query) . ")
OR (" . BuildSQLSearch('userorganizations.organizationname', $_query) . ")
OR (" . BuildSQLSearch('usergroups.title', $_query) . "))");

in __swift/apps/base/api/class.Controller_UserSearch.php, around line 74 and try to synchronize once again.

I made the change as requested. no help. what logs/errors do you need to see to get an idea what is going on?

My mistake... The errors have gone away... I'll attempt the other fixes today... I'll keep you posted.

Thanks for all your help.

Rahul Bhattacharya,
You are both a scholar and a saint. My Organizations have synced over now. Users are updated too. now will this run automatically and if so, is there a way to adjust the time frame in between syncs?

Thank you for your help

Actually. I got some more users, but not all of them. Organizations seem to be fine. so I'll look at my contacts and try to find out what is missing from them to get this functioning. Otherwise an awesome project.

Hello Ryan,

Thanks for the note.

is there a way to adjust the time frame in between syncs?

The scheduler is configured to run every minute. This had been implicitly enabled to avoid Load introduction
in the system when sync is being processed.

We can adjust the scheduler run via code adjustments, but is not advisable.

Please let us know if you wish additional assistance on this.

Thanks,
Rahul

I've moved my server to more powerful hardware. it is also now virtualized. What I am having an issue with now. is trying to reinstall the sugarcrm app.

error is:

Notice
Array to string conversion (C:/inetpub/wwwroot/helpdesk/__swift/library/Setup/class.SWIFT_SetupDatabase.php:16) =================================================================================================================================

thanks in advance for any help.

Hello Ryan,

Could you please tell us the exact steps to replicate this issue.

Thanks,
Rahul