Query Failed eroor after loading custome Module

[molson150]

After I deploy a custom module from the module builder in Suger CE 5 I get an error message of:

"Query Failed: AND users.id = 'a90514f3-b618-233a-db14-4768394ae67f'::MySQL error 1064:"

And my Sugarcrm.log file contains:

Thu Dec 20 16:19:08 2007,487 [28227] FATAL SugarCRM - Error fetching relationship from cache contacts_users
Thu Dec 20 16:19:08 2007,489 [28227] FATAL SugarCRM - MySQL error 1064:

I can only get to the admin menu when this happens and I can remove the module and it fixes the error.

So I don't know what it takes to fix this and this is only on custom modules.

PHP 5
Fedora 8

Thanks,
Jeremy

[CKnoll]

There is a bug in the module you are loading. After the load the cache is reset and sugar rebuilds the relationships (table relationships in the DB). And there it seems that it hangs at your custom module and stops rebuilding all needed entries becaue the interpreter fails at a certain point. Try in the admin menue to repair -> rebuild relationships - how far does this take you? Does the rebuild finish?

But most likely this will not help since this has caused your problem. The solution is to look into the coding for the custom module and see what causes the error.

Just had the same issue with one of my own custom modules.