Relationship between Contacts Table and Sugar

[lettuce]

I'm runnning 4.5.1b and since I upgraded I cannot see any Contacts in the Sugar screen. If I try to add one manually it does get inserted into my mysql db but i cannot see it in Sugar. I get an sql error:

Query Failed: AND users.id = '4a18cad1-a854-d644-6b86-45b780636c34'::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 'AND users.id = '4a18cad1-a854-d644-6b86-45b780636c34'' at line 1

However my leads module is working fine. I tried rebuklding relationships but it doesnt complete properly giving me the error:
Warning: main(modules/TFEM_Statsobjs/tfem_statsobj.php): failed to open stream: No such file or directory in /srv/www/htdocs/sugar/modules/Administration/RebuildRelationship.php on line 51

Fatal error: main(): Failed opening required 'modules/TFEM_Statsobjs/tfem_statsobj.php' (include_path='.:/usr/share/php') in /srv/www/htdocs/sugar/modules/Administration/RebuildRelationship.php on line 51

is there an obvious relationship setting anywhere that is allowing my leads to be displayed but not my contacts??

any help would be extremely appreciated

[Angel]

See if the suggestion in message 4 of this thread works for you: http://www.sugarcrm.com/forums/showthread.php?t=6533

[ruchida]

Hi
Is "TFEM_Statsobjs" a custom module which you installed before? Is that module compatible with 4.5.1b? Did you run Admin->Repair->Repair relationship?

[lettuce]

See if the suggestion in message 4 of this thread works for you: http://www.sugarcrm.com/forums/showthread.php?t=6533

Unfortunately not my config.php already states:

'dbconfig' =>
array (
'db_host_name' => 'localhost',
'db_host_instance' => '',
'db_user_name' => 'root',
'db_password' => 'password',
'db_name' => 'sugar',
'db_type' => 'mysql',

[lettuce]

Hi
Is "TFEM_Statsobjs" a custom module which you installed before? Is that module compatible with 4.5.1b? Did you run Admin->Repair->Repair relationship?

StatGraph may not be compatible with 4.5.1 i tried to install it in 4.5.0 but it failed because of a permissions problem
and consequently I never used it.
http://www.sugarforge.org/projects/statsgraph/

BUT after installing 4.5.1 it is not in my module list so I cant remove it. As stated earlier When I try to run Admin/repair/rebuild relationships it doesnt complete properly giving me the error:
Warning: main(modules/TFEM_Statsobjs/tfem_statsobj.php): failed to open stream: No such file or directory in /srv/www/htdocs/sugar/modules/Administration/RebuildRelationship.php on line 51

Fatal error: main(): Failed opening required 'modules/TFEM_Statsobjs/tfem_statsobj.php' (include_path='.:/usr/share/php') in /srv/www/htdocs/sugar/modules/Administration/RebuildRelationship.php on line 51

[lettuce]

I've sorted it

I installed Statgraph before I did the upgrade. It is not compatible with 4.5.1
My problems however were related to the fact that the StatObj was still listed as a module in this file:

/srv/www/htdocs/sugar/custom/application/Ext/Include> modules.ext.php

I simply commented it out and hey presto Sugar now works again and I'm not going to be killed by my sales team anymore.

woo hoo