Becki Posted March 12, 2007 Posted March 12, 2007 Hi, I find that on my index page (and probably all others!) I have about 50 of these quesries: [26] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '23' order by c.sort_order, cd.categories_name [27] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '37' order by c.sort_order, cd.categories_name [28] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '38' order by c.sort_order, cd.categories_name Where do they originate from and does anyone know I get rid of them?! Thanks Becki
♥bruyndoncx Posted March 12, 2007 Posted March 12, 2007 do you have a search box with categories dropdown installed ? KEEP CALM AND CARRY ON I do not use the responsive bootstrap version since i coded my responsive version earlier, but i have bought every 28d of code package to support burts effort and keep this forum alive (albeit more like on life support). So if you are still here ? What are you waiting for ?! Find the most frequent unique errors to fix: grep "PHP" php_error_log.txt | sed "s/^.* PHP/PHP/g" |grep "line" |sort | uniq -c | sort -r > counterrors.txt
Velveeta Posted March 12, 2007 Posted March 12, 2007 Hi, I find that on my index page (and probably all others!) I have about 50 of these quesries: [26] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '23' order by c.sort_order, cd.categories_name [27] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '37' order by c.sort_order, cd.categories_name [28] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '38' order by c.sort_order, cd.categories_name Where do they originate from and does anyone know I get rid of them?! Thanks Becki I'm gonna guess that this is happening from your category listing box in the left or right column of your store... Those queries are generally associated with that, so the file itself would be includes/boxes/categories.php... Richard. Richard Lindsey
Becki Posted March 14, 2007 Author Posted March 14, 2007 Hi, Thanks for your suggestions, i don't have any category drop down boxes etc, I found this code in sts_user_code.php which when i deleted it dropped all these queries - just need to find out if it is OK to delete it! $sts->start_capture(); echo "\n<!-- Start Category Menu -->\n"; echo tep_draw_form('goto', FILENAME_DEFAULT, 'get', ''); echo tep_draw_pull_down_menu('cPath', tep_get_category_tree(), $current_category_id, 'onChange="this.form.submit();"'); echo "</form>\n"; echo "<!-- End Category Menu -->\n"; $sts->stop_capture('catmenu'); becki
Velveeta Posted March 14, 2007 Posted March 14, 2007 Hi, Thanks for your suggestions, i don't have any category drop down boxes etc, I found this code in sts_user_code.php which when i deleted it dropped all these queries - just need to find out if it is OK to delete it! $sts->start_capture(); echo "\n<!-- Start Category Menu -->\n"; echo tep_draw_form('goto', FILENAME_DEFAULT, 'get', ''); echo tep_draw_pull_down_menu('cPath', tep_get_category_tree(), $current_category_id, 'onChange="this.form.submit();"'); echo "</form>\n"; echo "<!-- End Category Menu -->\n"; $sts->stop_capture('catmenu'); becki Ahhhhhhh ok, you've got STS installed... Yeah it's probably for some kind of Quick Jump dropdown or something that some people have installed in their templates... If you don't have any such dropdown box, and just use the regular category display, then it should be save to get rid of, but rather than deleting it, you should just comment it out in case you decide in the future that you need it after all :) Richard. Richard Lindsey
Becki Posted March 14, 2007 Author Posted March 14, 2007 Ahhhhhhh ok, you've got STS installed... Yeah it's probably for some kind of Quick Jump dropdown or something that some people have installed in their templates... If you don't have any such dropdown box, and just use the regular category display, then it should be save to get rid of, but rather than deleting it, you should just comment it out in case you decide in the future that you need it after all :) Richard. Yes you are correct it turns out it's a drop down box and it can just go (well commented out!) Many Thanks Some more queries to get rid of next...! Becki
Recommended Posts
Archived
This topic is now archived and is closed to further replies.