Is there a limit to how many redirects I can do in the URL Redirection feature? Do you think it is better performance-wise to do the 301's in the htaccess file?
#19248 Redirects Limit in URL Redirect?
Posted in ‘Admin Tools for Joomla! 4 & 5’
This is a public ticket
Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.
Environment Information
Joomla! version
n/a
PHP version
n/a
Admin Tools version
n/a
Latest post by on Sunday, 23 March 2014 18:00 CDT
Wednesday, 19 February 2014 10:27 CST
nicholas
Akeeba Staff
Manager
There is no limit. In general, the additional time required to load a page increases exponentially with the number of redirects. Up to 300 redirects this additional time is negligible on most hosts. After than point you may see a measurable (but not always perceptible) delay. Things are FAR WORSE when you use the .htaccess file for storing redirections. Since the .htaccess file has to be read, parsed and executed for every request (even CSS, Javascript and image files!) you will be adding 30-50 times as much page load time.
Nicholas K. Dionysopoulos
Lead Developer and Director
🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!
Wednesday, 19 February 2014 12:01 CST
theralph
So I suppose having 5,714 redirects is not a good thing. Hostgator shut me down as soon as I try for 5,715. :-(
My site has more than 25,000 pages and when we went to Joomla a few years back there were a lot of old links that I had to 301. The redirect feature of Admin Tools seemed perfect for this until now. :-(
Any ideas?
My site has more than 25,000 pages and when we went to Joomla a few years back there were a lot of old links that I had to 301. The redirect feature of Admin Tools seemed perfect for this until now. :-(
Any ideas?
Thursday, 20 February 2014 01:31 CST
nicholas
Akeeba Staff
Manager
I am pretty sure Hostgator shut you down for a different reason. Adding one more redirection in nearly 6,000 won't make that much of a change.
Nicholas K. Dionysopoulos
Lead Developer and Director
🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!
Thursday, 20 February 2014 09:57 CST
theralph
Fair enough.
It may have been too many IPs in the Blacklist.
Here is the email they sent me that made me suspect Admin Tools. For what it's worth, the site is back up and running smoothly after I deleted all the IPs on the site blacklist. :-)
---BEGIN HOSTGATOR EMAIL---
Thank you for contacting HostGator. The script did automatically suspend the account again. Table_rows_read went over the limit we have set in place on the server. After some investigation, we've discovered the following queries running on your site when table_rows_read hits or gets close to the limit:
FROM (
SELECT `l`.*,CASE COALESCE(`b`.`ip`, '0') WHEN '0' THEN '0' ELSE '1' END AS `block`
FROM `iytqf_admintools_log` AS `l`
LEFT OUTER JOIN `iytqf_admintools_ipblock` AS `b`ON (`b`.`ip` = `l`.`ip`)
WHERE `logdate` >= '2014-02-01 00:00:00' AND `logdate` <= '2014-02-28 23:59:59') AS a
SELECT `l`.*,CASE COALESCE(`b`.`ip`, '0') WHEN '0' THEN '0' ELSE '1' END AS `block`,DATE(`l`.`logdate`) AS `date`,COUNT(`l`.`id`) AS `exceptions`
FROM `iytqf_admintools_log` AS `l`
LEFT OUTER JOIN `iytqf_admintools_ipblock` AS `b`ON (`b`.`ip` = `l`.`ip`)
WHERE `logdate` >= '2014-01-19 00:00:00' AND `logdate` <= '2037-01-01 00:00:00'
GROUP BY DATE(`l`.`logdate`)
ORDER BY logdate DESC
This may not be the only query running that's causing issues, but your prediction may be correct in assuming Admin Tools Web Firewall may be causing issues. You may want to look into optimizing the database and the specific table. I have allowed access to the IP address you have logged in with. Once you are ready to have this reviewed, please let us know and we will be more than happy to review this for you.
---END HOSTGATOR EMAIL--
It may have been too many IPs in the Blacklist.
Here is the email they sent me that made me suspect Admin Tools. For what it's worth, the site is back up and running smoothly after I deleted all the IPs on the site blacklist. :-)
---BEGIN HOSTGATOR EMAIL---
Thank you for contacting HostGator. The script did automatically suspend the account again. Table_rows_read went over the limit we have set in place on the server. After some investigation, we've discovered the following queries running on your site when table_rows_read hits or gets close to the limit:
FROM (
SELECT `l`.*,CASE COALESCE(`b`.`ip`, '0') WHEN '0' THEN '0' ELSE '1' END AS `block`
FROM `iytqf_admintools_log` AS `l`
LEFT OUTER JOIN `iytqf_admintools_ipblock` AS `b`ON (`b`.`ip` = `l`.`ip`)
WHERE `logdate` >= '2014-02-01 00:00:00' AND `logdate` <= '2014-02-28 23:59:59') AS a
SELECT `l`.*,CASE COALESCE(`b`.`ip`, '0') WHEN '0' THEN '0' ELSE '1' END AS `block`,DATE(`l`.`logdate`) AS `date`,COUNT(`l`.`id`) AS `exceptions`
FROM `iytqf_admintools_log` AS `l`
LEFT OUTER JOIN `iytqf_admintools_ipblock` AS `b`ON (`b`.`ip` = `l`.`ip`)
WHERE `logdate` >= '2014-01-19 00:00:00' AND `logdate` <= '2037-01-01 00:00:00'
GROUP BY DATE(`l`.`logdate`)
ORDER BY logdate DESC
This may not be the only query running that's causing issues, but your prediction may be correct in assuming Admin Tools Web Firewall may be causing issues. You may want to look into optimizing the database and the specific table. I have allowed access to the IP address you have logged in with. Once you are ready to have this reviewed, please let us know and we will be more than happy to review this for you.
---END HOSTGATOR EMAIL--
Thursday, 20 February 2014 10:51 CST
nicholas
Akeeba Staff
Manager
This query only runs in the back-end of your site, when you visit Admin Tools' main page. It is used to produce the security exceptions graph. Also note that this is an OPTIMISED QUERY, using carefully engineered indices (keys) to minimise the impact on the server. If they knew how to do server management they'd see that both of these queries run in under 1 second each and are only called extremely rarely.
This is the latest in a series of stupid replies we've seen from Hostgator. These people do NOT know how to manage a server and are all too keen to shift blame. A couple of months ago they told a client of ours he's not allowed to run backups on his site.
My recommendation: switch to a decent host such as SiteGround, CloudAccess.net or Rochen. The cost is the same and the time you'll save by not having to deal with stupid problems caused by crappy costing will lend to huge savings. As with the previous two dozen people who were on a bad host, I will propose this bet: switch to SiteGround today, making use of the 3 months free special offer (see https://www.akeebabackup.com/free-joomla-hosting.html). If your problems don't go away I will pay for the rest of a year's worth of hosting from my own pocket.
This is the latest in a series of stupid replies we've seen from Hostgator. These people do NOT know how to manage a server and are all too keen to shift blame. A couple of months ago they told a client of ours he's not allowed to run backups on his site.
My recommendation: switch to a decent host such as SiteGround, CloudAccess.net or Rochen. The cost is the same and the time you'll save by not having to deal with stupid problems caused by crappy costing will lend to huge savings. As with the previous two dozen people who were on a bad host, I will propose this bet: switch to SiteGround today, making use of the 3 months free special offer (see https://www.akeebabackup.com/free-joomla-hosting.html). If your problems don't go away I will pay for the rest of a year's worth of hosting from my own pocket.
Nicholas K. Dionysopoulos
Lead Developer and Director
🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!
Thursday, 20 February 2014 13:07 CST
theralph
Thank you for these insights, Nicholas.
I used to be with Rochen but moved to Hostgator about a year ago based on a good friend's recommendation. Perhaps it is time to move back to Rochen.
Done.
I just migrated the site using Rochen's Joomla! Utilities and it seems all went well, except for one weird thing in the Admin Tools component.
When I access the component in the back end, I get the following line of code at the top:
drwxr-xr-x 3 theralph theralph 4096 Jan 3 15:14 . drwxr-xr-x 4 theralph theralph 4096 Jan 3 15:14 .. drwxr-xr-x 2 theralph theralph 4096 Jan 3 15:14 filesystem -rw-r--r-- 1 theralph theralph 18177 Jan 3 15:14 platform.php
theralph was my user name at Hostgator. My new user name with Rochen is wrmeacom.
The functionality of Admin Tools does not seem to be effected. Everything is working great. I do know that my Hostgator version of Joomla! was 2.5.17 and when I did the Migration over to Rochen they automatically upgraded me to Joomla 2.5.18. Do you any ideas on how to resolve this issue or is it even worth worrying about?
Best,
Ralph
I used to be with Rochen but moved to Hostgator about a year ago based on a good friend's recommendation. Perhaps it is time to move back to Rochen.
Done.
I just migrated the site using Rochen's Joomla! Utilities and it seems all went well, except for one weird thing in the Admin Tools component.
When I access the component in the back end, I get the following line of code at the top:
drwxr-xr-x 3 theralph theralph 4096 Jan 3 15:14 . drwxr-xr-x 4 theralph theralph 4096 Jan 3 15:14 .. drwxr-xr-x 2 theralph theralph 4096 Jan 3 15:14 filesystem -rw-r--r-- 1 theralph theralph 18177 Jan 3 15:14 platform.php
theralph was my user name at Hostgator. My new user name with Rochen is wrmeacom.
The functionality of Admin Tools does not seem to be effected. Everything is working great. I do know that my Hostgator version of Joomla! was 2.5.17 and when I did the Migration over to Rochen they automatically upgraded me to Joomla 2.5.18. Do you any ideas on how to resolve this issue or is it even worth worrying about?
Best,
Ralph
Thursday, 20 February 2014 16:31 CST
nicholas
Akeeba Staff
Manager
That line is very strange, indeed. The only way that could end up there is if there is a file with this string hardcoded in it. I would suggest trying to reinstall Admin Tools without uninstalling it first.
Nicholas K. Dionysopoulos
Lead Developer and Director
🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!
Thursday, 20 February 2014 16:45 CST
theralph
Thanks for the tip but that did not work. After reinstalling a fresh version of 2.6 Admin tools the line is still there. I also have the dreaded Database warning:
Database schema version (None) does not match CMS version (2.5.18).
Could those be related?
I am thinking it has something to do with the way Rochen migrated the site from Hostgator. Everything is working fine so I won't worry too much about it because even the Database schema error seems to be harmless from the info I have gathered.
Do you know where I might find the platform.php file?
On another note, if I wanted to export my redirect links from one site to another, which table would that be?
Database schema version (None) does not match CMS version (2.5.18).
Could those be related?
I am thinking it has something to do with the way Rochen migrated the site from Hostgator. Everything is working fine so I won't worry too much about it because even the Database schema error seems to be harmless from the info I have gathered.
Do you know where I might find the platform.php file?
On another note, if I wanted to export my redirect links from one site to another, which table would that be?
Friday, 21 February 2014 02:43 CST
nicholas
Akeeba Staff
Manager
There is one more thing you can try, but please be careful with these instructions: there be dragons!
First back up all tables with _admintools_ in their name, except the _admintools_logs one (it's only log data). You can do that with phpMyAdmin from Rochen's cPanel
Uninstall Admin Tools and reinstall it. BEWARE: Uninstalling Admin Tools removes ALL configuration parameters. I do mean remove: it does so permanently; they're gone; poof. That's why we backed up the tables in the first step.
Now restore the tables you had backed up in the first step.
If the problem persists it is unrelated to Admin Tools. This string does look like an FTP directory listing. Maybe you can ask the Rochen guys to search your site's files for an FTP connection to your old host?
First back up all tables with _admintools_ in their name, except the _admintools_logs one (it's only log data). You can do that with phpMyAdmin from Rochen's cPanel
Uninstall Admin Tools and reinstall it. BEWARE: Uninstalling Admin Tools removes ALL configuration parameters. I do mean remove: it does so permanently; they're gone; poof. That's why we backed up the tables in the first step.
Now restore the tables you had backed up in the first step.
If the problem persists it is unrelated to Admin Tools. This string does look like an FTP directory listing. Maybe you can ask the Rochen guys to search your site's files for an FTP connection to your old host?
Nicholas K. Dionysopoulos
Lead Developer and Director
🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!
Sunday, 23 March 2014 18:00 CDT
System Task
system
This ticket has been automatically closed. All tickets which have been inactive for a long time are automatically closed. If you believe that this ticket was closed in error, please contact us.