2 issues with SugarCE 5.5.0a

[jasv]

Hi everyone,

I got a SugarCRM CE 550a installation with SQL Server 2005, and i'm having 2 problems.

1. (Low priorty) If i don't disable error displaying on my php.ini file, the following message is always showing up:

Warning: array_key_exists() [function.array-key-exists]: The first argument should be either a string or an integer in C:\xampp\htdocs\Sugar-Choucair\modules\Trackers\BreadCrumbStack.php on line 101

2. (Highest priority) Sometimes (sometimes very often, sometimes not so) i'm getting this error:

Unable to select database

I want to fix this issues ASAP. Thanks in advance for all your help.

[Angel]

A couple of questions that might help us guide you along...

What version of PHP are you using?

Which drivers are you using to connect to MSSQL? (Are you using FreeTDS)

Does the second problem occur more often with specific modules? If so, how many records in said module?

[jasv]

Hi, thanks for the answer,

I'm using PHP 5.2.8

I'm using the php_mssql.dll extension to connect with the database. Also, i'm using the library ntwdblib.dll v. 2000.80.194.0 (copied on PHP, Apache/Bin and System32 folders).

The second problem does not occur with a specific module. Besides, Sugar has only one week on production, so there's no a lot of records.

Hope this will help.

[Angel]

Hmm...interesting...

I would encourage you to upgrade to 5.5.4. It is possible that might help.

I don't know of a specific reason for the disconnects, but I have seen it occur when using FreeTDS while accessing larger tables, with Sugar 5.2. Some related fixes were rolled into 5.5, but I believe it didn't happen until post 5.5.0.

[jasv]

mmm I don't think an upgrade would be possible in this moment.

There's no other solution? or maybe some method to trace this error.

This is starting to getting mad some users

Thanks in advance for all of you.

[Angel]

You can try using the the debug log to see if it captures a helpful error or the like.

Either way, I wouldn't expect an easy or fast fix. Disconnects could be related to a number of things, at the software or hardware level. Point being, there is no one answer.