Can't delete weird query_selects__ logs via ftp...

[toomanyknots]

I have almost 10000 query_selects_ logs in my main logs folder. Everytime I try to delete them, which takes a while to delete every file, they come right back! I am not sure whats going on here. I am guessing there is a bug causing the logs to be created, but I wish I could at least delete them even if I can't figure out the bug. Does anyone know why they would be coming right back? I deleted myDEBUG logs from there fine. Here is what the log says:



I AM HERE
sidebox:

Explain
select configuration_key as cfgkey, configuration_value as cfgvalue
from product_type_layout;



I AM HERE
sidebox:

Explain
select code, title, symbol_left, symbol_right, decimal_point,
thousands_point, decimal_places, value
from currencies;

[mc12345678]

I have almost 10000 query_selects_ logs in my main logs folder. Everytime I try to delete them, which takes a while to delete every file, they come right back! I am not sure whats going on here. I am guessing there is a bug causing the logs to be created, but I wish I could at least delete them even if I can't figure out the bug. Does anyone know why they would be coming right back? I deleted myDEBUG logs from there fine. Here is what the log says:



I AM HERE
sidebox:

Explain
select configuration_key as cfgkey, configuration_value as cfgvalue
from product_type_layout;



I AM HERE
sidebox:

Explain
select code, title, symbol_left, symbol_right, decimal_point,
thousands_point, decimal_places, value
from currencies;

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....

[toomanyknots]

Well I guess I actually have 3 different query select logs which keep appearing and eating up the space I have with my hosting account. My hosting account is weird with data space, I don't understand it. I used cpanel to move the logs folder to the "trash" folder in the home directory, and my available data went from almost 20 GB to 9 GB, when the logs folder is only like 26 kb? I don't understand... but I know I must resolve this issue somehow. I tried permanently deleting the logs folder in cpanel as well, and it keeps coming back. In the mean time I have created a new logs folder with copies of the files essential files that were in there, and these are the new logs I get:



I AM HERE product_info
sidebox:

Explain
select languages_id, name, code, image, directory
from languages
order by sort_order;



I AM HERE product_info
sidebox:

Explain
select template_dir
from template_select
where template_language = 0;



I AM HERE product_info
sidebox:

Explain
select template_dir
from template_select
where template_language = '1';



I AM HERE product_info
sidebox:

Explain
select code
from currencies
where code = 'USD' LIMIT 1;



I AM HERE product_info
sidebox:

Explain
select count(*) as count
from whos_online
where session_id = '' and ip_address='207.46.13.90';



I AM HERE product_info
sidebox:

Explain
select banners_id, date_scheduled
from banners
where date_scheduled != 'NULL';



I AM HERE product_info
sidebox:

Explain
select b.banners_id, b.expires_date, b.expires_impressions,
sum(bh.banners_shown) as banners_shown
from banners b, banners_history bh
where b.status = 1
and b.banners_id = bh.banners_id
group by b.banners_id, b.expires_date, b.expires_impressions;



I AM HERE product_info
sidebox:

Explain
select specials_id, products_id
from specials
where status = '0'
and (((specials_date_available <= 20150328 and specials_date_available != '0001-01-01') and (expires_date > 20150328))
or ((specials_date_available <= 20150328 and specials_date_available != '0001-01-01') and (expires_date = '0001-01-01'))
or (specials_date_available = '0001-01-01' and expires_date > 20150328))
;



I AM HERE product_info
sidebox:

Explain
select specials_id, products_id
from specials
where status = '1'
and (20150328 < specials_date_available and specials_date_available != '0001-01-01')
;



I AM HERE product_info
sidebox:

Explain
select specials_id, products_id
from specials
where status = '1'
and ((20150328 >= expires_date and expires_date != '0001-01-01')
or (20150328 < specials_date_available and specials_date_available != '0001-01-01'));



I AM HERE product_info
sidebox:

Explain
select featured_id
from featured
where status = '0'
and (((featured_date_available <= 20150328 and featured_date_available != '0001-01-01') and (expires_date > 20150328))
or ((featured_date_available <= 20150328 and featured_date_available != '0001-01-01') and (expires_date = '0001-01-01'))
or (featured_date_available = '0001-01-01' and expires_date > 20150328))
;



I AM HERE product_info
sidebox:

Explain
select featured_id
from featured
where status = '1'
and (20150328 < featured_date_available and featured_date_available != '0001-01-01')
;



I AM HERE product_info
sidebox:

Explain
select featured_id
from featured
where status = '1'
and ((20150328 >= expires_date and expires_date != '0001-01-01')
or (20150328 < featured_date_available and featured_date_available != '0001-01-01'));



I AM HERE product_info
sidebox:

Explain
select sale_id
from salemaker_sales
where sale_status = '0'
and (((sale_date_start <= 20150328 and sale_date_start != '0001-01-01') and (sale_date_end > 20150328))
or ((sale_date_start <= 20150328 and sale_date_start != '0001-01-01') and (sale_date_end = '0001-01-01'))
or (sale_date_start = '0001-01-01' and sale_date_end > 20150328))
;



