Advance search is not working

SuiteCRM Forum - Spanish Language SuiteCRM 7.0 Discusión General
1

When I update suitecrm version 7.7.1 to 7.7.7 , Advance search is not working now.
What to do?

2

Hello

Not working, you mean the UI part or it is not returning any result ?

If it is about return result, check out the suitecrm.log on root of the web, you will get idea what went wrong.

3

Hi,

It does not return any output, eg. when I select “assigned to” from drop down of advance search it says No result found. And these are the errors in log.

AND jt0.deleted=0 where ((accounts.assigned_user_id in (2df8ca2e-8216-eccf-f8d6-57d23f597fc1))) AND accounts.deleted=0 ORDER BY accounts.name ASC LIMIT 0,21: MySQL error 1054: Unknown column ‘2df8ca2e’ in ‘where clause’
11/21/16 10:11:23 [5768][1][FATAL] Query Failed: SELECT accounts.id , accounts.assigned_user_id , accounts.name , accounts.billing_address_city , accounts.billing_address_country , accounts.phone_office , jt0.user_name assigned_user_name , jt0.created_by assigned_user_name_owner , ‘Users’ assigned_user_name_mod, accounts.date_entered , accounts.created_by FROM accounts LEFT JOIN accounts_cstm ON accounts.id = accounts_cstm.id_c LEFT JOIN users jt0 ON accounts.assigned_user_id=jt0.id AND jt0.deleted=0

AND jt0.deleted=0 where ((accounts.assigned_user_id in (2df8ca2e-8216-eccf-f8d6-57d23f597fc1))) AND accounts.deleted=0 ORDER BY accounts.name ASC LIMIT 0,21: MySQL error 1054: Unknown column ‘2df8ca2e’ in ‘where clause’
11/21/16 10:14:23 [5768][1][FATAL] Query Failed: SELECT accounts.id , accounts.assigned_user_id , accounts.name , accounts.billing_address_city , accounts.billing_address_country , accounts.phone_office , jt0.user_name assigned_user_name , jt0.created_by assigned_user_name_owner , ‘Users’ assigned_user_name_mod, accounts.date_entered , accounts.created_by FROM accounts LEFT JOIN accounts_cstm ON accounts.id = accounts_cstm.id_c LEFT JOIN users jt0 ON accounts.assigned_user_id=jt0.id AND jt0.deleted=0

AND jt0.deleted=0 where ((accounts.assigned_user_id in (ead08aa2-c977-ff2d-1a6a-57e0cc1ae459))) AND accounts.deleted=0 ORDER BY accounts.name LIMIT 0,21: MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘cc1ae459))) AND accounts.deleted=0 ORDER BY accounts.name LIMIT 0,21’ at line 3
11/21/16 10:14:41 [5768][1][FATAL] Query Failed: SELECT accounts.id , accounts.assigned_user_id , accounts.name , accounts.billing_address_city , accounts.billing_address_country , accounts.phone_office , jt0.user_name assigned_user_name , jt0.created_by assigned_user_name_owner , ‘Users’ assigned_user_name_mod, accounts.date_entered , accounts.created_by FROM accounts LEFT JOIN accounts_cstm ON accounts.id = accounts_cstm.id_c LEFT JOIN users jt0 ON accounts.assigned_user_id=jt0.id AND jt0.deleted=0

AND jt0.deleted=0 where ((accounts.assigned_user_id in (4f1a08f9-6391-6ff1-f079-57ada3efdd51))) AND accounts.deleted=0 ORDER BY accounts.name ASC LIMIT 0,21: MySQL error 1054: Unknown column ‘4f1a08f9’ in ‘where clause’
11/21/16 10:14:56 [5768][1][FATAL] Query Failed: SELECT accounts.id , accounts.assigned_user_id , accounts.name , accounts.billing_address_city , accounts.billing_address_country , accounts.phone_office , jt0.user_name assigned_user_name , jt0.created_by assigned_user_name_owner , ‘Users’ assigned_user_name_mod, accounts.date_entered , accounts.created_by FROM accounts LEFT JOIN accounts_cstm ON accounts.id = accounts_cstm.id_c LEFT JOIN users jt0 ON accounts.assigned_user_id=jt0.id AND jt0.deleted=0

AND jt0.deleted=0 where ((accounts.assigned_user_id in (2df8ca2e-8216-eccf-f8d6-57d23f597fc1))) AND accounts.deleted=0 ORDER BY accounts.name ASC LIMIT 0,21: MySQL error 1054: Unknown column ‘2df8ca2e’ in ‘where clause’
11/21/16 10:15:53 [5768][1][FATAL] Query Failed: SELECT accounts.id , accounts.assigned_user_id , accounts.name , accounts.billing_address_city , accounts.billing_address_country , accounts.phone_office , jt0.user_name assigned_user_name , jt0.created_by assigned_user_name_owner , ‘Users’ assigned_user_name_mod, accounts.date_entered , accounts.created_by FROM accounts LEFT JOIN accounts_cstm ON accounts.id = accounts_cstm.id_c LEFT JOIN users jt0 ON accounts.assigned_user_id=jt0.id AND jt0.deleted=0

AND jt0.deleted=0 where ((accounts.assigned_user_id in (4f1a08f9-6391-6ff1-f079-57ada3efdd51))) AND accounts.deleted=0 ORDER BY accounts.name LIMIT 0,21: MySQL error 1054: Unknown column ‘4f1a08f9’ in ‘where clause’
11/21/16 10:16:16 [5768][1][FATAL] Query Failed: SELECT accounts.id , accounts.assigned_user_id , accounts.name , accounts.billing_address_city , accounts.billing_address_country , accounts.phone_office , jt0.user_name assigned_user_name , jt0.created_by assigned_user_name_owner , ‘Users’ assigned_user_name_mod, accounts.date_entered , accounts.account_type , accounts.created_by FROM accounts LEFT JOIN accounts_cstm ON accounts.id = accounts_cstm.id_c LEFT JOIN users jt0 ON accounts.assigned_user_id=jt0.id AND jt0.deleted=0

AND jt0.deleted=0 where ((accounts.account_type in (Customer))) AND accounts.deleted=0 ORDER BY accounts.name ASC LIMIT 0,21: MySQL error 1054: Unknown column ‘Customer’ in ‘where clause’
11/21/16 10:19:11 [5768][1][FATAL] Query Failed: SELECT accounts.id , accounts.assigned_user_id , accounts.name , accounts.billing_address_city , accounts.billing_address_country , accounts.phone_office , jt0.user_name assigned_user_name , jt0.created_by assigned_user_name_owner , ‘Users’ assigned_user_name_mod, accounts.date_entered , accounts.created_by FROM accounts LEFT JOIN accounts_cstm ON accounts.id = accounts_cstm.id_c LEFT JOIN users jt0 ON accounts.assigned_user_id=jt0.id AND jt0.deleted=0

AND jt0.deleted=0 where ((accounts.assigned_user_id in (441102f6-ced5-9c01-b39f-57fbb197a713))) AND accounts.deleted=0 ORDER BY accounts.name ASC LIMIT 0,21: MySQL error 1054: Unknown column ‘441102f6’ in ‘where clause’

4

hey,
It solved after again updation of 7.7.8 version :cheer:

5

Great!

6

Thank you, for your quick replies… :slight_smile:

7

I have a one more query,
I want an email notification of meeting acceptance and declination of members.
How to do this?

8

I mean to say that if invitee accept or decline the meeting an email should be receive to the sender of that meeting, like xyz decline the meeting request.
Is this possible?