error on calls dashlet

[sidh211]

hi
i am using sugar 4.5.1i ce

we have added some fields in calls table but now when i click on NEXT button in the dashlet it gives an SQL error of
SQL Error : Incorrect syntax near '*'.
this is the sugal.log file contents.


FATAL SugarCRM - Incorrect syntax near '*'.: SELECT TOP 6 * FROM
(
SELECT ROW_NUMBER() OVER (ORDER BY calls.id) AS row_number, count(*) counter, calls.id , calls_cstm.*, calls.status , calls.name , calls.duration_hours , calls.duration_minutes , calls.date_start , calls.time_start , calls.assigned_user_id
from calls left join calls_cstm on calls.id = calls_cstm.id_c inner join calls_users on calls.id = calls_users.call_id where ((calls.status in ('planned')
)) and calls.deleted=0 and calls_users.deleted = 0 and (calls.assigned_user_id = '1' or calls_users.user_id = '1')
group by calls.id, calls_cstm.*, calls.status, calls.name, calls.duration_hours, calls.duration_minutes, calls.date_start, calls.time_start, calls.assigned_user_id
) AS a
WHERE row_number > 5
07/03/08 09:02:21,955 [1988] INFO SugarCRM - Query Execution Time:0.001204
07/03/08 09:02:21,955 [1988] FATAL SugarCRM - SQL Server error: Incorrect syntax near '*'.
07/03/08 09:02:21,984 [1988] DEBUG SugarCRM - ---------> END INCLUDING REQUESTED PAGE: [modules/Home/DisplayDashlet.php] <------------

[eggsurplus]

Were you able to resolve this? We're getting the same thing. Has something to do with custom fields in Calls although our other modules have custom fields and their dashlets works just fine.

[sidh211]

if you have intalled Teams module??
then just change in modules/calls/dashlets/mycallsdashlt.php
if($this->myItemsOnly) { // handle myitems only differently
$lvsParams = array(
'custom_from' => ' INNER JOIN calls_users ON calls.id = calls_users.call_id ',
'custom_where' => ' AND calls_users.deleted = 0 AND (calls.assigned_user_id = \'' . $current_user->id . '\' OR calls_users.user_id = \'' . $current_user->id . '\') ',
'distinct' => true

change above code to

if($this->myItemsOnly) { // handle myitems only differently
$lvsParams = array(
'custom_from' => ' INNER JOIN calls_users ON calls.id = calls_users.call_id ',
'custom_where' => ' AND calls_users.deleted = 0 AND (calls.assigned_user_id = \'' . $current_user->id . '\' AND calls_users.user_id = \'' . $current_user->id . '\') ',
// 'distinct' => true