I broke my install removing a package

[dansut]

Custom CentOS Linux with Apache 2.2, php 5.1, mysql 5.0
SugareCRM 5.1a CE

This is not a live system so it's not really a big deal, but... I was playing around creating a package, with some custom modules, that I called test1 (a module was called passenger) - I believe I had added the Passenger module dashlet to my home page as well and think that is where my issue lies.

Now all I get is:

Query Failed:SELECT test1_passenger.id FROM test1_passenger INNER JOIN contacts_tet1_passenger_c ON (test1_passenger.id=contacts_tet1_passenger_c.contacts_te_passenger_idb AND contacts_tet1_passenger_c.contacts_teercontacts_ida= '') WHERE contacts_tet1_passenger_c.deleted=0 AND test1_passenger.deleted=0::MySQL error 1146: Table 'sugarcrm.test1_passenger' doesn't exist

I thought this would be fairly easy to fix using phpmyadmin and just searching through all the tables for test1 and removing records ... well did that, found some, removed and no effect. Searched the sources for the same and it all seems to be in the cache folder ... so is there a safe way to 'flush' this and/or another way to quickly fix my screwup.

Cheers
/dan

[SugarDev.net]

Repair all from config?

[dansut]

Repair all from config?

Except I can't log in

OK, have move forward a little bit so here's some more info. The Home module seems to be the one that I have broken and I can actually get into other modules by manipulating the URL by hand. Doing this I was able to follow the above instructions and now instead of the above error accessing tables which no longer exist I now get:

Query Failed: ::MySQL error 1065: Query was empty

when I attempt to access the Home module as any user.

Any clues would be appreciated.

[dansut]

More info, this is what I get in the sugarcrm.log file:

Wed Oct  8 12:20:22 2008 [4519][1][FATAL] Error fetching relationship from cache contacts_test1_passenger
Wed Oct  8 12:20:22 2008 [4519][1][FATAL] MySQL error 1065: Query was empty

test1 was my test package and passenger was one of the custom modules inside it, if I go into the studio and try to look at the relationships it doesn't doing anything ... not even log an error.

I really would be grateful for any clues or suggestions with the goal of troubleshooting what I broke and learning how this all hangs together.
Cheers
/dan

[alearr]

Same problem here with relationship between two custom modules.

[dansut]

I am still interested in fixing this (as a learning exercise) but right now I have other priorities so I archived that install an DB and reinstalled. If anyone does have any hints of what to try or where to look I will do it and report back here ASAP but otherwise it'll stay archived until I have a slow day.

[alearr]

Solved:

1. delete the "cache" directory
2. Search for "relationship_name" (eg "contacts_test1_passenger") in all your Sugar dir
3. Delete any reference to the wrong relationship
4. Leave only the correct relationships (or create a new one)
5. Deploy

Hope this helps.
Reported with bug number 25414