- Posts: 15
COMMUNITY FORUM
Database problems
- Jany Enseñat
-
Topic Author
- Offline
- New Member
Less
More
10 years 8 months ago #131642
by Jany Enseñat
Amante de la vida y apasionada por la informática.
Database problems was created by Jany Enseñat
Hello friends ... I am writing because I need your help ... Since a time ago from my hosting are warning me that the site is generating too many queries to the DB server to the point that pervades and the database server collapses ... that quieries are repeated every half second and that is unstoppable ... I leave you here a line of them so that you can tell me if you know what this is? He has given me to think that I have been the victim of some sql injection because this query does not make much sense ... I do not know ... I need opinions please ...
This is the query:
SELECT COUNT(*) FROM bbb_k2_items WHERE YEAR(created)=2014 AND MONTH(created)=7 AND DAY(created)=29 AND published=1 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2014-07-31 17:55:09' ) AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2014-07-31 17:55:09' ) AND trash=0 AND access IN(1,1) AND EXISTS(SELECT * FROM bbb_k2_categories WHERE id= bbb_k2_items.catid AND published=1 AND trash=0 AND access IN(1,1) )
This is the query:
SELECT COUNT(*) FROM bbb_k2_items WHERE YEAR(created)=2014 AND MONTH(created)=7 AND DAY(created)=29 AND published=1 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2014-07-31 17:55:09' ) AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2014-07-31 17:55:09' ) AND trash=0 AND access IN(1,1) AND EXISTS(SELECT * FROM bbb_k2_categories WHERE id= bbb_k2_items.catid AND published=1 AND trash=0 AND access IN(1,1) )
Amante de la vida y apasionada por la informática.
Please Log in or Create an account to join the conversation.
- Krikor Boghossian
-
- Offline
- Platinum Member
Less
More
- Posts: 15920
10 years 8 months ago #131643
by Krikor Boghossian
Replied by Krikor Boghossian on topic Re: Database problems
This query selects all the published posts written on 29/7/2014.
It does make sense but the time frequency does not.
Are you displaying posts by day in your site?
Are you using any caching for your site?
It does make sense but the time frequency does not.
Are you displaying posts by day in your site?
Are you using any caching for your site?
Please Log in or Create an account to join the conversation.
- Jany Enseñat
-
Topic Author
- Offline
- New Member
Less
More
- Posts: 15
10 years 8 months ago #131644
by Jany Enseñat
Amante de la vida y apasionada por la informática.
Replied by Jany Enseñat on topic Re: Database problems
Well i don´t know, but i don´t have any module in my website that can be doing that queries...
Can be the CLOUD TAGS module do all those queries? Can you please take a look of my website?? www.5septiembre.cu
I´m so so worried about that...
Can be the CLOUD TAGS module do all those queries? Can you please take a look of my website?? www.5septiembre.cu
I´m so so worried about that...
Amante de la vida y apasionada por la informática.
Please Log in or Create an account to join the conversation.
- Jany Enseñat
-
Topic Author
- Offline
- New Member
Less
More
- Posts: 15
10 years 8 months ago #131645
by Jany Enseñat
Amante de la vida y apasionada por la informática.
Replied by Jany Enseñat on topic Re: Database problems
I´ve found this....
github.com/joomlaworks/k2/issues/48
Can i do all those changes... that´s what is happening me in my website...how can a i fix it?
Are those changes trustfull?
Waiting for your answer!!!
github.com/joomlaworks/k2/issues/48
Can i do all those changes... that´s what is happening me in my website...how can a i fix it?
Are those changes trustfull?
Waiting for your answer!!!
Amante de la vida y apasionada por la informática.
Please Log in or Create an account to join the conversation.