Me again,
I found 2 places where the query checked comprofiler_fields.name<>'NA' and changed them to check cb_fields.name<>'formatname' AND cb_fields.name<>'onlinestatus' and now the sql query hangs at ue.connection
[code:1]Unknown column 'ue.connections' in 'where clause' SQL=SELECT *, '' AS 'NA' FROM jos_users u, jos_comprofiler ue WHERE u.id=ue.id AND u.block!=1 and ue.approved=1 AND ue.banned=0 AND ue.confirmed=1 AND u.gid IN (29,19,20,21,18, 18, 19, 20, 21, 30,24,23,25, 23, 24, 25) AND ((LOWER(ue.avatar) LIKE '%a%' OR LOWER(ue.website) LIKE '%a%' OR LOWER(ue.cb_pbfamily) LIKE '%a%' OR LOWER(ue.company) LIKE '%a%' OR LOWER(ue.cb_pbkids) LIKE '%a%' OR LOWER(ue.cb_position) LIKE '%a%' OR LOWER(ue.cb_tagcloud) LIKE '%a%' OR LOWER(ue.cb_pblanguages) LIKE '%a%' OR LOWER(ue.cb_branch) ... <snip>[/code:1]
What did you change when updating cb? What I see is that in comprofiler_fields there is a new one called connections which was not there before. Maybe because the new type? Hm.. any api docs, changes around? Or better info, docs how new cb 1.2 search can be used to build a new component