I AM HERE product_info
sidebox:

Explain
select sale_id
from salemaker_sales
where sale_status = '1'
and (20150328 < sale_date_start and sale_date_start != '0001-01-01')
;



I AM HERE product_info
sidebox:

Explain
select sale_id
from salemaker_sales
where sale_status = '1'
and ((20150328 >= sale_date_end and sale_date_end != '0001-01-01')
or (20150328 < sale_date_start and sale_date_start != '0001-01-01'));



I AM HERE product_info
sidebox:

Explain
select * from get_terms_to_filter;



I AM HERE product_info
sidebox:

Explain
select p.products_id, p.master_categories_id
from products p
where p.products_id = '147' limit 1;



I AM HERE product_info
sidebox:

Explain
select parent_id
from categories
where categories_id = '47';



I AM HERE product_info
sidebox:

Explain
select parent_id
from categories
where categories_id = '16';



I AM HERE product_info
sidebox:

Explain
select categories_name
from categories_description
where categories_id = '16'
and language_id = '1';



I AM HERE product_info
sidebox:

Explain
select categories_name
from categories_description
where categories_id = '47'
and language_id = '1';



I AM HERE product_info
sidebox:

Explain
select *
from get_terms_to_filter;



I AM HERE product_info
sidebox:

Explain
select products_name
from products_description
where products_id = '147'
and language_id = '1';



I AM HERE product_info
sidebox:

Explain
select products_type from products where products_id = '147';



I AM HERE product_info
sidebox:

Explain
select type_handler from product_types where type_id = '1';



I AM HERE product_info
sidebox:

Explain
SELECT project_version_major, project_version_minor FROM project_version WHERE project_version_key = 'Zen-Cart Database';



I AM HERE product_info
sidebox:

Explain
select count(*) as total
from products p, products_description pd
where p.products_status = '1'
and p.products_id = '147'
and pd.products_id = p.products_id
and pd.language_id = '1';



I AM HERE product_info
sidebox:

Explain
select cd.categories_name from categories c, categories_description cd where c.parent_id = 0 and c.categories_id = cd.categories_id and cd.language_id='1' and c.categories_status=1;



I AM HERE product_info
sidebox:

Explain
select pd.products_name, p.products_model, p.products_price_sorter, p.products_tax_class_id,
p.metatags_title_status, p.metatags_products_name_status, p.metatags_model_status,
p.products_id, p.metatags_price_status, p.metatags_title_tagline_status,
pd.products_description, p.product_is_free, p.product_is_call,
mtpd.metatags_title, mtpd.metatags_keywords, mtpd.metatags_description
from (products p, products_description pd) left join meta_tags_products_description mtpd on mtpd.products_id = p.products_id and mtpd.language_id = '1'
where p.products_id = '147'
and p.products_id = pd.products_id
and pd.language_id = '1';



I AM HERE product_info
sidebox:

Explain
select products_tax_class_id, products_price, products_priced_by_attribute, product_is_free, product_is_call from products where products_id = '147' limit 1;



I AM HERE product_info
sidebox:

Explain
select products_price, products_priced_by_attribute from products where products_id = '147';



I AM HERE product_info
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 products_attributes where products_id = '147' and attributes_display_only != '1' and attributes_price_base_included='1' order by options_id, value;



I AM HERE product_info
sidebox:

Explain
select products_price, products_model, products_priced_by_attribute from products where products_id = '147';



I AM HERE product_info
sidebox:

Explain
select products_price, products_priced_by_attribute from products where products_id = '147';



I AM HERE product_info
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 products_attributes where products_id = '147' and attributes_display_only != '1' and attributes_price_base_included='1' order by options_id, value;



I AM HERE product_info
sidebox:

Explain
select specials_new_products_price from specials where products_id = '147' and status='1';



I AM HERE product_info
sidebox:

Explain
select products_price, products_model, products_priced_by_attribute from products where products_id = '147';



I AM HERE product_info
sidebox:

Explain
select products_price, products_priced_by_attribute from products where products_id = '147';



I AM HERE product_info
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 products_attributes where products_id = '147' and attributes_display_only != '1' and attributes_price_base_included='1' order by options_id, value;



I AM HERE product_info
sidebox:

Explain
select specials_new_products_price from specials where products_id = '147' and status='1';



I AM HERE product_info
sidebox:

Explain
select master_categories_id from products where products_id = '147';



I AM HERE product_info
sidebox:

Explain
select sale_specials_condition, sale_deduction_value, sale_deduction_type from salemaker_sales where sale_categories_all like '%,47,%' 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 <= '189.9500' or sale_pricerange_from = '0') and (sale_pricerange_to >= '189.9500' or sale_pricerange_to = '0');



I AM HERE product_info
sidebox:

Explain
select sum(tax_rate) as tax_rate
from (tax_rates tr
left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id)
left join 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 = '223')
and (za.zone_id is null
or za.zone_id = 0
or za.zone_id = '47')
and tr.tax_class_id = '0'
group by tr.tax_priority;

[toomanyknots]

