Problems with Contacts (Dashlet not showing)

[dmontminy]

I have an install of SugarCRM (version: 5.5.4) that isn't working 100%

I get an error message in some of the contact where the dashlets would be:

Warning: require_once() [function.require-once]: Filename cannot be empty in /var/www/crm/data/SugarBean.php on line 3252

Fatal error: require_once() [function.require]: Failed opening required '' (include_path='/var/www/crm/include/..:.:/usr/lib/php5') in /var/www/crm/data/SugarBean.php on line 3

Line 3252 in SugarBean.php is related to the "retrieve_parent_fields($type_info)" function, more specifically the lines reads:

if(empty($templates[$child_info['parent_type']]))
{
      $class = $beanList[$child_info['parent_type']];
      require_once($beanFiles[$class]);
      $templates[$child_info['parent_type']] = new $class();
}

Nothing in sugarcrm.log looked suspicious, not even a single [Fatal] line to show where the problem was.

I have modified the code (trying to find out what type of argument passed creates an empty call to "require_once"):

if(empty($templates[$child_info['parent_type']]))
{
         $class = $beanList[$child_info['parent_type']];
         $GLOBALS['log']->debug("custom_out class: ".$class);
         $GLOBALS['log']->debug("custom_out child_info[parent_type]: ".$child_info['parent_type']);
          if(!empty($class))
          {
                   require_once($beanFiles[$class]);
                   $templates[$child_info['parent_type']] = new $class();
          }
}

Which make the error go away, but doesn't actually solves the root of the problem. The log line I added produces this output:

Mon Jan 17 17:16:32 2011 [2280][1][DEBUG] custom_out class: Account
Mon Jan 17 17:16:32 2011 [2280][1][DEBUG] custom_out child_info[parent_type]: Accounts
Mon Jan 17 17:16:32 2011 [2280][1][DEBUG] custom_out class: 
Mon Jan 17 17:16:32 2011 [2280][1][DEBUG] custom_out child_info[parent_type]: test

I'm not sure where to look for this "test" type. It's not in any "beanList" or "beanFile" in the files I "grep" up, yet it's mentioned somewhere because it produces the error message...

I have very little experience with SugarCRM or PHP. I'm not 100% sure what cause the problem, but nothing was ever modified outside of the Module Builder or the Studio. The code modifications I did to troubleshoot was in a local, VM-based install, a copy of our working installation. (We have valuable data in the production copy and I don't want to touch anything until I am 100% sure I have found the exact problem)

Any suggestions would be welcome...

[eggsurplus]

Sugar can't find the bean for your "test" module so it's bombing. Removing that module and any references to it should fix the problem.

[dmontminy]

The problem is, I don't have any "test" module installed. Since I'm not the one who did the install, I can't tell if and when that module was installed, but I can't find any traces of it anywhere.


Is there something I can do to try and find all references of that "ghost" module?

[eggsurplus]

Do a text search for "test" in the custom directory and you should find all references to it. After removing them do a Quick Repair & Rebuild.

Good luck!

[dmontminy]

A quick "grep -R test custom/*" got nothing except text references to "greatest" and "lastest". Searching the entire SugarCRM installation produce too much output to be of any use. (too much noise)

A "Quick Repair and Rebuilt", sadly, did not make the problem go away...

I wish I could simply re-install from scratch but I don't have all the "Export" or "Publish" files for the custom modules we have... (plus we have several dashlet that have been modified trough the studio since)

[eggsurplus]

I messed up. It would be in the database. There are several tables that have a parent_type column. One of them must have "test" as a value.

[dmontminy]

Thanks to phpmyadmin's option to search the entire database, I found 3 entries in 'email' that had parent_type and parent_id of 'test'

Clearing these from 'test' to NULL seems to make the problems go away. I'll push these changes into production. Now I only need to find out why these entries were like that... (make very little sense... especially since these are items from 2008...)

Thanks for the help!

[eggsurplus]

Great! Glad you were able to find it.