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

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>

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!

thanks for the reply, it turns out my databse was getting heavily hit from outside sources and doing weird things. It ended up being totally corrupted and restored from a backup and the issue is no longer there so the problem was at my end not yours.

Thanks for the reply. I have just created an order without setting the invoice number as you said and i worked fine, so i look forward to the update coming available with the fix

update: i have found that if i create the order with no products then it works, then i can add the products and update it. hope this helps