- Posts: 5
- Thank you received: 0
Events booking causing runaway query
- Geoff
- Topic Author
- Offline
- New Member
-
Less
More
12 years 7 months ago - 12 years 7 months ago #19405
by Geoff
Events booking causing runaway query was created 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
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.
- Tuan Pham Ngoc
- Offline
- Administrator
-
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 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.
- Geoff
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 5
- Thank you received: 0
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
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.
- Geoff
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 5
- Thank you received: 0
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 .....
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.
- Tuan Pham Ngoc
- Offline
- Administrator
-
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
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.
- Tuan Pham Ngoc
- Offline
- Administrator
-
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
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
Support
Documentation
Information
Copyright © 2025 Joomla Extensions by Joomdonation. All Rights Reserved.
joomdonation.com is not affiliated with or endorsed by the Joomla! Project or Open Source Matters.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.