Adding to whitelist has caused 500 error *URGENT*
-
I added an Ip address to the whitelist
#RC Reviews
18.210.171.51
and instantly got a 500 error and my site crashed. Can you please tell me where the whitelist is stored in the database so i can try and fix this without having to pay my hoster $100 to restore from backup.The page I need help with: [log in to see the link]
-
I have located the table in the database with the whitelist and removed that entry yet i still have a 500 database error. Please find what has caused this so i can fix it without having to pay the restore cost. This is URGENT!
i have found the issue. It was in the htaccess file that your plugin writes to.
Here is the file conents, please find the issue and fix it
# BEGIN WpGeoProtection
<IfModule mod_rewrite.c>
RewriteEngine On
RewriteCond %{REMOTE_ADDR} !^185\.72\.157\.169$ [NC]
RewriteCond %{REMOTE_ADDR} !^185\.72\.157\.170$ [NC]
RewriteCond %{REMOTE_ADDR} !^185\.72\.157\.171$ [NC]
RewriteCond %{REMOTE_ADDR} !^185\.72\.157\.172$ [NC]
RewriteCond %{REMOTE_ADDR} !^185\.72\.157\.173$ [NC]
RewriteCond %{REMOTE_ADDR} !^78\.87\.3\.20$ [NC]
RewriteCond %{REMOTE_ADDR} !^#CR Reviews$ [NC]
RewriteCond %{REMOTE_ADDR} !^18\.210\.171\.51$ [NC]
RewriteCond %{REMOTE_ADDR} !^#Auttomatic$ [NC]
RewriteCond %{REMOTE_ADDR} !^192\.0\.91\.177$ [NC]
RewriteCond %{REMOTE_ADDR} !^#Hosthaste$ [NC]
RewriteCond %{REMOTE_ADDR} !^67\.222\.145\.75$ [NC]
RewriteCond %{REMOTE_ADDR} !^202\.89\.55\.189$ [NC]
RewriteCond %{REMOTE_ADDR} !^202\.169\.196\.35$ [NC]
RewriteCond %{REMOTE_ADDR} !^#Onesaas$ [NC]
RewriteCond %{REMOTE_ADDR} !^23\.96\.253\.10$ [NC]
RewriteCond %{REMOTE_ADDR} !^168\.62\.106\.47$ [NC]
RewriteCond %{REMOTE_ADDR} !^65\.52\.220\.123$ [NC]
RewriteCond %{REMOTE_ADDR} !^65\.52\.192\.52$ [NC]
RewriteCond %{REMOTE_ADDR} !^168\.62\.247\.114$ [NC]
RewriteCond %{REMOTE_ADDR} !^52\.162\.107\.6$ [NC]
RewriteCond %{REMOTE_ADDR} !^23\.96\.246\.18$ [NC]
RewriteCond %{REMOTE_ADDR} !^65\.52\.218\.202$ [NC]
RewriteCond %{REMOTE_ADDR} !^65\.52\.220\.61$ [NC]
RewriteCond %{REMOTE_ADDR} !^65\.52\.221\.146$ [NC]
RewriteCond %{REMOTE_ADDR} !^52\.237\.130\.0$ [NC]
RewriteCond %{REMOTE_ADDR} !^52\.162\.246\.120$ [NC]
RewriteCond %{REMOTE_ADDR} !^52\.162\.244\.187$ [NC]
RewriteCond %{REMOTE_ADDR} !^52\.237\.159\.88$ [NC]
RewriteCond %{REMOTE_ADDR} !^52\.162\.243\.157$ [NC]
RewriteCond %{REMOTE_ADDR} !^104\.43\.129\.105$ [NC]
RewriteCond %{REMOTE_ADDR} !^23\.99\.133\.255$ [NC]
RewriteCond %{REMOTE_ADDR} !^23\.99\.133\.126$ [NC]
RewriteCond %{REMOTE_ADDR} !^23\.99\.129\.118$ [NC]
RewriteCond %{REMOTE_ADDR} !^23\.99\.133\.195$ [NC]
RewriteCond %{REMOTE_ADDR} !^13\.70\.123\.149$ [NC]
RewriteCond %{REMOTE_ADDR} !^13\.70\.127\.209$ [NC]
RewriteCond %{REMOTE_ADDR} !^13\.70\.120\.58$ [NC]
RewriteCond %{REMOTE_ADDR} !^13\.70\.123\.216$ [NC]
RewriteCond %{REMOTE_ADDR} !^13\.70\.120\.27$ [NC]
RewriteCond %{REMOTE_ADDR} !^#Paypal$ [NC]
RewriteCond %{REMOTE_ADDR} !^64\.4\.248\.23$ [NC]
RewriteCond %{REMOTE_ADDR} !^64\.4\.249\.23$ [NC]
RewriteCond %{REMOTE_ADDR} !^66\.211\.168\.91$ [NC]
RewriteCond %{REMOTE_ADDR} !^66\.211\.168\.123$ [NC]
RewriteCond %{REMOTE_ADDR} !^173\.0\.84\.66$ [NC]
RewriteCond %{REMOTE_ADDR} !^173\.0\.84\.98$ [NC]
RewriteCond %{REMOTE_ADDR} !^173\.0\.88\.66$ [NC]
RewriteCond %{REMOTE_ADDR} !^173\.0\.88\.98$ [NC]
RewriteCond %{REMOTE_ADDR} !^173\.0\.92\.23$ [NC]
RewriteCond %{REMOTE_ADDR} !^173\.0\.93\.23$ [NC]
RewriteCond %{REMOTE_ADDR} !^66\.211\.170\.66$ [NC]
RewriteCond %{REMOTE_ADDR} !^173\.0\.81\.[0-9]{1,3}$ [NC]
RewriteCond %{REMOTE_ADDR} !^#GoogleBot$ [NC]
RewriteCond %{REMOTE_ADDR} !^64\.233\.[0-9]{1,3}\.[0-9]{1,3}$ [NC]
RewriteCond %{REMOTE_ADDR} !^66\.102\.[0-9]{1,3}\.[0-9]{1,3}$ [NC]
RewriteCond %{REMOTE_ADDR} !^66\.249\.[0-9]{1,3}\.[0-9]{1,3}$ [NC]
RewriteCond %{REMOTE_ADDR} !^72\.14\.[0-9]{1,3}\.[0-9]{1,3}$ [NC]
RewriteCond %{REMOTE_ADDR} !^74\.125\.[0-9]{1,3}\.[0-9]{1,3}$ [NC]
RewriteCond %{REMOTE_ADDR} !^209\.85\.[0-9]{1,3}\.[0-9]{1,3}$ [NC]
RewriteCond %{REMOTE_ADDR} !^216\.239\.[0-9]{1,3}\.[0-9]{1,3}$ [NC]
RewriteCond %{REMOTE_ADDR} !^#BingBot$ [NC]
RewriteCond %{REMOTE_ADDR} !^104\.146\.[0-9]{1,3}\.[0-9]{1,3}$ [NC]
RewriteCond %{REMOTE_ADDR} !^#MSNBot$ [NC]
RewriteCond %{REMOTE_ADDR} !^64\.4\.[0-9]{1,3}\.[0-9]{1,3}$ [NC]
RewriteCond %{REMOTE_ADDR} !^65\.52\.[0-9]{1,3}\.[0-9]{1,3}$ [NC]
RewriteCond %{REMOTE_ADDR} !^65\.53\.[0-9]{1,3}\.[0-9]{1,3}$ [NC]
RewriteCond %{REMOTE_ADDR} !^65\.54\.[0-9]{1,3}\.[0-9]{1,3}$ [NC]
RewriteCond %{REMOTE_ADDR} !^131\.253\.[0-9]{1,3}\.[0-9]{1,3}$ [NC]
RewriteCond %{REMOTE_ADDR} !^157\.54\.[0-9]{1,3}\.[0-9]{1,3}$ [NC]
RewriteCond %{REMOTE_ADDR} !^207\.46\.[0-9]{1,3}\.[0-9]{1,3}$ [NC]
RewriteCond %{REMOTE_ADDR} !^207\.68\.[0-9]{1,3}\.[0-9]{1,3}$ [NC]
RewriteCond %{REMOTE_ADDR} !^#Yahoo$ [NC]
RewriteCond %{REMOTE_ADDR} !^8\.12\.144\.[0-9]{1,3}$ [NC]
RewriteCond %{REMOTE_ADDR} !^66\.196\.[0-9]{1,3}\.[0-9]{1,3}$ [NC]
RewriteCond %{REMOTE_ADDR} !^66\.228\.[0-9]{1,3}\.[0-9]{1,3}$ [NC]
RewriteCond %{REMOTE_ADDR} !^67\.195\.[0-9]{1,3}\.[0-9]{1,3}$ [NC]
RewriteCond %{REMOTE_ADDR} !^68\.142\.[0-9]{1,3}\.[0-9]{1,3}$ [NC]
RewriteCond %{REMOTE_ADDR} !^72\.30\.[0-9]{1,3}\.[0-9]{1,3}$ [NC]
RewriteCond %{REMOTE_ADDR} !^74\.6\.[0-9]{1,3}\.[0-9]{1,3}$ [NC]
RewriteCond %{REMOTE_ADDR} !^98\.136\.[0-9]{1,3}\.[0-9]{1,3}$ [NC]
RewriteCond %{REMOTE_ADDR} !^98\.137\.[0-9]{1,3}\.[0-9]{1,3}$ [NC]
RewriteCond %{REMOTE_ADDR} !^98\.138\.[0-9]{1,3}\.[0-9]{1,3}$ [NC]
RewriteCond %{REMOTE_ADDR} !^98\.139\.[0-9]{1,3}\.[0-9]{1,3}$ [NC]
RewriteCond %{REMOTE_ADDR} !^202\.160\.[0-9]{1,3}\.[0-9]{1,3}$ [NC]
RewriteCond %{REMOTE_ADDR} !^209\.191\.[0-9]{1,3}\.[0-9]{1,3}$ [NC]
RewriteCond %{REMOTE_ADDR} !^#YandexBot$ [NC]
RewriteCond %{REMOTE_ADDR} !^100\.43\.[0-9]{1,3}\.[0-9]{1,3}$ [NC]
RewriteCond %{REQUEST_URI} !\.(webm|ogg|mp4|ico|pdf|flv|jpg|jpeg|png|gif|webp|js|css|swf|x-html|css|xml|js|woff|woff2|ttf|svg|eot|less|cur)$ [NC]
RewriteCond %{HTTP_USER_AGENT} !(googlebot|msnbot|Surp|bingbot|yahoo|yandex) [NC]
RewriteCond %{HTTP:Cookie} !geo_check [NC]
RewriteRule . index.php [L]
</IfModule># END WpGeoProtection
# BEGIN WordPress
# The directives (lines) betweenBEGIN WordPress
andEND WordPress
are
# dynamically generated, and should only be modified via WordPress filters.
# Any changes to the directives between these markers will be overwritten.
<IfModule mod_rewrite.c>
RewriteEngine On
RewriteBase /
RewriteRule ^index\.php$ – [L]
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule . /index.php [L]
</IfModule># END WordPress
<Files 403.shtml>
order allow,deny
allow from all
</Files>removing this from the htaccess file has stopped all of the error messages at the top of the screen also, not sure if the block is actually working at the moment though, so you definitly need to clean up the code here
- The topic ‘Adding to whitelist has caused 500 error *URGENT*’ is closed to new replies.