Problems with contact detail and when save a new contact

[cibo001]

Problems with contact detail and when save a new contact

note: I am from Italy , errore message are the translation of original message in italian language and is possible are

not exactly for win XP in english language


>>>What is installed

Win XP SP2
Internet explorer
IIS
PHP5 last stable release
Mysql 5.0.11
Sugar CRM 4.2.0d


>What appens?

>>I connect by internet explorer to index.php site home page
>>>Before login page I receive this message:

"error in the scrip"

>>>I start debug e receive this message :

Error of runtime of Microsoft JScript: necessary object

>>>the gunlayer marks it the error on the second line of:

if (show == 'true') {
this.document.getElementById('leftCol').style.disp lay='inline';
document['HideHandle'].src = 'themes/SugarLite/images/hide.gif';
} else {
this.document.getElementById('leftCol').style.disp lay='none';
document['HideHandle'].src = 'themes/SugarLite/images/show.gif';

}


>>I stop debug and click OK and I receive login page and I make login correctly whitout errors

>>I click on "Contacts"
>>>I click on details of a contact and receive the following errors:

>>>>a- with setting short error messages on Internet explorer setup I receive this error message:

Impossibile visualizzare la pagina desiderata. Si è verificato un problema.
....
HTTP 500 - Internal error of the server
Internet Explorer

>>>>b- a- with unsetting short error messages on Internet explorer setup I receive this error message:

Call remote procedure not succeeded

>>>Never of this errors make script error and request debug

>>Same sequence of errors when I create and try to save a new contact or one new company
>>In this case in truth the new one contacts comes regularly saved and appears in the list of contacts, but I cannot

see or to modify the detail in how much appears the usual error
>> If I try to create and to save the contact duplicating it, the page is opened correctly and obviously that marks

me it the duplication of the contact.

>(Previously in occasion of these errors IIS was stopped every time. I reinstalled from zero and now I do not have this problem.)
>Obviously I am trying step to step various roads in order to try to characterize the problem, but if someone has an idea or a suggestion for me I would be happy
===========
New information
=============
When I try to make diagnostic file I receive this error :

Diagnostica in corso...
Warning: mkdir() [function.mkdir]: Permission denied in c:\Inetpub\wwwroot\crm\include\utils\file_utils.ph p on line 44
Warning: mkdir() [function.mkdir]: No such file or directory in c:\Inetpub\wwwroot\crm\include\utils\file_utils.ph p on line 44

5%

Caricamento di config.php ...
Completato

Caricamento della cartella Custom ...
Error: PCLZIP_ERR_READ_OPEN_FAIL (-2) : Unable to open archive 'cache/diagnostic/a93d4c66-f16d-422f-34dd-44af5f091bee/diagnostic20060708-093357/custom_directory.zip' in wb mode

Warning: Unknown: 1 result set(s) not freed. Use mysql_free_result to free result sets which were requested using mysql_query() in Unknown on line 0

========
Last warning is clear for me, but for others I do not know what I have to do

[lindquie]

I have a very similar problem and the same errors.
Additionally, I cannot do a bulk delete. I get the same error.

I am running:
Sugar Suite Open Source Version 4.2.1
Category: Contacts
Operating System: Redhat Linux (paid host)
MySQL - 4.1.18-standard
PHP Version 5.1.4
php: memory_limit 25M
Apache

Reproducing the error:
Entering Contacts
1. Go to contacts
2. Click on Create Contacts
3. Fill out all the information and click save
4. Problem -- See Symptoms


Contact Details
1. Go to contacts
2. Click on a contact to go to contact details
3. Problem See Symptoms

Entering a vCard
1. Go to contacts
2. Create from vCard
3. Select vCard
4. Problem


Symptoms:

Browser
* Firefox 1.5 --> Just shows a blank screen.
* MS IE --> Error 500 Internal Server Error
or if you turn off friendly messages:
The following error occurred:
[code=SERVER_RESPONSE_CLOSE] The server closed the connection while reading the response. Contact your system administrator.

SugarCRM Log
Sat Jul 15 00:50:28 2006,534 [17414] FATAL SugarCRM - Unable to load the module() language file for the selected language(en_us) or the default language(en_us)

There are no US English updates. When I tried to install the altest UK/British English language the Module Loader said it was incompatible.

Other Related Problems
Since I can't get to Contact details I can't delete the blank entry.
Since the server seems to close the connection when it runs its SQL query, I can't do a bulk delete/

[mtwim]

Hello there,

I'm posting this message because hopefully someone will recognise this bug if I give as much step-by-step information of how we are trying to handle this problem. We have installed SugarCRM as a part of the Asterisk@Home project.

We experience the same problems at our company... We also cannot acces any detail-pages, e.g. the 'My Account' page, 'new oppertunity', etc.

1. I tried to solve the problem by reinstalling the sugar open source files and by making use of the original database (performed the installation from scratch).
It didn't work out.
2. Tried to reinstall Sugar from scratch and importing my existing sugarcrm database into the fresly made database.
No effect.
3. I tried a completely new install in a new directory and by using a 'create new' database.
After that it seemed to work. But when I made a new admin-entry, the detail-page was not visible anymore again.
4. It seems like it has something to do with the handeling of detailviewrecord or someting.

