Cannot add a conntact

[Sugarstefan]

Hi @ All,

Sugarversion: SugarCE-6.2.1
PHP Version 5.2.17
Zend Framework Version 1.11.3
Apache: 2.2.16


i have some problems to create new contacts. After I click save I get this Message:

Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, admin@example.com and inform them of the time the error occurred, and anything you might have done that may have caused the error.
More information about this error may be available in the server error log.

sugarcrmlog:
07/28/11 01:03:15 [3820][1][FATAL] Error fetching relationship from cache accounts_contacts
07/28/11 01:03:15 [3820][1][FATAL] Error fetching relationship from cache contacts_assigned_user
07/28/11 01:03:25 [3820][1][FATAL] Error fetching relationship from cache contacts_users

PHP Error Log:
[28-Jul-2011 01:03:15] PHP Notice: Undefined variable: relationships in C:\Program Files (x86)\Zend\Apache2\htdocs\SugarCRM\modules\Relatio nships\Relationship.php on line 221
[28-Jul-2011 01:03:15] PHP Warning: array_key_exists() [<a href='function.array-key-exists'>function.array-key-exists</a>]: The second argument should be either an array or an object in C:\Program Files (x86)\Zend\Apache2\htdocs\SugarCRM\modules\Relatio nships\Relationship.php on line 191
[28-Jul-2011 01:03:15] PHP Warning: array_key_exists() [<a href='function.array-key-exists'>function.array-key-exists</a>]: The second argument should be either an array or an object in C:\Program Files (x86)\Zend\Apache2\htdocs\SugarCRM\modules\Relatio nships\Relationship.php on line 191
[28-Jul-2011 01:03:25] PHP Warning: array_key_exists() [<a href='function.array-key-exists'>function.array-key-exists</a>]: The second argument should be either an array or an object in C:\Program Files (x86)\Zend\Apache2\htdocs\SugarCRM\modules\Relatio nships\Relationship.php on line 191
[28-Jul-2011 01:03:25] PHP Notice: Undefined property: Contact::$user_sync in C:\Program Files (x86)\Zend\Apache2\htdocs\SugarCRM\modules\Contact s\ContactFormBase.php on line 594
[28-Jul-2011 01:03:25] PHP Fatal error: Call to a member function delete() on a non-object in C:\Program Files (x86)\Zend\Apache2\htdocs\SugarCRM\modules\Contact s\ContactFormBase.php on line 594


This doesn't happen on all of my relationships just these two. I have run the repairs on relationships, database, and indexes and cleared the vardef cache. I have also verified that the entire cache directory is world writable , and that my php.ini file has safe mode off and a 128MB memory limit.

Any one have any ideas I can try to get this fixed?

Thanks

[andopes]

This seems to be a relationship issue.
Delete the file cache/modules/Relationships/relationships.cache.php
Then go to Admin -> Repair -> Quick Repair and Rebuild
Try again.

Regards

[Sugarstefan]

Hi,

I´ve tried that but it doesent work. The error is the same as bevor.

Content from the file Relationshipvardefs:

<?php
// created: 2011-07-28 07:40:07
$GLOBALS["dictionary"]["Relationship"] = array (
'table' => 'relationships',
'fields' =>
array (
'id' =>
array (
'name' => 'id',
'vname' => 'LBL_ID',
'type' => 'id',
'required' => true,
),
'relationship_name' =>
array (
'name' => 'relationship_name',
'vname' => 'LBL_RELATIONSHIP_NAME',
'type' => 'varchar',
'required' => true,
'len' => 150,
'importable' => 'required',
),
'lhs_module' =>
array (
'name' => 'lhs_module',
'vname' => 'LBL_LHS_MODULE',
'type' => 'varchar',
'required' => true,
'len' => 100,
),
'lhs_table' =>
array (
'name' => 'lhs_table',
'vname' => 'LBL_LHS_TABLE',
'type' => 'varchar',
'required' => true,
'len' => 64,
),
'lhs_key' =>
array (
'name' => 'lhs_key',
'vname' => 'LBL_LHS_KEY',
'type' => 'varchar',
'required' => true,
'len' => 64,
),
'rhs_module' =>
array (
'name' => 'rhs_module',
'vname' => 'LBL_RHS_MODULE',
'type' => 'varchar',
'required' => true,
'len' => 100,
),
'rhs_table' =>
array (
'name' => 'rhs_table',
'vname' => 'LBL_RHS_TABLE',
'type' => 'varchar',
'required' => true,
'len' => 64,
),
'rhs_key' =>
array (
'name' => 'rhs_key',
'vname' => 'LBL_RHS_KEY',
'type' => 'varchar',
'required' => true,
'len' => 64,
),
'join_table' =>
array (
'name' => 'join_table',
'vname' => 'LBL_JOIN_TABLE',
'type' => 'varchar',
'len' => 64,
),
'join_key_lhs' =>
array (
'name' => 'join_key_lhs',
'vname' => 'LBL_JOIN_KEY_LHS',
'type' => 'varchar',
'len' => 64,
),
'join_key_rhs' =>
array (
'name' => 'join_key_rhs',
'vname' => 'LBL_JOIN_KEY_RHS',
'type' => 'varchar',
'len' => 64,
),
'relationship_type' =>
array (
'name' => 'relationship_type',
'vname' => 'LBL_RELATIONSHIP_TYPE',
'type' => 'varchar',
'len' => 64,
),
'relationship_role_column' =>
array (
'name' => 'relationship_role_column',
'vname' => 'LBL_RELATIONSHIP_ROLE_COLUMN',
'type' => 'varchar',
'len' => 64,
),
'relationship_role_column_value' =>
array (
'name' => 'relationship_role_column_value',
'vname' => 'LBL_RELATIONSHIP_ROLE_COLUMN_VALUE',
'type' => 'varchar',
'len' => 50,
),
'reverse' =>
array (
'name' => 'reverse',
'vname' => 'LBL_REVERSE',
'type' => 'bool',
'default' => '0',
),
'deleted' =>
array (
'name' => 'deleted',
'vname' => 'LBL_DELETED',
'type' => 'bool',
'reportable' => false,
'default' => '0',
),
),
'indices' =>
array (
0 =>
array (
'name' => 'relationshippk',
'type' => 'primary',
'fields' =>
array (
0 => 'id',
),
),
1 =>
array (
'name' => 'idx_rel_name',
'type' => 'index',
'fields' =>
array (
0 => 'relationship_name',
),
),
),
'custom_fields' => false,
);
?>


