Listview ROW_NUMBER() error

[MJBVrijmoed]

Hi,

in accounts when i use the next page button i receive the following error:

SQL Error : The column 'assigned_user_id' was specified multiple times for 'a'.

in sugarcrm.log i see this error

FATAL SugarCRM - The column 'assigned_user_id' was specified multiple times for 'a'.: SELECT TOP 21 * FROM
(
SELECT ROW_NUMBER() OVER (ORDER BY accounts.id) AS row_number, accounts.id , accounts_cstm.*, accounts.name , accounts.account_type , accounts.phone_office , accounts.assigned_user_id , accounts.assigned_user_id FROM accounts LEFT JOIN accounts_cstm ON accounts.id = accounts_cstm.id_c where accounts.deleted=0
) AS a
WHERE row_number > 20
02/19/08 21:58:09,513 [2344] FATAL SugarCRM - SQL Server error: The column 'assigned_user_id' was specified multiple times for 'a'.

When I remove the assigned_user_id from the listview it's working correctly.

Can anybody help me???

Windows 2003 Standard
SugarCRM OS 5
IIS 6
PHP 5.2.5
SQL Server 2005 Workgroup

[jungler]

In the /custom/modules/accounts/metadata/listviewdefs.php, try to comment out the following in the 'ASSIGNED_USER_NAME' array and rebuild

/* 'related_fields' =>
array (
0 => 'assigned_user_id',
),
*/

Although I dont know why but it works for me anyway. Good luck

[MJBVrijmoed]

Jungler,

that did the trick. You are officialy my hero of the day.

Thanx again!