Error is coming on SugarBean

[chetanvalueone]

Hi All,

I am getting this error again and again please help me out. this error is coming on Assigned To pop-up window.

Warning: Invalid argument supplied for foreach() in C:\wamp\www\karepartners_v2\data\SugarBean.php on line 613

Thanks,
Chetan

[genius786]

Hi,

What do you want to do .... Please tell me and where you perform changing. I think after it i m able to give you some tips and suggestion


Best regards,

[chetanvalueone]

i have changes in modules/Users/metadata/popupdefs.php

origional query was:
$popupMeta = array(
'moduleMain' => 'User',
'varName' => 'USER',
'orderBy' => 'user_name',
'whereClauses' => array(
'first_name' => 'users.first_name',
'last_name' => 'users.last_name',
'user_name' => 'users.user_name',
'is_group' => 'users.is_group'
),
'whereStatement'=> " users.status = 'Active'",
'searchInputs' => array(
'first_name',
'last_name',
'user_name',
'is_group'
),
);

my modified query is:

$popupMeta = array(
'moduleMain' => 'User',
'varName' => 'USER',
'orderBy' => 'user_name',
'whereClauses' => array(
'first_name' => 'users.first_name',
'last_name' => 'users.last_name',
'user_name' => 'users.user_name',
'is_group' => 'users.is_group',
'account_name' => 'users.account_name',
),
'whereStatement'=> " users.status = 'Active' and users.id in ($userlist) ",
'searchInputs' => array(
'first_name',
'last_name',
'user_name',
'is_group',
'account_name'
),
);

actually i have added "and users.id in ($userlist)" into where statement,

now i am getting this error

[SugarDev.net]

obviously, we're going to need the $userlist declaration.

And your SQL is not very neat if I may say so.