Sugarcrm.log:
07/28/11 07:40:03 [1988][-none-][FATAL] SQL Server error: [Microsoft][SQL Server Native Client 10.0][SQL Server]Der Datenbankkontext wurde auf 'sugarcrm' geändert.. [Microsoft][SQL Server Native Client 10.0][SQL Server]Die Spracheneinstellung wurde auf Deutsch geändert..
07/28/11 07:40:23 [1988][1][FATAL] Error fetching relationship from cache accounts_contacts
07/28/11 07:40:23 [1988][1][FATAL] Error fetching relationship from cache contacts_assigned_user
07/28/11 07:40:36 [2600][1][FATAL] Error fetching relationship from cache contacts_users



Php.Log

[28-Jul-2011 07:40:23] PHP Notice: Undefined variable: relationships in C:\Program Files (x86)\Zend\Apache2\htdocs\SugarCRM\modules\Relatio nships\Relationship.php on line 221
[28-Jul-2011 07:40:23] PHP Warning: array_key_exists() [<a href='function.array-key-exists'>function.array-key-exists</a>]: The second argument should be either an array or an object in C:\Program Files (x86)\Zend\Apache2\htdocs\SugarCRM\modules\Relatio nships\Relationship.php on line 191
[28-Jul-2011 07:40:23] PHP Warning: array_key_exists() [<a href='function.array-key-exists'>function.array-key-exists</a>]: The second argument should be either an array or an object in C:\Program Files (x86)\Zend\Apache2\htdocs\SugarCRM\modules\Relatio nships\Relationship.php on line 191
[28-Jul-2011 07:40:36] PHP Warning: array_key_exists() [<a href='function.array-key-exists'>function.array-key-exists</a>]: The second argument should be either an array or an object in C:\Program Files (x86)\Zend\Apache2\htdocs\SugarCRM\modules\Relatio nships\Relationship.php on line 191
[28-Jul-2011 07:40:36] PHP Notice: Undefined property: Contact::$user_sync in C:\Program Files (x86)\Zend\Apache2\htdocs\SugarCRM\modules\Contact s\ContactFormBase.php on line 594
[28-Jul-2011 07:40:36] PHP Fatal error: Call to a member function delete() on a non-object in C:\Program Files (x86)\Zend\Apache2\htdocs\SugarCRM\modules\Contact s\ContactFormBase.php on line 594

[Sugarstefan]

The SQL Statement by rebuilding failed:

I´ve got a white screen :-)

SQL Error : [Microsoft][SQL Server Native Client 10.0][SQL Server]Falsche Syntax in der N�he des 'PRIMARY'-Schl�sselworts..

If it runs on the native SQL console:

ALTER TABLE acl_actions DROP PRIMARY KEY DROP INDEX idx_aclaction_id_del ON acl_actions ALTER TABLE acl_actions ADD id varchar(36) NOT NULL ALTER TABLE acl_actions ADD CONSTRAINT pk_acl_actions PRIMARY KEY (id) CREATE INDEX idx_aclaction_id_del ON acl_actions (id,deleted) ;

Meldung 156, Ebene 15, Status 1, Zeile 4
Falsche Syntax in der Nähe des 'PRIMARY'-Schlüsselworts.

My Database is MS SQL 2008 Express