soap + query not working

[lauren198]

hi all.

i have a problem with sugar nuSoap.
i can't do any query on 'get_entry_list'. i already checked the permission, and but it still not working.
there are no any error message, and no any responds. i don't know why..

if i list the it not using query, it's working fine.

This is not working with query string:

 $fields = array('id','user_name','phone_fax');
$sql = "users.user_name like '%a%'";
 
$param = array(
                                'session'=>$this->con['id'],
                                'module_name'=>'Users',
                                'query'=>$sql, 
                                'order_by'=>'',  
                                'offset'=>0, 
                                'select_fields'=>$fields,
                                'max_results'=>$count, 
                                'deleted'=>0);
$result = $this->call('get_entry_list',$param); 
  

This is working without query string:

 $fields = array('id','user_name','phone_fax');
$sql = "";
 
$param = array(
                                'session'=>$this->con['id'],
                                'module_name'=>'Users',
                                'query'=>$sql,
                                'order_by'=>'',  
                                'offset'=>0, 
                                'select_fields'=>$fields,
                                'max_results'=>$count, 
                                'deleted'=>0);
                $result = $this->call('get_entry_list',$param); 
  

any body ever get this problem. ?? please help me..

thanks before.

best regards,

lauren

[crmbalah]

Hi
user the following code

$fields = array('id','user_name','phone_fax');
$sql = "user_name like '%a%'";

$param = array(
                                'session'=>$this->con['id'],
                                'module_name'=>'Users',
                                'query'=>$sql, 
                                'order_by'=>'',  
                                'offset'=>0, 
                                'select_fields'=>$fields,
                                'max_results'=>$count, 
                                'deleted'=>0);
$result = $this->call('get_entry_list',$param);

just change the users.user_name to user_name

[lauren198]

thanks crmbalah for you reply,

i already try that. n it still not working.

i've used
"table"."field"
"field"
change "LIKE" become "=", using the full sql statement.
i also try using the proxy, but it still not working. have any idea??

regard,

lauren.

[r4ccoon]

yeah. it happens to me too.
the same code i ve tested on the different server. it was working good.
when we moved to our new server, all the code is working
except that get_entry_list with query parameter in it.

is there anything i have to set in the sugar option
or any php.ini setting or any weird options?

[lauren198]

anyone can help me and r4ccoon ??

i'm running it on linux-fedora 10. i already try it to 3 difference fedora server, but it still not working.

any configuration of sugar or php or apache should i change??
i already put the full permission to sugar. but still not working..

anyone (Master, Admin, Senior, developer) help me please...

regards,

lauren

[lauren198]

fixed now...

sugar error, not server, apache, php, or permission problem.

thanks for spiderglobe:
http://www.sugarcrm.com/forums/showthread.php?t=47007

thanks all for not reply..