No search results for Calls

[milkesd]

I know there are calls in the database, but no matter what I search on, I either get no results under the Call List section or the Call List section does not appear at all. I was having a problem with the Quick Create area because one of the fields was sticking into the main frame, so I added a php file to hide it, called view.sidequickcreate.php, on the advice of a senior member here. But I get the same problem with or without the Quick Create.

Using CE 5.5.0, Windows Server 2003, PHP version unknown.

Thanks.

[andopes]

Hi milkesd

Follow my tips here and let us know both query and error returned by your database.

Cheers

[milkesd]

The query is

SELECT calls.id ,calls_cstm.account_name_c,calls_cstm.contact_c, calls.status , calls.direction , calls.name , ISNULL(contacts.first_name,'') + ' ' + ISNULL(contacts.last_name,'') contact_name, jtl0.contact_id contact_id, calls.parent_id , calls.parent_type , calls.date_start , jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, calls.assigned_user_id FROM calls LEFT JOIN calls_cstm ON calls.id = calls_cstm.id_c LEFT JOIN calls_contacts jtl0 ON calls.id=jtl0.call_id AND jtl0.deleted=0 LEFT JOIN contacts contacts ON contacts.id=jtl0.contact_id AND contacts.deleted=0 AND contacts.deleted=0 LEFT JOIN users jt1 ON jt1.id= calls.assigned_user_id AND jt1.deleted=0 AND jt1.deleted=0 where ((calls.name like '%%')) AND calls.deleted=0

but I am running MSSQL, not MySQL, so I can't use phpMyAdmin. Do you know of an alternative for me? Running the query from my usual tool does not produce an error, which you probably expect.

Thanks.

[andopes]

I´m sure you can run this query on MSSQL manager in order to evaluate if this query is wrong.

Cheers

[milkesd]

Running MS SQL ServerMgt Studio, I do not get an error. I also noticed that if I search by subject '*' , the Mass Update and Call List sections appear, but no results, but if I try anything else I don't see anything.

I apologize that I have two threads for what is probably the same issue (see here). What are the possible global preferences that could be causing this?