Skip to Content Skip to Menu

🕒 Save Time and Effort with CB Editor Assistant: Effortlessly create and refine content in Joomla 3, 4, & 5.
🎁 Limited Offer: Enjoy a 5-day FREE trial and save up to 30% afterward!

[SOLVED] Strange result for query field

  • fribse2011
  • fribse2011
  • OFFLINE
  • Posts: 921
  • Thanks: 79
  • Karma: 8
12 years 5 months ago - 12 years 2 months ago #207758 by fribse2011
[SOLVED] Strange result for query field was created by fribse2011
I have a query field set up here, so that when users give a postal code, it fills in the city.
This is a simple table with number and city in two fields.
This seems to work most of the time with this in the query field:
cb_by = SELECT `by` FROM `kef_postnumre` WHERE `nr` = '[cb_postnummer]'
This gives me the city from the postal code.
I then use a delimiter field to combine the two:
postnrby = [cb_postnummer] [cb_by]

This returns a valid result until the postnr is empty on a list, after that it fails:



If I go to the individual user profiles, it will show the correct city for the postcode.
So the query works on the individual records, but if it fails on a list, then it fails for the rest of the page of the list (the next page starts with working again, until postnr is empty again)

Best regards
Fribse

Frømandsklubben Nikon, www.nikondyk.dk
We're a volunteer driven diving club in Ishøj, Denmark.
Har du brug for en dykkerklub der rummer alle, så kom ned til os.
Attachments:
Last edit: 12 years 2 months ago by krileon.

Please Log in or Create an account to join the conversation.

  • krileon
  • krileon
  • ONLINE
  • Posts: 48708
  • Thanks: 8319
  • Karma: 1447
12 years 5 months ago #207807 by krileon
Replied by krileon on topic Re: Strange result for query field
Strange, can't see any reason in source why it'd do this. It would cause an error if the query wasn't escaped, but it looks escaped properly. Please enable debug mode and maximum error reporting in Joomla global configuration then view your userlist to see if a fatal error occurs.


Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

Please Log in or Create an account to join the conversation.

  • fribse2011
  • fribse2011
  • OFFLINE
  • Posts: 921
  • Thanks: 79
  • Karma: 8
