Keyword

Database problems

  • Jany Enseñat
  • Jany Enseñat's Avatar Topic Author
  • Offline
  • New Member
More
10 years 3 weeks ago #131642 by Jany Enseñat
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) )

Amante de la vida y apasionada por la informática.

Please Log in or Create an account to join the conversation.

  • Krikor Boghossian
  • Krikor Boghossian's Avatar
  • Offline
  • Platinum Member
More
10 years 3 weeks 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?

JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

Please Log in or Create an account to join the conversation.

  • Jany Enseñat
  • Jany Enseñat's Avatar Topic Author
  • Offline
  • New Member
More
10 years 3 weeks ago #131644 by Jany Enseñat
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...

Amante de la vida y apasionada por la informática.

Please Log in or Create an account to join the conversation.

  • Jany Enseñat
  • Jany Enseñat's Avatar Topic Author
  • Offline
  • New Member
More
10 years 3 weeks ago #131645 by Jany Enseñat
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!!!

Amante de la vida y apasionada por la informática.

Please Log in or Create an account to join the conversation.


Powered by Kunena Forum