• 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]

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter broomfish

    (@broomfish)

    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!

    Thread Starter broomfish

    (@broomfish)

    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) between BEGIN WordPress and END 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>

    Thread Starter broomfish

    (@broomfish)

    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

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Adding to whitelist has caused 500 error *URGENT*’ is closed to new replies.