Case Portal for Sugar 3.5.1 now available!

[julian]

Hello all,

Tonight we released a copy of the Case Portal (com_sugarcases) that's compatible with Sugar 3.5.1. It's available here:

http://sugarforge.org/frs/?group_id=10

Thanks,

[Hopkins]

Julian,
Many thanks for the Mambo portal integration. I am using this and encountering an error which appears to be due to the database schema being out of sync.

The error is:
Notice: Undefined index: team_id in C:\Program Files\Apache Group\Apache2\htdocs\mambo\components\com_sugarcas es\sugarcases.html.php on line 116

I have Sugar 3.5.1 installed with patch 3.5.1d
Mambo 4.5.2

From what I can tell, the code is looking for team_id and team_name in the accounts table. Using MySQL Admin I can see that neither of these fields exist on the accounts table.

I have added the following hack patch to overcome the error messages for now:

=== begin code snippet ===
foreach($columns['selected'] as $column) {
/* The following 2 if statements are a hack patch to overcome database schema bug - TPH Dec 7, 2005 */
if (strcmp($column['name'], "Team Id") == 0) continue;
if (strcmp($column['name'], "Team Name") == 0) continue;
list($inputWidget,$showme) = $this->_getAppropriateFormfield(
$tmpData[$column['field']]['type'],
$column,
$tmpCase[$column['field']],
$tmpData[$column['field']]['options']
);
if($showme) {
?>
<tr>
<td style="width: 20%; vertical-align: top;"><?php echo $column['name']; ?></td>
<td><?php echo $inputWidget ?></td>
</tr>
<?php
}
}
=== end code snippet ===

Can you please comment on the cause and possible permanent solution.

Many thanks,
Tom Hopkins