Error logging in and repairing database

[michaelssa]

Hi all,

My SugarCRM install is unusable, I'm using the latest public version of CE. I physically deleted a record in the database relating to a custom module ("ssaA_assets") and now have cooked my system.

I thought by removing the physical custom module aswell that it would correct itself but it has not, what can I do? Are there temporary tables I can flush to get my system working again...

Doing Admin > Repair > Quick Repair I get the following:

<!-- error below
Repair Database
Print Print Help Help
Processing database and vardef comparison...

Warning: require_once(modules/ssaA_assets/ssaA_assets.php) [function.require-once]: failed to open stream: No such file or directory in /home/websites/sugar/modules/Administration/repairDatabase.php on line 101

Fatal error: require_once() [function.require]: Failed opening required 'modules/ssaA_assets/ssaA_assets.php' (include_path='/home/websites/sugar/include/..:.:/usr/share/php:/usr/share/pear') in /home/websites/sugar/modules/Administration/repairDatabase.php on line 101
error above -->

and when logging in I get the following:

"Query Failed: AND users.id = '3ad88d84-6a94-1393-cbae-47df61b4a1a9'::MySQL error 1064: "

[eggsurplus]

Did you delete the record or did you delete the physical files in a folder? Or the table itself? If the record, what query did you use?

[clint]

Try running Repair Relationships from the Admin panel.