Relations missing in the database

[andreasbalzer]

Hi,
I'm still trying to find a solution to the "Query Failed" problem. During my research I found out that my sugarcrm.log shows two relation errors concerning contacts_users and accounts_opportunities

I saw http://www.sugarcrm.com/wiki/index.p...hip_from_cache and tried to open the file but it is not there although the server has write and read access. Now how to create these relations? Unfortunately I'm quite new to sugarcrm and these "neccessary data" are unknown to me. How can I do that?

Greetings,
Andreas

[clint]

We will need to hear more details about your environment. What versions of PHP, DB, SugarCRM are you running? What relations are missing? For core modules or for custom modules you built? What symptoms around the errors are you seeing?

[andreasbalzer]

Hi,

We will need to hear more details about your environment.

sure, I'll post anything you want to know. If you like I can give you direct access to our server as well.[/QUOTE]

What versions of PHP, DB, SugarCRM are you running?

PHP 5.2.6
MYSQL 5.0.45
SugarCRM: I upgraded from 5.0.0f to 5.0.0g (see last question)

What relations are missing?

I don't know what kind of relations are missing, but the sugarcrm.log tells me, that relations for contacts_users and accounts_opportunities are missing. Account module and opportunity modules do not start up. See your last question.

For core modules or for custom modules you built?

Core modules are affected. I do not have any custom installed but there is one uploaded.

What symptoms around the errors are you seeing?

I'm experiencing the "Query Failed" error during login, home module and account modules (only error message visible), empty opportunity module (module shows up, but no contents listed), errors in sugarcrm.log. See http://www.sugarcrm.com/forums/showthread.php?t=28096, especially the last page of the thread where I tried to find more information and also tried to solve it (without luck).

If you need access to the server please send me an email to sugar@andreas-balzer.de or a private message.

Thanks for your help!

Greetings,
Andreas