Events booking causing runaway query

More
12 years 7 months ago - 12 years 7 months ago #19405 by Geoff
I have a problem with googlebot spidering deleted events in the EB mini calendar on my home page. When an past event is removed from the calendar or when an event is deleted if a user or a bot tries to go to the calendar URL it triggers a loop in which a script continues to call the deleted event until the database log fills up and the server falls over.

My hosting company is understandably getting a bit unhappy and threatening to throw me off the server. I'm using Joomla 2.5, Events Booking, IceMegaMenu and SLIcomments. Everything is vanila and I've not modified any code.

In the logs below you can see this happening after a request to

/index.php/component/eventbooking/?view=calendar&month=12&Itemid=159

Which I stopped by editing robots.txt, however now the same thing is happening with requests to

/index.php?option=com_eventbooking&task=view_calendar&month=10&year=2014&Itemid=159

Robots.txt is not a long term solution. Unfortunately I have no way to easily determine which script is causing this. Please help or I will be forced to drop OSSolutions for an alternative booking engine.

Regards
Geoff
Attachments:
Last edit: 12 years 7 months ago by Geoff. Reason: files did not attach

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

More
12 years 7 months ago #19406 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Re: Events booking causing runaway query
Hi

Please try the solution below :

1. Open the file components/com_eventbooking/views/event/view.html.php

2. Find the code below (around line 61)

$mainframe->redirect('index.php?option=com_eventbooking&Itemid='.$Itemid, JText::_('EB_INVALID_EVENT'));

3. Change it to :

$mainframe->redirect('index.php');

After that, the issue should be solved !

Tuan

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

More
12 years 7 months ago #19410 by Geoff
Replied by Geoff on topic Re: Events booking causing runaway query
Oops....

Yes, that would do it every time. I cannot be the first user to have run into this problem ?

Anyway many thanks thanks for the fast turn around.

Geoff

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

More
12 years 7 months ago #19411 by Geoff
Replied by Geoff on topic Re: Events booking causing runaway query
Hmmmm,

I spoke too soon. I've made that change, but I can still consistently crash the database by requesting those URLs. There must be somewhere else in the code where the same logic exists .....

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

More
12 years 7 months ago #19431 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Re: Events booking causing runaway query
Hi Geoff

Could you please contact me via Skype so that we can discuss about the issue together and solve it ? My Skype nickname is tuanpnves.

Looking forward to hearing from you.

Regards,

Tuan

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

More
12 years 7 months ago #19447 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Re: Events booking causing runaway query
Hi Geoff

I saw that you tried to call me on Skype. However, I don't have a phone and could not answer you. Could you please accept my contact request so that we can chat ?

Tuan

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

Moderators: Tuan Pham Ngoc