Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Can anyone tell me where these queries are coming from?


Becki

Recommended Posts

Posted

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

Posted

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

Posted
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

Posted

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

Posted
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

Posted
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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...