!! 3.5.1C -> 4.00 Rebuild Relationships Warning !!!

[Adeo]

Hello,

We upgraded from 3.5.1c to 4.00, and there is a persistent warning message for the admins on ever screen that says:

Please go to the Repair screen and click on Rebuild Relationships.

Obviously, we clicked Rebuild Relationships and Rebuild extensions numerous times, as we as variou other repairs. What is going on?

We are concerned about this. Is there any fix? What should we do?

[mikegotroot]

I'm also seeing the same problem.

[tm2000]

I have a related problem...

see http://www.sugarcrm.com/forums/showthread.php?t=7858

but I can't complete the Rebuild...

[mikegotroot]

I can't complete the rebuild either. :-(

I get this error:

PHP Fatal error: main() [<a href='function.require'>function.require</a>]: Failed opening required '' (include_path='.:/usr/share/pear') in /home/httpd/vhosts/domain.com/httpsdocs/intranet/sales/modules/Administration/RebuildRelationship.php on line 36

[Adeo]

OK:

As per documentation from various forums here, we uninstalled ZuckerMail and installed the new RebuildRelationships.php posted on another forum. However, after doing this and running the REPAIR process as outlined, our server logs showed the following message:

Thu Dec 29 15:30:18 2005] [error] PHP Fatal error: main(): Failed opening required '' (include_path='.:/usr/local/apache/php/lib/php') in /home/www/sugar/modules/Administration/RebuildRelationship.php on line 36, referer: http://crm.xxxx.com/index.php?module...action=Upgrade

We continue to see the: "Please go to the Repair screen and click on Rebuild Relationships." error message.

Help? Help?

[mikegotroot]

Yep, heres the bad news, none of the stuff on the forums so far fixes this. I put in a bug report, and this is supposed to be fixed in 4.0.1, but 4.0.1 is not out yet. :-(

Maybe we should send the developers a coupld of cases of beer to show them the love so we can get 4.0.1. ;-)

[Blind]

i say go back to 3.5.1 got the same problems here and it seems that you fix one another one pops up
got rid of the rebuild relation ship thing but have errors on detail and list veiw in just about every tab

heres one from contacts
Query Failed: AND users.id = '1'::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 = '1'' at line 1

and here is the one that is on detail veiw in just about every tab

Error retrieving Lead list: Query Failed SELECT meetings.id , meetings.name , meetings.status , CONCAT(IFNULL(jt0.first_name,''),' ',IFNULL(jt0.last_name,'')) contact_name, ' ' contact_name_owner , ' ' contact_name_mod , meetings.date_start , meetings.parent_id , meetings.parent_type , meetings.time_start , meetings.assigned_user_id , 'meetings' panel_name FROM meetings AND jt0.deleted=0 where ( meetings.parent_id= '290502a7-97da-387a-d920-43a9cc47c04b' AND meetings.parent_type='Leads' AND meetings.deleted=0 AND (meetings.status='Planned')) AND meetings.deleted=0 ) UNION ALL ( SELECT tasks.id , tasks.name , tasks.status , CONCAT(IFNULL(jt0.first_name,''),' ',IFNULL(jt0.last_name,'')) contact_name , tasks.contact_id , jt0.assigned_user_id contact_name_owner , 'Contacts' contact_name_mod, tasks.date_due as date_start , tasks.parent_id , tasks.parent_type , tasks.time_due as time_start , tasks.assigned_user_id , 'tasks' panel_name FROM tasks LEFT JOIN contacts jt0 ON jt0.id= tasks.contact_id AND jt0.deleted=0 AND jt0.deleted=0 where ( tasks.parent_id= '290502a7-97da-387a-d920-43a9cc47c04b' AND tasks.parent_type='Leads' AND tasks.deleted=0 AND (tasks.status='Not Started' OR tasks.status='In Progress' OR tasks.status='Pending Input')) AND tasks.deleted=0 ) UNION ALL ( SELECT calls.id , calls.name , calls.status , CONCAT(IFNULL(jt0.first_name,''),' ',IFNULL(jt0.last_name,'')) contact_name, ' ' contact_name_owner , ' ' contact_name_mod , calls.date_start , calls.parent_id , calls.parent_type , calls.time_start , calls.assigned_user_id , 'calls' panel_name FROM calls AND jt0.deleted=0 where ( calls.parent_id= '290502a7-97da-387a-d920-43a9cc47c04b' AND calls.parent_type='Leads' AND calls.deleted=0 AND (calls.status='Planned')) AND calls.deleted=0 )::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 jt0.deleted=0 where ( meetings.parent_id= '290502a7-97da-38

woo hoo this if fun

[ifv]

Hi

I managed to solve the problem by upgrading to ZuckerDocs 1.4.2 and uninstalling the module afterwards.

Version 1.4.1 didn't give me the option to uninstall.

I can now Rebuild Relationships without a problem in SugarCRM 4.0.

Hope it helps!