http://192.168.1.34/crm/index.php?mo...lView&record=1 gives a unavailabe page message.

Maybe it is a bug that wasn't there in previous versions... So maybe it would help us to change to an older version of Sugar? Or maybe by installing Trixbox, instead of asterisk@home. (I personally don't think it has anything to do with asterisk@home).

[lindquie]

I have a very similar problem and the same errors.
Additionally, I cannot do a bulk delete. I get the same error.
The error seems to be related to either:
* inability to load module language en-us
* MySQL error 1064: You have an error in your SQL syntax

I have seen similar MySQL errors related to the way the JOINS are formed.

DETAILS

I am running:
Sugar Suite Open Source Version 4.2.1
Category: Contacts
Operating System: Redhat Linux (paid host)
MySQL - 4.1.18-standard
PHP Version 5.1.4
php: memory_limit 25M
Apache

I also upgraded to Sugar Suite Open Source 4.2.1a, but all the problems are the same. But I have more details from the debugger.

Reproducing the error:
Entering Contacts
1. Go to contacts
2. Click on Create Contacts
3. Fill out all the information and click save
4. Problem -- See Symptoms


Contact Details
1. Go to contacts
2. Click on a contact to go to contact details
3. Problem See Symptoms

Entering a vCard
1. Go to contacts
2. Create from vCard
3. Select vCard
4. Problem


Symptoms:

Browser
* Firefox 1.5 --> Just shows a blank screen.
* MS IE --> Error 500 Internal Server Error
or if you turn off friendly messages:
The following error occurred:
[code=SERVER_RESPONSE_CLOSE] The server closed the connection while reading the response. Contact your system administrator.

SugarCRM Log
Sat Jul 15 00:50:28 2006,534 [17414] FATAL SugarCRM - Unable to load the module() language file for the selected language(en_us) or the default language(en_us)

There are no US English updates. When I tried to install the altest UK/British English language the Module Loader said it was incompatible.

Other Related Problems
Since I can't get to Contact details I can't delete the blank entry.
Since the server seems to close the connection when it runs its SQL query, I can't do a bulk delete/

Detailed SugarCRM Debug Log for Contacts

What the detailed log shows is that all the contact information is available, even the blank record from the vCard, but SugarCRM has a problem with the language module and potential my web hosts version of MySQL which if 4.1.18-standard.

Sat Jul 15 02:39:59 2006,420 [15223] FATAL SugarCRM - Unable to load the module() language file for the selected language(en_us) or the default language(en_us)
Sat Jul 15 02:52:49 2006,970 [17772] ERROR SugarCRM - MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Sat Jul 15 02:59:49 2006,402 [15036] FATAL SugarCRM - Unable to load the module() language file for the selected language(en_us) or the default language(en_us)



Thanks,

Erik

[ruchida]

Did you set register_long_arrays = On in php.ini?

[cibo001]

YES register_long_arrays is On

[ruchida]

Can you increase the memory_limit variable and see what happens?

I've tried exactly the same stack as yours and am not having any problem. (but with more memory)

[mtwim]

hmm,

php.ini doesn't seem to have a line register_long_arrays

can I simply add it?

[ruchida]

mtwim

Run the short script below and see what the variable is defined.

 <?php phpinfo(); ?>  

If register_long_arrays is off, you can add the line and set it to on.

[cibo001]

I increase memory_limit variable up to 128M.
The same problem whit all type of details and every time server comes stopped.

To investigate I try to perform database repair function.
With "execute SQL" option I receive this error message :
===============
Warning: mysql_query() [http://www.mysql.com/doc]: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 in c:\Inetpub\wwwroot\crm\include\database\MysqlManag er.php on line 142
/* Table : files */
/*COLUMNS/*
/*MISMATCH WITH DATABASE - id - ROW [Field] => 'id' [Type] => 'varchar(36)' [Null] => 'NO' [Key] => 'PRI' [Default] => '' [Extra] => '' */
/* VARDEF - id - ROW[Field] => 'id' [Type] => 'char(36)' [Null] => 'NO' [Key] => 'PRI' [Default] => '' [Extra] => '' */
alter table files modify column id char(36) NOT NULL
/*MISMATCH WITH DATABASE - assigned_user_id - ROW [Field] => 'assigned_user_id' [Type] => 'varchar(36)' [Null] => 'YES' [Key] => 'MUL' [Default] => '' [Extra] => '' */
/* VARDEF - assigned_user_id - ROW[Field] => 'assigned_user_id' [Type] => 'char(36)' [Null] => 'YES' [Key] => '' [Default] => '' [Extra] => '' */
alter table files modify column assigned_user_id char(36)
/*INDEXES/*
/* Table : acl_roles_actions */
/*COLUMNS/*
/*INDEXES/*
/*MISSING INDEX IN DATABASE - idx_aclactions_roles -index ROW/*
ALTER TABLE acl_roles_actions ADD
=============

It seems would be an incompatibility whit mysql 5 ( $sql string seems to generate the errors), but I do not know how and where try to work to resolve problem.

I attach the diagnostic File.