12 years 5 months ago #207830 by fribse2011
Replied by fribse2011 on topic Re: Strange result for query field
I don't see anything strange in it, and no errors shown, I wonder if admintools can play tricks here???
Code:
[0.0000s] DEBUG info j4age: Visit time in Joomla Local timezone: 2012-08-14 16:15:33 Performed SQL enquiries SELECT `data` FROM `kef_session` WHERE `session_id` = '4d996bf871fb7f8670c3921866130489' SELECT `enabled` FROM `kef_extensions` WHERE `element` = 'com_akeeba' AND `type` = 'component' SELECT `value` FROM `kef_admintools_storage` WHERE `key` = 'cparams' SELECT `query` FROM `kef_admintools_wafexceptions` WHERE (`option` IS NULL OR `option` = '') AND (`view` IS NULL OR `view` = '') GROUP BY `query` ORDER BY `query` ASC SELECT * FROM `kef_admintools_ipautoban` WHERE `ip` = '83.89.3.64' SELECT `value` FROM `kef_admintools_storage` WHERE `key` = 'cparams' SELECT `id` FROM `kef_users` WHERE `lastvisitDate` = '0000-00-00 00:00:00' AND `registerDate` <= DATE_SUB(NOW(), INTERVAL 14 DAY) AND `activation` != '' LIMIT 0, 5 SELECT `source` FROM `kef_admintools_redirects` WHERE (`dest` = 'component/comprofiler/userslist/Medlemsliste (Alle).html') OR (`dest` = 'component/comprofiler/userslist/Medlemsliste (Alle).html?Itemid=825') AND `published` = '1' ORDER BY `ordering` DESC LIMIT 0, 1 SELECT * FROM `kef_admintools_storage` WHERE `key` LIKE 'timestamp_%' SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component FROM kef_menu AS m LEFT JOIN kef_extensions AS e ON m.component_id = e.extension_id WHERE m.published = 1 AND m.parent_id > 0 AND m.client_id = 0 ORDER BY m.lft SELECT listid FROM kef_comprofiler_lists WHERE title = 'Medlemsliste (Alle)' AND published = 1 LIMIT 0, 2 SHOW FULL COLUMNS FROM `kef_autotweet_automator` SELECT * FROM kef_autotweet_automator WHERE `id` = 'content' SELECT * FROM kef_autotweet_automator WHERE `id` = 'automator' SELECT params FROM kef_extensions WHERE `element`='com_regreminder' SHOW FULL COLUMNS FROM `kef_users` SELECT c.*, u.* FROM kef_users AS u LEFT JOIN kef_comprofiler AS c ON c.id = u.id WHERE u.id = 75 SELECT a.id FROM kef_user_usergroup_map AS map LEFT JOIN kef_usergroups AS a ON a.id = map.group_id WHERE map.user_id = 75 SELECT * FROM `kef_usergroups` ORDER BY `lft` SELECT parent.id, parent.lft, parent.rgt FROM kef_usergroups AS parent ORDER BY parent.lft SELECT b.rules FROM kef_assets AS a LEFT JOIN kef_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.id = 1 OR a.parent_id=0) GROUP BY b.id, b.rules, b.lft ORDER BY b.lft SELECT b.id FROM kef_user_usergroup_map AS map LEFT JOIN kef_usergroups AS a ON a.id = map.group_id LEFT JOIN kef_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE map.user_id = 75 SELECT a.`id` AS value, a.`title` AS text, COUNT( DISTINCT b.`id` ) AS level FROM `kef_usergroups` AS a LEFT JOIN `kef_usergroups` AS b ON a.`lft` > b.`lft` AND a.`rgt` < b.`rgt` GROUP BY a.`id` ORDER BY a.`lft` ASC SELECT listid, title FROM kef_comprofiler_lists WHERE published=1 AND viewaccesslevel IN (1,2,3,4,5,6) AND useraccessgroupid IN (-2,-1,1,2,9,12,43,11,19,16) ORDER BY ordering SELECT * FROM `kef_comprofiler_lists` WHERE `listid` = '11' SELECT id, folder, element, published, type, params, CONCAT_WS('/',folder,element) AS lookup, name FROM kef_comprofiler_plugin WHERE published = 1 AND access IN (0,1,2,4,5,6) AND type = 'user' ORDER BY ordering SELECT * FROM `kef_comprofiler_plugin` WHERE `element` = 'cbautoactions' SELECT * FROM `kef_comprofiler_plugin_autoactions` WHERE ( `published` = 1 ) ORDER BY `ordering` ASC SELECT * FROM `kef_comprofiler_plugin` WHERE `element` = 'cbforums' SELECT * FROM `kef_comprofiler_tabs` WHERE `pluginid` = 544 SELECT * FROM kef_kunena_configuration WHERE id=1 SELECT f.* FROM kef_comprofiler_fields f INNER JOIN kef_comprofiler_tabs AS t ON (f.tabid = t.tabid) WHERE ( f.published = 1 OR f.name = 'name' ) AND ( f.profile != 0 OR f.name = 'username' OR f.name = 'name') AND t.enabled = 1 AND t.viewaccesslevel IN (1,2,3,4,5,6) AND t.useraccessgroupid IN (-2,-1,1,2,9,12,43,11,19,16) ORDER BY t.position, t.ordering, f.ordering SELECT * FROM `kef_comprofiler_plugin` WHERE `element` = 'cbconditional' SELECT COUNT(DISTINCT u.id) FROM kef_users u JOIN kef_user_usergroup_map g ON g.`user_id` = u.`id` JOIN kef_comprofiler ue ON ue.`id` = u.`id` WHERE u.block = 0 AND ue.approved = 1 AND ue.confirmed = 1 AND g.group_id IN (9, 12, 11, 31, 17, 19, 15, 16, 32, 38) SELECT DISTINCT ue.*, u.*, '' AS 'NA' FROM kef_users u JOIN kef_user_usergroup_map g ON g.`user_id` = u.`id` JOIN kef_comprofiler ue ON ue.`id` = u.`id` WHERE u.block = 0 AND ue.approved = 1 AND ue.confirmed = 1 AND g.group_id IN (9, 12, 11, 31, 17, 19, 15, 16, 32, 38) ORDER BY `name` ASC, `cb_postnummer` ASC, `cb_adresse` ASC LIMIT 0, 30 SELECT a.id FROM kef_user_usergroup_map AS map LEFT JOIN kef_usergroups AS a ON a.id = map.group_id WHERE map.user_id = 93 SELECT a.id FROM kef_user_usergroup_map AS map LEFT JOIN kef_usergroups AS a ON a.id = map.group_id WHERE map.user_id = 102 SELECT a.id FROM kef_user_usergroup_map AS map LEFT JOIN kef_usergroups AS a ON a.id = map.group_id WHERE map.user_id = 79 SELECT a.id FROM kef_user_usergroup_map AS map LEFT JOIN kef_usergroups AS a ON a.id = map.group_id WHERE map.user_id = 126 SELECT a.id FROM kef_user_usergroup_map AS map LEFT JOIN kef_usergroups AS a ON a.id = map.group_id WHERE map.user_id = 160 SELECT a.id FROM kef_user_usergroup_map AS map LEFT JOIN kef_usergroups AS a ON a.id = map.group_id WHERE map.user_id = 145 SELECT a.id FROM kef_user_usergroup_map AS map LEFT JOIN kef_usergroups AS a ON a.id = map.group_id WHERE map.user_id = 106 SELECT a.id FROM kef_user_usergroup_map AS map LEFT JOIN kef_usergroups AS a ON a.id = map.group_id WHERE map.user_id = 186 SELECT a.id FROM kef_user_usergroup_map AS map LEFT JOIN kef_usergroups AS a ON a.id = map.group_id WHERE map.user_id = 60 SELECT a.id FROM kef_user_usergroup_map AS map LEFT JOIN kef_usergroups AS a ON a.id = map.group_id WHERE map.user_id = 141 SELECT a.id FROM kef_user_usergroup_map AS map LEFT JOIN kef_usergroups AS a ON a.id = map.group_id WHERE map.user_id = 179 SELECT a.id FROM kef_user_usergroup_map AS map LEFT JOIN kef_usergroups AS a ON a.id = map.group_id WHERE map.user_id = 105 SELECT a.id FROM kef_user_usergroup_map AS map LEFT JOIN kef_usergroups AS a ON a.id = map.group_id WHERE map.user_id = 84 SELECT a.id FROM kef_user_usergroup_map AS map LEFT JOIN kef_usergroups AS a ON a.id = map.group_id WHERE map.user_id = 114 SELECT a.id FROM kef_user_usergroup_map AS map LEFT JOIN kef_usergroups AS a ON a.id = map.group_id WHERE map.user_id = 174 SELECT a.id FROM kef_user_usergroup_map AS map LEFT JOIN kef_usergroups AS a ON a.id = map.group_id WHERE map.user_id = 159 SELECT a.id FROM kef_user_usergroup_map AS map LEFT JOIN kef_usergroups AS a ON a.id = map.group_id WHERE map.user_id = 104 SELECT a.id FROM kef_user_usergroup_map AS map LEFT JOIN kef_usergroups AS a ON a.id = map.group_id WHERE map.user_id = 99 SELECT a.id FROM kef_user_usergroup_map AS map LEFT JOIN kef_usergroups AS a ON a.id = map.group_id WHERE map.user_id = 101 SELECT a.id FROM kef_user_usergroup_map AS map LEFT JOIN kef_usergroups AS a ON a.id = map.group_id WHERE map.user_id = 81 SELECT a.id FROM kef_user_usergroup_map AS map LEFT JOIN kef_usergroups AS a ON a.id = map.group_id WHERE map.user_id = 183 SELECT a.id FROM kef_user_usergroup_map AS map LEFT JOIN kef_usergroups AS a ON a.id = map.group_id WHERE map.user_id = 98 SELECT a.id FROM kef_user_usergroup_map AS map LEFT JOIN kef_usergroups AS a ON a.id = map.group_id WHERE map.user_id = 173 SELECT a.id FROM kef_user_usergroup_map AS map LEFT JOIN kef_usergroups AS a ON a.id = map.group_id WHERE map.user_id = 115 SELECT a.id FROM kef_user_usergroup_map AS map LEFT JOIN kef_usergroups AS a ON a.id = map.group_id WHERE map.user_id = 91 SELECT a.id FROM kef_user_usergroup_map AS map LEFT JOIN kef_usergroups AS a ON a.id = map.group_id WHERE map.user_id = 140 SELECT a.id FROM kef_user_usergroup_map AS map LEFT JOIN kef_usergroups AS a ON a.id = map.group_id WHERE map.user_id = 80 SELECT a.id FROM kef_user_usergroup_map AS map LEFT JOIN kef_usergroups AS a ON a.id = map.group_id WHERE map.user_id = 78 SELECT a.id FROM kef_user_usergroup_map AS map LEFT JOIN kef_usergroups AS a ON a.id = map.group_id WHERE map.user_id = 150 SELECT id, folder, element, published, type, params, CONCAT_WS('/',folder,element) AS lookup, name FROM kef_comprofiler_plugin WHERE published = 1 AND access IN (0,1,2,4,5,6) AND type = 'templates' ORDER BY ordering SELECT f.* FROM kef_comprofiler_fields f INNER JOIN kef_comprofiler_tabs AS t ON (f.tabid = t.tabid) WHERE f.published = 1 AND t.enabled = 1 AND t.viewaccesslevel IN (1,2,3,4,5,6) AND t.useraccessgroupid IN (-2,-1,1,2,9,12,43,11,19,16) ORDER BY t.position, t.ordering, f.ordering SELECT id FROM kef_menu WHERE link = 'index.php?option=com_comprofiler' AND published = 1 AND access IN (1,2,3,4,5,6) AND `language` IN ( 'da-DK', '*', '' ) SELECT username FROM kef_users WHERE id = 93 LIMIT 0, 1 SELECT f.* FROM kef_comprofiler_fields f INNER JOIN kef_comprofiler_tabs AS t ON (f.tabid = t.tabid) WHERE f.published = 1 ORDER BY t.position, t.ordering, f.ordering SELECT `by` FROM `kef_postnumre` WHERE `nr` = '2625' SELECT * FROM `kef_comprofiler_privacy` WHERE `userid` = 93 ORDER BY `type`, `xid` SELECT username FROM kef_users WHERE id = 102 LIMIT 0, 1 SELECT `by` FROM `kef_postnumre` WHERE `nr` = '' SELECT * FROM `kef_comprofiler_privacy` WHERE `userid` = 102 ORDER BY `type`, `xid` SELECT username FROM kef_users WHERE id = 79 LIMIT 0, 1 SELECT `by` FROM `kef_postnumre` WHERE `nr` = '2670' SELECT * FROM `kef_comprofiler_privacy` WHERE `userid` = 79 ORDER BY `type`, `xid` SELECT username FROM kef_users WHERE id = 126 LIMIT 0, 1 SELECT `by` FROM `kef_postnumre` WHERE `nr` = '2680' SELECT * FROM `kef_comprofiler_privacy` WHERE `userid` = 126 ORDER BY `type`, `xid` SELECT username FROM kef_users WHERE id = 160 LIMIT 0, 1 SELECT `by` FROM `kef_postnumre` WHERE `nr` = '2605' SELECT * FROM `kef_comprofiler_privacy` WHERE `userid` = 160 ORDER BY `type`, `xid` SELECT username FROM kef_users WHERE id = 145 LIMIT 0, 1 SELECT `by` FROM `kef_postnumre` WHERE `nr` = '2670' SELECT * FROM `kef_comprofiler_privacy` WHERE `userid` = 145 ORDER BY `type`, `xid` SELECT username FROM kef_users WHERE id = 106 LIMIT 0, 1 SELECT `by` FROM `kef_postnumre` WHERE `nr` = '2630' SELECT * FROM `kef_comprofiler_privacy` WHERE `userid` = 106 ORDER BY `type`, `xid` SELECT username FROM kef_users WHERE id = 186 LIMIT 0, 1 SELECT `by` FROM `kef_postnumre` WHERE `nr` = '2610' SELECT * FROM `kef_comprofiler_privacy` WHERE `userid` = 186 ORDER BY `type`, `xid` SELECT f.* FROM kef_comprofiler_fields f INNER JOIN kef_comprofiler_tabs AS t ON (f.tabid = t.tabid) WHERE f.published = 1 AND f.profile != 0 AND t.enabled = 1 AND t.viewaccesslevel IN (1,2,3,4,5,6) AND t.useraccessgroupid IN (-2,-1,1,2,9,12,43,11,19,16) ORDER BY t.position, t.ordering, f.ordering SELECT username FROM kef_users WHERE id = 60 LIMIT 0, 1 SELECT * FROM `kef_comprofiler_privacy` WHERE `userid` = 60 ORDER BY `type`, `xid` SELECT username FROM kef_users WHERE id = 141 LIMIT 0, 1 SELECT * FROM `kef_comprofiler_privacy` WHERE `userid` = 141 ORDER BY `type`, `xid` SELECT username FROM kef_users WHERE id = 179 LIMIT 0, 1 SELECT * FROM `kef_comprofiler_privacy` WHERE `userid` = 179 ORDER BY `type`, `xid` SELECT username FROM kef_users WHERE id = 105 LIMIT 0, 1 SELECT * FROM `kef_comprofiler_privacy` WHERE `userid` = 105 ORDER BY `type`, `xid` SELECT username FROM kef_users WHERE id = 84 LIMIT 0, 1 SELECT * FROM `kef_comprofiler_privacy` WHERE `userid` = 84 ORDER BY `type`, `xid` SELECT username FROM kef_users WHERE id = 114 LIMIT 0, 1 SELECT * FROM `kef_comprofiler_privacy` WHERE `userid` = 114 ORDER BY `type`, `xid` SELECT username FROM kef_users WHERE id = 174 LIMIT 0, 1 SELECT * FROM `kef_comprofiler_privacy` WHERE `userid` = 174 ORDER BY `type`, `xid` SELECT username FROM kef_users WHERE id = 159 LIMIT 0, 1 SELECT * FROM `kef_comprofiler_privacy` WHERE `userid` = 159 ORDER BY `type`, `xid` SELECT username FROM kef_users WHERE id = 104 LIMIT 0, 1 SELECT * FROM `kef_comprofiler_privacy` WHERE `userid` = 104 ORDER BY `type`, `xid` SELECT username FROM kef_users WHERE id = 99 LIMIT 0, 1 SELECT * FROM `kef_comprofiler_privacy` WHERE `userid` = 99 ORDER BY `type`, `xid` SELECT username FROM kef_users WHERE id = 101 LIMIT 0, 1 SELECT * FROM `kef_comprofiler_privacy` WHERE `userid` = 101 ORDER BY `type`, `xid` SELECT username FROM kef_users WHERE id = 81 LIMIT 0, 1 SELECT * FROM `kef_comprofiler_privacy` WHERE `userid` = 81 ORDER BY `type`, `xid` SELECT username FROM kef_users WHERE id = 183 LIMIT 0, 1 SELECT * FROM `kef_comprofiler_privacy` WHERE `userid` = 183 ORDER BY `type`, `xid` SELECT username FROM kef_users WHERE id = 98 LIMIT 0, 1 SELECT * FROM `kef_comprofiler_privacy` WHERE `userid` = 98 ORDER BY `type`, `xid` SELECT username FROM kef_users WHERE id = 173 LIMIT 0, 1 SELECT * FROM `kef_comprofiler_privacy` WHERE `userid` = 173 ORDER BY `type`, `xid` SELECT username FROM kef_users WHERE id = 115 LIMIT 0, 1 SELECT * FROM `kef_comprofiler_privacy` WHERE `userid` = 115 ORDER BY `type`, `xid` SELECT username FROM kef_users WHERE id = 91 LIMIT 0, 1 SELECT * FROM `kef_comprofiler_privacy` WHERE `userid` = 91 ORDER BY `type`, `xid` SELECT username FROM kef_users WHERE id = 140 LIMIT 0, 1 SELECT * FROM `kef_comprofiler_privacy` WHERE `userid` = 140 ORDER BY `type`, `xid` SELECT username FROM kef_users WHERE id = 80 LIMIT 0, 1 SELECT * FROM `kef_comprofiler_privacy` WHERE `userid` = 80 ORDER BY `type`, `xid` SELECT username FROM kef_users WHERE id = 78 LIMIT 0, 1 SELECT * FROM `kef_comprofiler_privacy` WHERE `userid` = 78 ORDER BY `type`, `xid` SELECT username FROM kef_users WHERE id = 150 LIMIT 0, 1 SELECT * FROM `kef_comprofiler_privacy` WHERE `userid` = 150 ORDER BY `type`, `xid` SELECT username FROM kef_users WHERE id = 93 LIMIT 0, 1 SELECT username FROM kef_users WHERE id = 102 LIMIT 0, 1 SELECT username FROM kef_users WHERE id = 79 LIMIT 0, 1 SELECT username FROM kef_users WHERE id = 126 LIMIT 0, 1 SELECT username FROM kef_users WHERE id = 160 LIMIT 0, 1 SELECT username FROM kef_users WHERE id = 145 LIMIT 0, 1 SELECT username FROM kef_users WHERE id = 106 LIMIT 0, 1 SELECT username FROM kef_users WHERE id = 186 LIMIT 0, 1 SELECT username FROM kef_users WHERE id = 60 LIMIT 0, 1 SELECT username FROM kef_users WHERE id = 141 LIMIT 0, 1 SELECT username FROM kef_users WHERE id = 179 LIMIT 0, 1 SELECT username FROM kef_users WHERE id = 105 LIMIT 0, 1 SELECT username FROM kef_users WHERE id = 84 LIMIT 0, 1 SELECT username FROM kef_users WHERE id = 114 LIMIT 0, 1 SELECT username FROM kef_users WHERE id = 174 LIMIT 0, 1 SELECT username FROM kef_users WHERE id = 159 LIMIT 0, 1 SELECT username FROM kef_users WHERE id = 104 LIMIT 0, 1 SELECT username FROM kef_users WHERE id = 99 LIMIT 0, 1 SELECT username FROM kef_users WHERE id = 101 LIMIT 0, 1 SELECT username FROM kef_users WHERE id = 75 LIMIT 0, 1 SELECT username FROM kef_users WHERE id = 81 LIMIT 0, 1 SELECT username FROM kef_users WHERE id = 183 LIMIT 0, 1 SELECT username FROM kef_users WHERE id = 98 LIMIT 0, 1 SELECT username FROM kef_users WHERE id = 173 LIMIT 0, 1 SELECT username FROM kef_users WHERE id = 115 LIMIT 0, 1 SELECT username FROM kef_users WHERE id = 91 LIMIT 0, 1 SELECT username FROM kef_users WHERE id = 140 LIMIT 0, 1 SELECT username FROM kef_users WHERE id = 80 LIMIT 0, 1 SELECT username FROM kef_users WHERE id = 78 LIMIT 0, 1 SELECT username FROM kef_users WHERE id = 150 LIMIT 0, 1 SELECT title FROM kef_comprofiler_lists WHERE listid = 11 AND published = 1 LIMIT 0, 2 SELECT title FROM kef_comprofiler_lists WHERE listid = 11 AND published = 1 LIMIT 0, 2 SELECT title FROM kef_comprofiler_lists WHERE listid = 11 AND published = 1 LIMIT 0, 2 SELECT title FROM kef_comprofiler_lists WHERE listid = 11 AND published = 1 LIMIT 0, 2 SELECT title FROM kef_comprofiler_lists WHERE listid = 11 AND published = 1 LIMIT 0, 2 SELECT title FROM kef_comprofiler_lists WHERE listid = 11 AND published = 1 LIMIT 0, 2 [0.0025s] DEBUG info j4age: JS 0.000 seconds (+0.000); 26.38 MB (+26.385) - Perform Visitor counting process (function: countVisitor()) Performed SQL enquiries SELECT * FROM kef_jstats_configuration [0.0001s] DEBUG info j4age: JS 0.000 seconds (+0.000); 26.39 MB (+0.001) - loadKnownRecords start Performed SQL enquiries [0.0006s] DEBUG info j4age: Trace Code from cookie: 2592 Performed SQL enquiries [0.0000s] DEBUG info j4age: Client-ID from cookie: 64190 Performed SQL enquiries [0.0010s] DEBUG info j4age: JS 0.002 seconds (+0.002); 26.39 MB (+0.004) - loadKnownRecords end Performed SQL enquiries SELECT * FROM kef_jstats_ipaddresses AS a WHERE a.ip = '1398342464' SELECT c.* FROM kef_jstats_clients AS c WHERE c.client_id = 64190; [0.0001s] DEBUG info j4age: JS 0.002 seconds (+0.000); 26.39 MB (+0.001) - client & ip handling start Performed SQL enquiries [0.0000s] DEBUG info j4age: IP already stored 1398342464 Performed SQL enquiries [0.0000s] DEBUG info j4age: Fire Event => beforecounting Performed SQL enquiries [0.0008s] DEBUG info j4age: 2 Plugins found in DB Performed SQL enquiries select * from `kef_jstats_configuration` where description like 'ext_%' and value = '1' [0.0003s] DEBUG info j4age: Register plugin ext_flags for event beforeload Performed SQL enquiries [0.0018s] DEBUG info j4age: Register plugin ext_ip2nation for event onpostinstallation Performed SQL enquiries [0.0000s] DEBUG info j4age: Register plugin ext_ip2nation for event resolvelocation Performed SQL enquiries [0.0000s] DEBUG info j4age: Cookies supported - Available 28 Performed SQL enquiries [0.0000s] DEBUG info j4age: Found client 64190 Visitor-ID =2592 Performed SQL enquiries [0.0000s] DEBUG info j4age: Set Cookie cltid=64190 Performed SQL enquiries [0.0000s] DEBUG info j4age: Client already known Performed SQL enquiries [0.0001s] DEBUG info j4age: JS 0.005 seconds (+0.003); 26.53 MB (+0.139) - client & ip handling end Performed SQL enquiries [0.0000s] DEBUG info j4age: Perform Visit counting process Performed SQL enquiries [0.0005s] DEBUG info j4age: Visit-Session still present. Continue this Visit 78807 Performed SQL enquiries SELECT v.visit_id FROM kef_jstats_visits as v WHERE v.client_id = 64190 AND v.ip = 1398342464 AND v.changed_at >= 1344953733 [0.0003s] DEBUG info j4age: Set Cookie js_vsid=78807 Performed SQL enquiries UPDATE kef_jstats_visits SET changed_at= 1344960933, joomla_userid = 75 WHERE visit_id = '78807' [0.0001s] DEBUG info j4age: Visit 78807 registered Performed SQL enquiries [0.0000s] DEBUG info j4age: URL called www.dkdb.dk-HTTP/1.1 Performed SQL enquiries [0.0000s] DEBUG info j4age: Perform Page counting process Performed SQL enquiries [0.0009s] DEBUG info j4age: Page counting process successful Performed SQL enquiries SELECT page_id, page_title FROM kef_jstats_pages WHERE page = '/component/comprofiler/userslist/Medlemsliste%20(Alle).html?Itemid=825' LIMIT 1 INSERT INTO `kef_jstats_impressions` (`page_id`, `visit_id`, `timestamp`) VALUES (720,78807,1344960933) [0.0001s] DEBUG info j4age: Page impression 1 registered Performed SQL enquiries [0.0001s] DEBUG info j4age: This is not redirection from other domain - do not register referrer Performed SQL enquiries [0.0000s] DEBUG info j4age: Perform Register Key Words process Performed SQL enquiries [0.0004s] DEBUG info j4age: Search engine (searcher) not recognized or empty keywords Performed SQL enquiries SELECT searcher_id AS searcher_id, searcher_name AS searcher_name, searcher_domain AS searcher_domain, searcher_key AS searcher_key FROM kef_jstats_searchers WHERE 'localhost' LIKE CONCAT('%', `searcher_domain` , '%') LIMIT 1 [0.0001s] DEBUG info j4age: Keyword & Referrer registered = TRUE Performed SQL enquiries [0.0000s] DEBUG info j4age: Fire Event => aftercounting Performed SQL enquiries [0.0001s] DEBUG info j4age: JS 0.008 seconds (+0.003); 26.53 MB (+0.004) - Counting Visitor finished Performed SQL enquiries

