Site maintenance: Sun 15 Nov, from 12:00 UTC, about 4–6 hours. Details

This cutover relies on some testing that is still incomplete so may be cancelled at short notice

Forums / General Questions / Files in /Cache folder saying "I AM HERE shopping_cart" what are they?

Files in /Cache folder saying "I AM HERE shopping_cart" what are they?

Started by nigelt74 on 6 Apr 2015, 11:35 PM · Views: 650

Results 1 to 3 of 3
6 Apr 2015, 11:35 PM
#1
nigelt74 avatar

nigelt74

Totally Zenned

Join Date:
Sep 2005
Location:
Waikato, New Zealand
Posts:
1,558
Plugin Contributions:
1

Files in /Cache folder saying "I AM HERE shopping_cart" what are they?

recently moved hosting, went to look at the cache folder and found hundreds of these files basically like the below

note this is only part of one file

names like
query_selects_shopping_cart_1428321898.txt

I AM HERE shopping_cart
sidebox: 

Explain 
select options_id, price_prefix, options_values_price, attributes_display_only, attributes_price_base_included, round(concat(price_prefix, options_values_price), 5) as value from zen_products_attributes where products_id = '13' and attributes_display_only != '1' and attributes_price_base_included='1' order by options_id, value;



I AM HERE shopping_cart
sidebox: 

Explain 
select specials_new_products_price from zen_specials where products_id = '13' and status='1';



I AM HERE shopping_cart
sidebox: 

Explain 
select master_categories_id from zen_products where products_id = '13';



I AM HERE shopping_cart
sidebox: 

Explain 
select sale_specials_condition, sale_deduction_value, sale_deduction_type from zen_salemaker_sales where sale_categories_all like '%,3,%' and sale_status = '1' and (sale_date_start <= now() or sale_date_start = '0001-01-01') and (sale_date_end >= now() or sale_date_end = '0001-01-01') and (sale_pricerange_from <= '28.9500' or sale_pricerange_from = '0') and (sale_pricerange_to >= '28.9500' or sale_pricerange_to = '0');



I AM HERE shopping_cart
sidebox: 

Explain 
select product_is_free from zen_products where products_id = '13' limit 1;



I AM HERE shopping_cart
sidebox: 

Explain 
select products_id, products_price, products_tax_class_id, products_weight,
                          products_priced_by_attribute, product_is_always_free_shipping, products_discount_type, products_discount_type_from,
                          products_virtual, products_model
                          from zen_products
                          where products_id = '13';



I AM HERE shopping_cart
sidebox: 

Explain 
select sum(tax_rate) as tax_rate
                  from (zen_tax_rates tr
                  left join zen_zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id)
                  left join zen_geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) )
                  where (za.zone_country_id is null
                  or za.zone_country_id = 0
                  or za.zone_country_id = '13')
                  and (za.zone_id is null
                  or za.zone_id = 0
                  or za.zone_id = '189')
                  and tr.tax_class_id = '0'
                  group by tr.tax_priority;

Webzings Design
Semi retired from Web Design

6 Apr 2015, 11:40 PM
#2
nigelt74 avatar

nigelt74

Totally Zenned

Join Date:
Sep 2005
Location:
Waikato, New Zealand
Posts:
1,558
Plugin Contributions:
1

Re: Files in /Cache folder saying "I AM HERE shopping_cart" what are they?

Ignore me, forgot I had turned on logging

http://www.zen-cart.com/showthread.php?216727-Can-t-delete-weird-query_selects__-logs-via-ftp&p=1277646#post1277646

mc12345678:

Yeah, did that once. In the admin there is a configuration option that logs all queries... You have that on...

Goto: configuration->logging
Then select log database queries and set it to false.
Then try to delete the files....

Webzings Design
Semi retired from Web Design

7 Apr 2015, 12:00 AM
#3
nigelt74 avatar

nigelt74

Totally Zenned

Join Date:
Sep 2005
Location:
Waikato, New Zealand
Posts:
1,558
Plugin Contributions:
1

Re: Files in /Cache folder saying "I AM HERE shopping_cart" what are they?

Well that didn't work, everything was already set to false

but what i noticed on that page was that the "Log Destination" was still set at the old location

and yes I had updated my config files and run the "Update Cache Key" doo hickey when moving servers, so I am not sure why that didnt update

Webzings Design
Semi retired from Web Design