SQL errors - CloudFlare IP address in logs

Ever since last night I have been getting SQL errors on my domain like :-1:
[17-Jan-2020 10:25:06] SQL error:
Site : https://www.mydomain.com/shop
Remote IP : 141.101.98.101
Logged as :
SQL query :
SELECT
xcart_product_reviews.*, IF (xcart_product_reviews.remote_ip = β€˜141.101.98.101’, β€˜Y’, β€˜N’) AS is_own_review, (total_amount_vote-useful_amount_vote) AS not_useful_amount_vote, (xcart_product_review_votes.remote_ip) AS is_voted, xcart_product_review_votes.vote
FROM
xcart_product_reviews
INNER JOIN xcart_products ON xcart_product_reviews.productid = xcart_products.productid INNER JOIN xcart_products_categories ON xcart_product_reviews.productid = xcart_products_categories.productid

etc
The IP address is a CloudFlare address. Nothing has changed on my domain, the sql server on the domain is fine, no disk space issues and nothing has been changed or updated. So I’m just wondering if it’s a CloudFlare issue ?

You need to rewrite IP addresses, either on a webserver level or - less preferably - on an application level.

https://support.cloudflare.com/hc/en-us/sections/200805497-Restoring-Visitor-IPs

Is this the definitely the issue that is causing my problem ?
As I dont want to introduce any changes until I have identified the issue.

I would rather disable CloudFlare altogether (if I know it’s causing an issue with my xcart shop software) and revisit the problem later - I just need to get back online - quickly

Well, if you dont rewrite addresses the proxy addresses will show up and this is the case here, isnt it?

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.