And this one:



I AM HERE index
sidebox:

Explain
select languages_id, name, code, image, directory
from languages
order by sort_order;



I AM HERE index
sidebox:

Explain
select template_dir
from template_select
where template_language = 0;



I AM HERE index
sidebox:

Explain
select template_dir
from template_select
where template_language = '1';



I AM HERE index
sidebox:

Explain
select code
from currencies
where code = 'USD' LIMIT 1;



I AM HERE index
sidebox:

Explain
select count(*) as count
from whos_online
where session_id = '' and ip_address='208.115.111.74';



I AM HERE index
sidebox:

Explain
select banners_id, date_scheduled
from banners
where date_scheduled != 'NULL';



I AM HERE index
sidebox:

Explain
select b.banners_id, b.expires_date, b.expires_impressions,
sum(bh.banners_shown) as banners_shown
from banners b, banners_history bh
where b.status = 1
and b.banners_id = bh.banners_id
group by b.banners_id, b.expires_date, b.expires_impressions;



I AM HERE index
sidebox:

Explain
select specials_id, products_id
from specials
where status = '0'
and (((specials_date_available <= 20150328 and specials_date_available != '0001-01-01') and (expires_date > 20150328))
or ((specials_date_available <= 20150328 and specials_date_available != '0001-01-01') and (expires_date = '0001-01-01'))
or (specials_date_available = '0001-01-01' and expires_date > 20150328))
;



I AM HERE index
sidebox:

Explain
select specials_id, products_id
from specials
where status = '1'
and (20150328 < specials_date_available and specials_date_available != '0001-01-01')
;



I AM HERE index
sidebox:

Explain
select specials_id, products_id
from specials
where status = '1'
and ((20150328 >= expires_date and expires_date != '0001-01-01')
or (20150328 < specials_date_available and specials_date_available != '0001-01-01'));



I AM HERE index
sidebox:

Explain
select featured_id
from featured
where status = '0'
and (((featured_date_available <= 20150328 and featured_date_available != '0001-01-01') and (expires_date > 20150328))
or ((featured_date_available <= 20150328 and featured_date_available != '0001-01-01') and (expires_date = '0001-01-01'))
or (featured_date_available = '0001-01-01' and expires_date > 20150328))
;



I AM HERE index
sidebox:

Explain
select featured_id
from featured
where status = '1'
and (20150328 < featured_date_available and featured_date_available != '0001-01-01')
;



I AM HERE index
sidebox:

Explain
select featured_id
from featured
where status = '1'
and ((20150328 >= expires_date and expires_date != '0001-01-01')
or (20150328 < featured_date_available and featured_date_available != '0001-01-01'));



I AM HERE index
sidebox:

Explain
select sale_id
from salemaker_sales
where sale_status = '0'
and (((sale_date_start <= 20150328 and sale_date_start != '0001-01-01') and (sale_date_end > 20150328))
or ((sale_date_start <= 20150328 and sale_date_start != '0001-01-01') and (sale_date_end = '0001-01-01'))
or (sale_date_start = '0001-01-01' and sale_date_end > 20150328))
;



I AM HERE index
sidebox:

Explain
select sale_id
from salemaker_sales
where sale_status = '1'
and (20150328 < sale_date_start and sale_date_start != '0001-01-01')
;



I AM HERE index
sidebox:

Explain
select sale_id
from salemaker_sales
where sale_status = '1'
and ((20150328 >= sale_date_end and sale_date_end != '0001-01-01')
or (20150328 < sale_date_start and sale_date_start != '0001-01-01'));



I AM HERE index
sidebox:

Explain
select categories_name
from categories_description
where categories_id = '11'
and language_id = '1';



I AM HERE index
sidebox:

Explain
select *
from get_terms_to_filter;



I AM HERE index
sidebox:

Explain
SELECT project_version_major, project_version_minor FROM project_version WHERE project_version_key = 'Zen-Cart Database';



I AM HERE index
sidebox:

Explain
SELECT count(*) AS total
FROM products_to_categories
WHERE categories_id = 11;





And this one:



I AM HERE
sidebox:

Explain
select configuration_key as cfgkey, configuration_value as cfgvalue
from product_type_layout;



I AM HERE
sidebox:

Explain
select code, title, symbol_left, symbol_right, decimal_point,
thousands_point, decimal_places, value
from currencies;

[toomanyknots]

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....

THANK YOU SO MUCH! I love this forum!

Daniel

[mc12345678]

THANK YOU SO MUCH! I love this forum!

Daniel

Welcome. The intent of. Those logs is to well see what is going on to reference the database and shouldn't be left on for a live site. I found it was an issue where the site began to slow down, I had difficulty logging into the admin panel and I couldn't even pull up the directory (was cache at the time when using ZC 1.5.0) to be able see what all was going on.

Anyways, be sure that you still have the applicable directories for your store.

Also in the future, if posting code or long sections of text such as the above, could you frame the information in CODE tags by using the # symbol above the text entry box? Makes reading the information on screen a lot easier. :)


Glad you got it fixed though!