Table calls_users doesn't exist

[jimrising]

I just installed sugarCRM Version 5.2.0 (Build 5380).

When browsing to the Calendar, I get the following:

Query Failed:SELECT calls.* from calls_users,calls WHERE (DATE_FORMAT(calls.date_start,'%Y-%m-%d') >= '2009-01-23' AND DATE_FORMAT(calls.date_start,'%Y-%m-%d') <= '2009-02-02') AND calls_users.accept_status != 'decline' AND calls_users.call_id=calls.id AND calls_users.user_id='1' AND calls.deleted=0 AND calls_users.deleted=0::MySQL error 1146: Table 'calls_users' doesn't exist

I've confirmed that this table does not exist in MySql, and have attempted to re-install SugarCRM to see if maybe it missed something along the way. No such luck.

i've also got this in the sugarcrm.log file:

Mon Jan 26 01:37:34 2009 [16719][1][FATAL] Error fetching relationship from cache calls_users
Wed Jan 28 10:25:48 2009 [30628][25b82a32-adb9-653a-c6f8-497c9487014d][FATAL] MySQL error 1146: Table 'calls_users' doesn't exist

i've verified that permissions on the cache are correct.

any ideas?

Jim Rising
Serial Entrepreneur
Sr. Software Engineer
Red Pepper Studios
www.redpepperstudios.com
www.jimrising.com

[jimrising]

I just upgraded to the 5.2.0a patch, and i'm still getting this error. is anyone else experiencing this?

Jim Rising
Serial Entrepreneur
Sr. Software Engineer
Red Pepper Studios
www.redpepperstudios.com
www.jimrising.com

[andopes]

Hi Jim

Go to Admin -> Repair -> Rebuild Extension / Rebuild Relationships / Repair Database
And try again.

Cheers

[jimrising]

did this... rebuilt extensions and relationships... repaired the database... still get the same calls_users' doesn't exist error...

[andopes]

Have a look into sugarcrm.log.
I believe there is any error message regarding that issue.
Additionally go to phpMyAdmin -> sugarcrm database -> relationship table -> and check if there is any record related to that relationship (calls_users).

[jimrising]

op post already had looked at the sugarcrm.log ... and i've confirmed that the call_users table does not exist. i've also made the attempt at re-installing sugarcrm to see if that table would be built. if you can give me the schema for it, i can build it manually.

-jim

[jimrising]

attached diagnostic file.

[jimrising]

calls_contacts and calls_leads are the only calls related relationships found in the 'relationships' table.

[jimrising]

any idea how to fix this?

[jimrising]

so here's what i had to do...

1) i found an incomplete database schema for sugar 5.2.0a. it had the calls_users table in it, but only contained 3 fields... and not much else to go on.

2) i built the table based on that schema... and obviously it still failed to fix the problem. i got a new error showing that i was also missing: calls_users.accept_status

3) i searched on google for calls_users.accept_status ... and i came across this guy's phpMyAdmin:

http://michaelvilela.visuelles.com.b...l_ci&db=mv_crm

enough said.

thanks for the help!

Jim Rising