Rang is not working
Hi Support
I am using code as attached and also change channel fields to number.
But always it's generating random result I have tried to all things but not success.
So please help us ASAP.
Thanks
{exp:low_search:form query="{segment_3}" result_page="tours-sic/demo"}
-
-
Go
{/exp:low_search:form}
{exp:low_search:results
query="{segment_3}"
channel="tours_sic"
status="not closed"
limit="10"
}
{tours_sic_number_of_days} {title}{entry_id}
{paginate}
{current_page}/{total_pages} | {pagination_links}
{/paginate}
{/exp:low_search:results}
Replies
Low 27 May 2019 09:55
Please use a service like http://pastebin.com/ for large chunks of code -- GetSat annoyingly strips away HTML tags.
Also, please provide the contents of your template debugger and version info for your EE and LS installation.
W3care Developer 27 May 2019 10:04
Hi
EE4.3.2 and LS 6.1.3
Low 27 May 2019 10:09
Please provide the contents of your template debugger for a results page that displays the unexpected search results.
W3care Developer 27 May 2019 10:18
- -
12 Multisport Angkok Hike and Bike Hike and Angkok20798
3 Multisport Angkok Hike and Bike Hike and Angkok20810
10 demo tour20824
/tours-sic/demo/eyJyZXN1bHRfcGFnZSI6InRvdXJzLXNpY1wvZGVtbyIsInJhbmdlLWZyb206dG91cnNfc2ljX251bWJlcl9vZl9kYXlzIjoiMSIsInJhbmdlLXRvOnRvdXJzX3NpY19udW1iZXJfb2ZfZGF5cyI6IjUifQ
1.5018s Load
Variables
106 Queries
36.1MB Templates
Duplicate Queries (devexotr_exocms19)
13 ×
SHOW TABLES FROM 'devexotr_exocms19'
#system/phar://user/addons/detour_pro/detour_pro.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\DetourPro\FluxCapacitor\Bridge\EE4::initiateSettings() #system/phar://user/addons/transcribe/transcribe.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Transcribe\FluxCapacitor\Bridge\EE4::initiateSettings() #system/user/addons/transcribe/ext.transcribe.php L:833 Transcribe::_fix_structure_site_pages() #system/phar://user/addons/structure/structure.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Structure\FluxCapacitor\Bridge\EE4::initiateSettings() #system/phar://user/addons/wygwam/wygwam.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Wygwam\FluxCapacitor\Bridge\EE4::initiateSettings() #system/user/addons/assets/helpers/eeharbor_ee4_helper.php L:172 assets\EEHelper::initiateSettings() #system/phar://user/addons/playa/playa.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Playa\FluxCapacitor\Bridge\EE4::initiateSettings() #system/phar://user/addons/matrix/matrix.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Matrix\FluxCapacitor\Bridge\EE4::initiateSettings()
4 ×
SELECT *
FROM ('exp_transcribe_settings')
WHERE 'exp_transcribe_settings'.'site_id' = 1
#system/phar://user/addons/transcribe/transcribe.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Transcribe\FluxCapacitor\Bridge\EE4::initiateSettings()
4 ×
SELECT 'settings'
FROM ('exp_fieldtypes')
WHERE 'name' = 'transcribe'
#system/phar://user/addons/transcribe/transcribe.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Transcribe\FluxCapacitor\Bridge\EE4::initiateSettings()
3 ×
SELECT *
FROM ('exp_structure_settings')
WHERE 'exp_structure_settings'.'site_id' = 1
#system/phar://user/addons/structure/structure.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Structure\FluxCapacitor\Bridge\EE4::initiateSettings()
3 ×
SELECT 'settings'
FROM ('exp_fieldtypes')
WHERE 'name' = 'structure'
#system/phar://user/addons/structure/structure.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Structure\FluxCapacitor\Bridge\EE4::initiateSettings()
2 ×
SELECT field_id, field_name FROM exp_category_fields WHERE site_id IN ('1')
#system/ee/EllisLab/Addons/channel/mod.channel.php L:452 Channel::generateCategoryFieldSQL()
Queries (devexotr_exocms19)
0.0001s
1KB
SET NAMES 'utf8' COLLATE 'utf8_unicode_ci'
#system/ee/EllisLab/ExpressionEngine/Service/Addon/Addon.php L:56 Addons_model::get_installed_modules()
0.0003s
12KB
SELECT LOWER(module_name) AS module_name, module_version, has_cp_backend, module_id
FROM ('exp_modules')
#system/ee/EllisLab/ExpressionEngine/Service/Addon/Addon.php L:56 Addons_model::get_installed_modules()
0.0003s
13KB
SELECT 'class', 'version'
FROM ('exp_extensions')
WHERE 'enabled' = 'y'
#system/ee/EllisLab/ExpressionEngine/Service/Addon/Addon.php L:73 Addons_model::get_installed_extensions()
0.0002s
9KB
SELECT 'name'
FROM ('exp_fieldtypes')
#system/ee/EllisLab/ExpressionEngine/Service/Addon/Factory.php L:84 EllisLab\ExpressionEngine\Service\Addon\Addon::isInstalled()
0.0002s
9KB
SELECT 'plugin_package'
FROM ('exp_plugins')
#system/ee/EllisLab/ExpressionEngine/Service/Addon/Factory.php L:84 EllisLab\ExpressionEngine\Service\Addon\Addon::isInstalled()
0.0003s
42KB
SELECT *
FROM ('exp_sites')
WHERE 'site_id' = 1
#system/ee/legacy/libraries/Core.php L:124 EE_Config::site_prefs()
0.0004s
26KB
SELECT DISTINCT ee.* FROM exp_extensions ee WHERE enabled = 'y' ORDER BY hook, priority ASC, class
#system/ee/legacy/core/Loader.php L:1038 EE_Extensions::__construct()
0.0003s
9KB
SELECT COUNT(*) AS 'numrows'
FROM ('exp_modules')
WHERE 'module_name' = 'Blacklist'
#system/ee/legacy/libraries/Blacklist.php L:58 Addons_model::module_installed()
0.0002s
10KB
SELECT whitelisted_type, whitelisted_value FROM exp_whitelisted
WHERE whitelisted_value != ''
#system/ee/legacy/libraries/Core.php L:283 EE_Blacklist::_check_blacklist()
0.0002s
9KB
SELECT blacklisted_type, blacklisted_value FROM exp_blacklisted
#system/ee/legacy/libraries/Core.php L:283 EE_Blacklist::_check_blacklist()
0.0016s
24KB
SHOW TABLES FROM 'devexotr_exocms19'
#system/phar://user/addons/detour_pro/detour_pro.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\DetourPro\FluxCapacitor\Bridge\EE4::initiateSettings()
0.0003s
12KB
SELECT *
FROM ('exp_detour_pro_settings')
WHERE 'exp_detour_pro_settings'.'site_id' = 1
#system/phar://user/addons/detour_pro/detour_pro.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\DetourPro\FluxCapacitor\Bridge\EE4::initiateSettings()
0.0003s
9KB
SELECT 'settings'
FROM ('exp_fieldtypes')
WHERE 'name' = 'detour_pro'
#system/phar://user/addons/detour_pro/detour_pro.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\DetourPro\FluxCapacitor\Bridge\EE4::initiateSettings()
0.0007s
13KB
SELECT detour_id, original_url, new_url, detour_method, start_date, end_date
FROM exp_detours
WHERE (start_date IS NULL OR start_date = NOW())
AND 'en/tours-sic/demo/eyJyZXN1bHRfcGFnZSI6InRvdXJzLXNpY1wvZGVtbyIsInJhbmdlLWZyb206dG91cnNfc2ljX251bWJlcl9vZl9kYXlzIjoiMSIsInJhbmdlLXRvOnRvdXJzX3NpY19udW1iZXJfb2ZfZGF5cyI6IjUifQ' LIKE REPLACE(original_url, '_', '[_') ESCAPE '['
AND site_id = 1
# L: Detour_pro_ext::sessions_start()
0.0014s
23KB
SHOW TABLES FROM 'devexotr_exocms19'
#system/phar://user/addons/transcribe/transcribe.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Transcribe\FluxCapacitor\Bridge\EE4::initiateSettings()
0.0002s
12KB
SELECT *
FROM ('exp_transcribe_settings')
WHERE 'exp_transcribe_settings'.'site_id' = 1
#system/phar://user/addons/transcribe/transcribe.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Transcribe\FluxCapacitor\Bridge\EE4::initiateSettings()
0.0002s
9KB
SELECT 'settings'
FROM ('exp_fieldtypes')
WHERE 'name' = 'transcribe'
#system/phar://user/addons/transcribe/transcribe.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Transcribe\FluxCapacitor\Bridge\EE4::initiateSettings()
0.0013s
23KB
SHOW TABLES FROM 'devexotr_exocms19'
#system/phar://user/addons/transcribe/transcribe.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Transcribe\FluxCapacitor\Bridge\EE4::initiateSettings()
0.0002s
12KB
SELECT *
FROM ('exp_transcribe_settings')
WHERE 'exp_transcribe_settings'.'site_id' = 1
#system/phar://user/addons/transcribe/transcribe.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Transcribe\FluxCapacitor\Bridge\EE4::initiateSettings()
0.0002s
9KB
SELECT 'settings'
FROM ('exp_fieldtypes')
WHERE 'name' = 'transcribe'
#system/phar://user/addons/transcribe/transcribe.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Transcribe\FluxCapacitor\Bridge\EE4::initiateSettings()
0.0002s
12KB
SELECT *
FROM ('exp_transcribe_languages')
WHERE 'abbreviation' = 'en'
# L: Transcribe_ext::transcribe_session_start()
0.0002s
11KB
SELECT *
FROM ('exp_transcribe_settings')
WHERE 'site_id' = 1
LIMIT 1
#system/user/addons/transcribe/ext.transcribe.php L:2106 Transcribe::_get_settings()
0.0013s
23KB
SHOW TABLES FROM 'devexotr_exocms19'
#system/user/addons/transcribe/ext.transcribe.php L:833 Transcribe::_fix_structure_site_pages()
0.0003s
11KB
SELECT 'ct'.'entry_id', 'ct'.'channel_id', 'tel'.'language_id', 'ct'.'url_title'
FROM ('exp_channel_titles' as ct)
JOIN 'exp_transcribe_entries_languages' as tel ON 'tel'.'entry_id' = 'ct'.'entry_id'
JOIN 'exp_structure_channels' as sc ON 'sc'.'channel_id' = 'ct'.'channel_id'
WHERE 'sc'.'type' = 'listing'
#system/user/addons/transcribe/ext.transcribe.php L:833 Transcribe::_fix_structure_site_pages()
0.0140s
1.1MB
SELECT cr.url_title as route, cr2.url_title as relationship FROM exp_transcribe_entries_languages as tel INNER JOIN exp_transcribe_entries_languages as tel2 ON tel2.relationship_id = tel.relationship_id LEFT JOIN exp_channel_titles as cr ON cr.entry_id = tel.entry_id LEFT JOIN exp_channel_titles as cr2 ON cr2.entry_id = tel2.entry_id WHERE cr.site_id = 1
#system/user/addons/transcribe/ext.transcribe.php L:833 Transcribe::_fix_structure_site_pages()
0.0006s
11KB
SELECT *
FROM ('exp_modules')
WHERE 'module_name' = 'Pages'
# L: Transcribe_ext::transcribe_session_start()
0.0005s
9KB
SELECT 'var_value'
FROM ('exp_structure_settings')
WHERE 'var' = 'add_trailing_slash'
AND 'site_id' = 1
# L: Transcribe_ext::transcribe_session_start()
0.0006s
28KB
SELECT *
FROM ('exp_transcribe_entries_languages')
WHERE 'entry_id' IN (30, 31, 32, 33, 37, 3515, 3517, 3516, 3639, 3643, 3646, 46, 34, 3671, 3692, 3797, 3798, 3799, 3800, 3801, 3802, 3803, 3804, 3805, 3894, 3895, 3896, 3897, 3898, 3899, 3900, 3901, 3990, 3997, 35, 38, 40, 41, 43, 44, 3600, 3601, 3602, 3603, 3604, 3605, 3606, 3607, 3608, 3609, 3610, 3611, 3612, 3613, 3614, 3615, 3621, 3622, 3623, 3624, 3625, 3627, 3628, 3629, 3631, 3632, 3633, 3634, 3635, 3636, 3637, 3638, 3644, 3647, 3648, 36, 39, 1849, 42, 45, 47, 1904, 1905, 2968, 2969, 3059, 3060, 3085, 3518, 1, 3519, 3589, 3590, 3657, 3659, 3893, 3902, 3903, 3904, 3947, 3957, 3998, 3999, 4000, 4001, 5401, 6919, 3936, 14525, 14765, 14780, 14806, 14835, 14855, 14856, 14864, 14865, 14866, 14867, 14869, 14871, 14872, 14873, 14875, 14876, 14877, 14878, 14881, 15050, 15089, 15112, 15132, 15326, 16109, 16859, 16860, 16861, 16862, 17141, 17255, 17304, 9822, 14812, 14826, 9819, 9820, 9831, 9832, 9821, 9833, 9823, 9824, 9834, 9835, 9836, 9828, 9829, 9830, 9837, 9839, 9838, 9840, 9841, 9842, 9843, 9845, 9844, 9846, 9847, 9848, 9825, 9827, 17439, 14809, 14791, 14824, 14810, 14794, 14829, 14808, 14793, 14825, 14807, 14801, 14828, 14811, 14796, 14827, 17487, 17488, 17602, 17644, 17645, 17648, 17649, 17650, 17651, 17652, 17653, 17654, 17655, 17658, 17665, 17666, 17667, 17668, 17669, 17670, 16346, 17702, 17785, 17786, 17787, 17788, 17789, 18486, 18488, 19148, 19270, 19483, 20312, 20313, 20317, 20358, 20360, 20376, 20377, 20378, 20379, 20380, 20381, 20382, 20384, 20385, 20386, 20387, 20388, 20389, 20390, 20391, 20392, 20395, 20396, 20397, 20398, 20399, 20400, 20401, 20402, 20403, 20404, 20405, 20406, 20417, 20418, 20419, 20420, 20421, 20422, 20423, 20424, 20425, 20426, 20427, 20428, 20429, 20430, 20431, 14817, 14800, 14831, 14816, 14799, 14830, 14815, 14798, 14832, 14814, 14797, 14833, 9849, 14834, 20, 20820, 20821, 20834, 20835, 20849, 20850, 20940, 20941, 21077, 21078)
#system/user/addons/transcribe/ext.transcribe.php L:922 Transcribe::_get_language()
0.0018s
23KB
SHOW TABLES FROM 'devexotr_exocms19'
#system/phar://user/addons/transcribe/transcribe.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Transcribe\FluxCapacitor\Bridge\EE4::initiateSettings()
0.0002s
12KB
SELECT *
FROM ('exp_transcribe_settings')
WHERE 'exp_transcribe_settings'.'site_id' = 1
#system/phar://user/addons/transcribe/transcribe.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Transcribe\FluxCapacitor\Bridge\EE4::initiateSettings()
0.0002s
9KB
SELECT 'settings'
FROM ('exp_fieldtypes')
WHERE 'name' = 'transcribe'
#system/phar://user/addons/transcribe/transcribe.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Transcribe\FluxCapacitor\Bridge\EE4::initiateSettings()
0.0003s
9KB
SELECT 'abbreviation'
FROM ('exp_transcribe_languages')
#system/user/addons/transcribe/mod.transcribe.php L:1432 Transcribe::_remove_abbreviation()
0.0002s
12KB
SELECT *
FROM ('exp_structure_listings')
WHERE 'site_id' = 1
#system/user/addons/transcribe/libraries/Transcribe_structure.php L:110 Transcribe_structure::get_listing_data()
0.0003s
9KB
SELECT COUNT(*) AS 'numrows'
FROM ('exp_modules')
WHERE 'module_name' = 'Structure'
#system/phar://user/addons/structure/structure.phar/FluxCapacitor/Bridge/EE4.php L:543 Addons_model::module_installed()
0.0002s
10KB
SELECT var_value, var FROM exp_structure_settings WHERE site_id IN (0,1)
#system/user/addons/structure/sql.structure.php L:1406 Sql_structure::get_settings()
0.0003s
9KB
SELECT site_pages FROM exp_sites WHERE site_id = 1
#system/user/addons/structure/sql.structure.php L:1420 Sql_helper::row()
0.0005s
25KB
SELECT 'entry_id', 'relationship_id', 'language_id'
FROM ('exp_transcribe_entries_languages')
WHERE 'entry_id' IN (30, 31, 32, 33, 37, 3515, 3517, 3516, 3639, 3643, 3646, 46, 34, 3671, 3692, 3797, 3798, 3799, 3800, 3801, 3802, 3803, 3804, 3805, 3894, 3895, 3896, 3897, 3898, 3899, 3900, 3901, 3990, 3997, 35, 38, 40, 41, 43, 44, 3600, 3601, 3602, 3603, 3604, 3605, 3606, 3607, 3608, 3609, 3610, 3611, 3612, 3613, 3614, 3615, 3621, 3622, 3623, 3624, 3625, 3627, 3628, 3629, 3631, 3632, 3633, 3634, 3635, 3636, 3637, 3638, 3644, 3647, 3648, 36, 39, 1849, 42, 45, 47, 1904, 1905, 2968, 2969, 3059, 3060, 3085, 3518, 1, 3519, 3589, 3590, 3657, 3659, 3893, 3902, 3903, 3904, 3947, 3957, 3998, 3999, 4000, 4001, 5401, 6919, 3936, 14525, 14765, 14780, 14806, 14835, 14855, 14856, 14864, 14865, 14866, 14867, 14869, 14871, 14872, 14873, 14875, 14876, 14877, 14878, 14881, 15050, 15089, 15112, 15132, 15326, 16109, 16859, 16860, 16861, 16862, 17141, 17255, 17304, 9822, 14812, 14826, 9819, 9820, 9831, 9832, 9821, 9833, 9823, 9824, 9834, 9835, 9836, 9828, 9829, 9830, 9837, 9839, 9838, 9840, 9841, 9842, 9843, 9845, 9844, 9846, 9847, 9848, 9825, 9827, 17439, 14809, 14791, 14824, 14810, 14794, 14829, 14808, 14793, 14825, 14807, 14801, 14828, 14811, 14796, 14827, 17487, 17488, 17602, 17644, 17645, 17648, 17649, 17650, 17651, 17652, 17653, 17654, 17655, 17658, 17665, 17666, 17667, 17668, 17669, 17670, 16346, 17702, 17785, 17786, 17787, 17788, 17789, 18486, 18488, 19148, 19270, 19483, 20312, 20313, 20317, 20358, 20360, 20376, 20377, 20378, 20379, 20380, 20381, 20382, 20384, 20385, 20386, 20387, 20388, 20389, 20390, 20391, 20392, 20395, 20396, 20397, 20398, 20399, 20400, 20401, 20402, 20403, 20404, 20405, 20406, 20417, 20418, 20419, 20420, 20421, 20422, 20423, 20424, 20425, 20426, 20427, 20428, 20429, 20430, 20431, 14817, 14800, 14831, 14816, 14799, 14830, 14815, 14798, 14832, 14814, 14797, 14833, 9849, 14834, 20, 20821, 20835, 20849, 20940)
LIMIT 999999
#system/user/addons/transcribe/libraries/Transcribe_structure.php L:130 Transcribe_structure::get_relationship_data()
0.0011s
46KB
SELECT CONCAT_WS('/', ttgl.content, ttl.content) as route, CONCAT_WS('/', tg.group_name, t.template_name) as relationship FROM exp_template_groups as tg JOIN exp_templates as t ON t.group_id = tg.group_id JOIN exp_transcribe_template_groups_languages as ttgl ON ttgl.template_group_id = tg.group_id JOIN exp_transcribe_templates_languages as ttl ON ttl.template_id = t.template_id AND ttl.language_id = ttgl.language_id WHERE tg.site_id = 1 AND t.site_id = 1 UNION ALL SELECT CONCAT_WS('/', tg.group_name, t.template_name) as route, CONCAT_WS('/', tg.group_name, t.template_name) as relationship FROM exp_template_groups as tg JOIN exp_templates as t ON t.group_id = tg.group_id WHERE tg.site_id = 1 AND t.site_id = 1 UNION ALL SELECT t.template_name as route, t.template_name as relationship FROM exp_template_groups as tg JOIN exp_templates as t ON t.group_id = tg.group_id WHERE tg.is_site_default = 'y' AND tg.site_id = 1 AND t.site_id = 1 UNION ALL SELECT ttl.content as route, t.template_name as relationship FROM exp_template_groups as tg JOIN exp_templates as t ON t.group_id = tg.group_id JOIN exp_transcribe_template_groups_languages as ttgl ON ttgl.template_group_id = tg.group_id JOIN exp_transcribe_templates_languages as ttl ON ttl.template_id = t.template_id AND ttl.language_id = ttgl.language_id WHERE tg.is_site_default = 'y' AND tg.site_id = 1 AND t.site_id = 1 UNION ALL SELECT ttgl.content as route, tg.group_name as relationship FROM exp_template_groups as tg JOIN exp_templates as t ON t.group_id = tg.group_id JOIN exp_transcribe_template_groups_languages as ttgl ON ttgl.template_group_id = tg.group_id JOIN exp_transcribe_templates_languages as ttl ON ttl.template_id = t.template_id AND ttl.language_id = ttgl.language_id WHERE t.template_name = 'index' AND tg.site_id = 1 AND t.site_id = 1 UNION ALL SELECT tg.group_name as route, tg.group_name as relationship FROM exp_template_groups as tg JOIN exp_templates as t ON t.group_id = tg.group_id WHERE t.template_name = 'index' AND tg.site_id = 1 AND t.site_id = 1
#system/user/addons/transcribe/mod.transcribe.php L:2181 Transcribe::_get_routes()
0.0011s
3KB
SHOW TABLES LIKE "%structure%"
# L: Transcribe_ext::transcribe_session_start()
0.0003s
14KB
SELECT * FROM exp_extensions WHERE class='Freebie_ext'
#system/user/addons/freebie/ext.freebie.php L:93 Freebie_ext::clear_cache()
0.0014s
23KB
SHOW TABLES FROM 'devexotr_exocms19'
#system/phar://user/addons/structure/structure.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Structure\FluxCapacitor\Bridge\EE4::initiateSettings()
0.0002s
11KB
SELECT *
FROM ('exp_structure_settings')
WHERE 'exp_structure_settings'.'site_id' = 1
#system/phar://user/addons/structure/structure.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Structure\FluxCapacitor\Bridge\EE4::initiateSettings()
0.0002s
9KB
SELECT 'settings'
FROM ('exp_fieldtypes')
WHERE 'name' = 'structure'
#system/phar://user/addons/structure/structure.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Structure\FluxCapacitor\Bridge\EE4::initiateSettings()
0.0003s
9KB
SELECT entry_id FROM exp_structure_listings WHERE site_id = 1 LIMIT 99999999
#system/user/addons/structure/sql.structure.php L:1194 Sql_structure::get_listing_entry_ids()
0.0007s
13KB
SELECT 'member_id', 'can_debug', 'admin_sess', 'last_activity', 'fingerprint', 'sess_start', 'login_state'
FROM ('exp_sessions')
WHERE 'session_id' = '8f3b14a942834601a4655163e64960cfcf95b852'
#system/ee/legacy/libraries/Session.php L:161 EE_Session::fetch_session_data()
0.0006s
123KB
SELECT *
FROM ('exp_members' m, 'exp_member_groups' g)
WHERE 'g'.'site_id' = 1
AND m.group_id = g.group_id
AND 'member_id' = 10
#system/ee/legacy/libraries/Session.php L:558 EE_Session::_do_member_query()
0.0002s
2KB
UPDATE 'exp_sessions' SET 'session_id' = '8f3b14a942834601a4655163e64960cfcf95b852', 'fingerprint' = '3727c24bd3cf71ac1bce64c4a343f1e3', 'member_id' = 10, 'admin_sess' = 1, 'ip_address' = '103.137.84.193', 'user_agent' = 'Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:67.0) Gecko/20100101 Firefox/67.0', 'last_activity' = 1558952005, 'sess_start' = 1558951294, 'can_debug' = 'n' WHERE session_id = '8f3b14a942834601a4655163e64960cfcf95b852'
#system/ee/legacy/libraries/Session.php L:177 EE_Session::update_session()
0.0014s
23KB
SHOW TABLES FROM 'devexotr_exocms19'
#system/phar://user/addons/structure/structure.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Structure\FluxCapacitor\Bridge\EE4::initiateSettings()
0.0002s
11KB
SELECT *
FROM ('exp_structure_settings')
WHERE 'exp_structure_settings'.'site_id' = 1
#system/phar://user/addons/structure/structure.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Structure\FluxCapacitor\Bridge\EE4::initiateSettings()
0.0002s
9KB
SELECT 'settings'
FROM ('exp_fieldtypes')
WHERE 'name' = 'structure'
#system/phar://user/addons/structure/structure.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Structure\FluxCapacitor\Bridge\EE4::initiateSettings()
0.0003s
11KB
SELECT *
FROM ('exp_security_hashes')
WHERE 'session_id' = '8f3b14a942834601a4655163e64960cfcf95b852'
#system/ee/legacy/libraries/Csrf.php L:161 Csrf_database::fetch_token()
0.0005s
47KB
SELECT Snippet_snippets.snippet_id as Snippet__snippet_id, Snippet_snippets.site_id as Snippet__site_id, Snippet_snippets.snippet_name as Snippet__snippet_name, Snippet_snippets.snippet_contents as Snippet__snippet_contents, Snippet_snippets.edit_date as Snippet__edit_date
FROM ('exp_snippets' as Snippet_snippets)
WHERE (
'Snippet_snippets'.'site_id' = 1
OR 'Snippet_snippets'.'site_id' = 0
)
LIMIT 18446744073709551615
#system/ee/legacy/libraries/Core.php L:370 EllisLab\ExpressionEngine\Model\Template\Snippet::loadAll()
0.0003s
10KB
SELECT Site_sites.site_id as Site__site_id, Site_sites.site_name as Site__site_name
FROM ('exp_sites' as Site_sites)
WHERE (
'Site_sites'.'site_id' = 1
)
LIMIT 1
#system/ee/EllisLab/ExpressionEngine/Model/Template/Snippet.php L:168 EllisLab\ExpressionEngine\Model\Template\Snippet::getFolderPath()
0.0020s
23KB
SHOW TABLES FROM 'devexotr_exocms19'
#system/phar://user/addons/structure/structure.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Structure\FluxCapacitor\Bridge\EE4::initiateSettings()
0.0003s
11KB
SELECT *
FROM ('exp_structure_settings')
WHERE 'exp_structure_settings'.'site_id' = 1
#system/phar://user/addons/structure/structure.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Structure\FluxCapacitor\Bridge\EE4::initiateSettings()
0.0002s
9KB
SELECT 'settings'
FROM ('exp_fieldtypes')
WHERE 'name' = 'structure'
#system/phar://user/addons/structure/structure.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Structure\FluxCapacitor\Bridge\EE4::initiateSettings()
0.0003s
11KB
SELECT 'route_parsed', 'template_name', 'group_name'
FROM ('exp_templates')
JOIN 'exp_template_routes' ON 'exp_templates'.'template_id' = 'exp_template_routes'.'template_id'
JOIN 'exp_template_groups' ON 'exp_templates'.'group_id' = 'exp_template_groups'.'group_id'
WHERE 'route_parsed' is not null
AND 'exp_templates'.'site_id' = 1
ORDER BY 'order', 'group_name', 'template_name' ASC
#system/ee/legacy/libraries/Template_router.php L:24 EE_Template_Router::set_routes()
0.0002s
9KB
SELECT 'group_id'
FROM ('exp_template_groups')
WHERE 'group_name' = 'tours-sic'
AND 'site_id' = 1
#system/ee/legacy/libraries/Template.php L:211 EE_Template::parse_template_uri()
0.0002s
9KB
SELECT COUNT(*) as count
FROM ('exp_templates')
WHERE 'group_id' = 29
AND 'template_name' = 'demo'
#system/ee/legacy/libraries/Template.php L:211 EE_Template::parse_template_uri()
0.0003s
20KB
SELECT 'exp_templates'.*, 'exp_template_groups'.'group_name'
FROM ('exp_templates')
JOIN 'exp_template_groups' ON 'exp_template_groups'.'group_id' = 'exp_templates'.'group_id'
WHERE 'exp_template_groups'.'site_id' = 1
AND 'exp_templates'.'template_name' = 'demo'
AND 'exp_template_groups'.'group_name' = 'tours-sic'
#system/ee/legacy/libraries/Template.php L:2412 EE_Template::fetch_template()
0.0003s
13KB
SELECT Plugin_plugins.plugin_id as Plugin__plugin_id, Plugin_plugins.plugin_name as Plugin__plugin_name, Plugin_plugins.plugin_package as Plugin__plugin_package, Plugin_plugins.plugin_version as Plugin__plugin_version, Plugin_plugins.is_typography_related as Plugin__is_typography_related
FROM ('exp_plugins' as Plugin_plugins)
LIMIT 18446744073709551615
#system/ee/legacy/libraries/Template.php L:1454 EE_Template::fetch_addons()
0.0002s
10KB
SELECT 'module_version', 'module_name'
FROM ('exp_modules')
#system/ee/legacy/libraries/Template.php L:1478 EE_Template::process_tags()
0.0003s
9KB
SELECT 'settings'
FROM ('exp_extensions')
WHERE 'class' = 'Low_search_ext'
LIMIT 1
#system/user/addons/low_search/libraries/Low_search_params.php L:148 Low_search_settings::get()
0.0009s
118KB
SELECT ChannelField_channel_fields.field_id as ChannelField__field_id, ChannelField_channel_fields.site_id as ChannelField__site_id, ChannelField_channel_fields.field_name as ChannelField__field_name, ChannelField_channel_fields.field_label as ChannelField__field_label, ChannelField_channel_fields.field_instructions as ChannelField__field_instructions, ChannelField_channel_fields.field_type as ChannelField__field_type, ChannelField_channel_fields.field_list_items as ChannelField__field_list_items, ChannelField_channel_fields.field_pre_populate as ChannelField__field_pre_populate, ChannelField_channel_fields.field_pre_channel_id as ChannelField__field_pre_channel_id, ChannelField_channel_fields.field_pre_field_id as ChannelField__field_pre_field_id, ChannelField_channel_fields.field_ta_rows as ChannelField__field_ta_rows, ChannelField_channel_fields.field_maxl as ChannelField__field_maxl, ChannelField_channel_fields.field_required as ChannelField__field_required, ChannelField_channel_fields.field_text_direction as ChannelField__field_text_direction, ChannelField_channel_fields.field_search as ChannelField__field_search, ChannelField_channel_fields.field_is_hidden as ChannelField__field_is_hidden, ChannelField_channel_fields.field_fmt as ChannelField__field_fmt, ChannelField_channel_fields.field_show_fmt as ChannelField__field_show_fmt, ChannelField_channel_fields.field_order as ChannelField__field_order, ChannelField_channel_fields.field_content_type as ChannelField__field_content_type, ChannelField_channel_fields.field_settings as ChannelField__field_settings, ChannelField_channel_fields.legacy_field_data as ChannelField__legacy_field_data
FROM ('exp_channel_fields' as ChannelField_channel_fields)
LIMIT 18446744073709551615
#system/user/addons/low_search/filters/ranges/lsf.ranges.php L:145 Low_search_fields::get()
0.0005s
10KB
SELECT 'channel_titles'.'entry_id'
FROM ('exp_channel_titles' as channel_titles)
LEFT JOIN 'exp_channel_data_field_868' as channel_data_field_868 ON 'channel_data_field_868'.'entry_id' = 'channel_titles'.'entry_id'
WHERE 'channel_data_field_868'.'field_id_868' >= '1'
AND 'channel_data_field_868'.'field_id_868' < 1558952005 AND (t.expiration_date = 0 OR t.expiration_date > 1558952005) AND t.entry_id IN ('20797','20798','20810','20824','20825','21074','21075','21118','21119','21125','21131','21134','21150','21152','21155','21156','21157','21158','21161','21162','21164','21166','21167','21169','21170','21171','21172','21173','21175','21187','21188','21189') AND t.channel_id IN (58) AND t.status != 'closed'
#system/ee/EllisLab/Addons/channel/mod.channel.php L:248 Channel::build_sql_query()
0.0009s
11KB
SELECT t.entry_id , exp_channels.channel_id FROM exp_channel_titles AS t
LEFT JOIN exp_channels ON t.channel_id = exp_channels.channel_id WHERE t.entry_id != '' AND t.site_id IN ('1') AND t.entry_date < 1558952005 AND (t.expiration_date = 0 OR t.expiration_date > 1558952005) AND t.entry_id IN ('20797','20798','20810','20824','20825','21074','21075','21118','21119','21125','21131','21134','21150','21152','21155','21156','21157','21158','21161','21162','21164','21166','21167','21169','21170','21171','21172','21173','21175','21187','21188','21189') AND t.channel_id IN (58) AND t.status != 'closed'ORDER BY t.sticky desc, t.entry_date desc, t.entry_id desc LIMIT 0, 10
#system/ee/EllisLab/Addons/channel/mod.channel.php L:248 Channel::build_sql_query()
0.0008s
94KB
SELECT Channel_channels.channel_id as Channel__channel_id, Channel_channels.site_id as Channel__site_id, Channel_channels.channel_name as Channel__channel_name, Channel_channels.channel_title as Channel__channel_title, Channel_channels.channel_url as Channel__channel_url, Channel_channels.channel_description as Channel__channel_description, Channel_channels.channel_lang as Channel__channel_lang, Channel_channels.total_entries as Channel__total_entries, Channel_channels.total_records as Channel__total_records, Channel_channels.total_comments as Channel__total_comments, Channel_channels.last_entry_date as Channel__last_entry_date, Channel_channels.last_comment_date as Channel__last_comment_date, Chann
Low 27 May 2019 10:46
I'll need to take a look myself. Please send SuperAdmin login credentials to hi at gotolow dot com if you can.
W3care Developer 27 May 2019 10:59
Ok thanks I have sent over.
Low 27 May 2019 11:07
The field's data may say it's integer only, but the database says otherwise:
If you change the field_id_868 column to an INT, it should work as expected.
W3care Developer 27 May 2019 11:35
Thank you so much low for your help, Now issue has been resolved.