Best regards
Fribse

Frømandsklubben Nikon, www.nikondyk.dk
We're a volunteer driven diving club in Ishøj, Denmark.
Har du brug for en dykkerklub der rummer alle, så kom ned til os.

Please Log in or Create an account to join the conversation.

  • fribse2011
  • fribse2011
  • OFFLINE
  • Posts: 921
  • Thanks: 79
  • Karma: 8
12 years 5 months ago #207831 by fribse2011
Replied by fribse2011 on topic Re: Strange result for query field
I tried disabling sqlishield protection, but no change, I'll copy the site to a testsite, and remove admintools completely to see.

Best regards
Fribse

Frømandsklubben Nikon, www.nikondyk.dk
We're a volunteer driven diving club in Ishøj, Denmark.
Har du brug for en dykkerklub der rummer alle, så kom ned til os.

Please Log in or Create an account to join the conversation.

  • fribse2011
  • fribse2011
  • OFFLINE
  • Posts: 921
  • Thanks: 79
  • Karma: 8
12 years 5 months ago #207834 by fribse2011
Replied by fribse2011 on topic Re: Strange result for query field
Removing admintools didnt change anything

Best regards
Fribse

Frømandsklubben Nikon, www.nikondyk.dk
We're a volunteer driven diving club in Ishøj, Denmark.
Har du brug for en dykkerklub der rummer alle, så kom ned til os.

Please Log in or Create an account to join the conversation.

  • krileon
  • krileon
  • ONLINE
  • Posts: 48708
  • Thanks: 8319
  • Karma: 1447
12 years 5 months ago #207848 by krileon
Replied by krileon on topic Re: Strange result for query field
Maybe try adding an IF substitution to your query so it won't even fire if the user has no cb_postnummer? Example as follows.

[cb:if cb_postnummer!=""]SELECT `by` FROM `kef_postnumre` WHERE `nr` = '[cb_postnummer]'[/cb:if]


Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

Please Log in or Create an account to join the conversation.

Moderators: beatnantkrileon
Powered by Kunena Forum