Module test results in many "Invalid argument supplied for foreach()" warnings

[StewRat]

I had a dry run at creating a very simple module.

After deploying it, I started to get many warnings scattered around. They appear in most of the standard modules (eg accounts) once at the top of the subpanel listings, then above and below the leads subpanel.

Warning: Invalid argument supplied for foreach() in /home/virtual/site10/fst/var/www/html/data/SugarBean.php on line 599

The home page shows nothing but the warning, and the leads module shows a lot of these errors (and other line numbers) and is really messed up with no leads showing.

I should say my custom module had nothing to do with leads.

I deleted the module, but the warnings remain.

I have gone through I think all the admin repair options to no effect - in fact the same warning appears within some of the repair reports, usually around anything to do with leads.

Looking at the database in phpMyAdmin, there seems to be nothing obviously corrupted in leads or leads_audit tables, but I see all the tables from my (deleted) module are still there, plus the relationship (with accounts) is still in the relationships table.

Desperately need to get this fixed, but dont want to start flailinga round and make things worse. Any suggestions?

Thanks in advance.

[StewRat]

Found a bit more detail in the log file that seems to suggest that the leads page is causing errors like:

Fri 20 Nov 2009 04:18:36 PM CST,800 [32601] FATAL SugarCRM - createRelationshipMeta: Metadata for table leads does not exist

Doing relationship repair in admin doesnt help.