Hi,
When doing a list with advanced search (on joomla 1.0.13 and Community builder 1.1.0) i get no problems with firefox, displaying all the results, but no results in internet explorer (ver.6 or 7). This bug only happens when using the siple search2 in advanced search.
I get this results when debugging.
In Firefox (=Ok)
15
SELECT count(u.id) 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)16
SELECT count(u.id) 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) AND ( cb_postcode LIKE '%36%' )17
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) AND ( cb_postcode LIKE '%36%' ) ORDER BY `name` ASC LIMIT 0, 6018
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) AND ( cb_postcode LIKE '%36%' ) ORDER BY `name` ASC LIMIT 0, 6019
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) AND ( cb_postcode LIKE '%36%' ) ORDER BY `name` ASC
In Int. Explorer (= not Ok)
15
SELECT count(u.id) 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)
16
SELECT count(u.id) 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) AND ( u.id = 9999999999 )
17
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) AND ( u.id = 9999999999 ) ORDER BY `name` ASC LIMIT 0, 60
18
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) AND ( u.id = 9999999999 ) ORDER BY `name` ASC LIMIT 0, 60
19
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) AND ( u.id = 9999999999 ) ORDER BY `name` ASC
Can someone please help me with this?
Many thanks,
Dany
Post edited by: baucis, at: 2007/09/14 16:20
