Posts

I can’t get access to my site (https://melfar.dk/kiwitrees) if i use my vpn connection, It shows the top menu and this error message : Fatal error: Uncaught PDOException: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column ‘ip_address’ at row 1 in /customers/3/3/e/melfar.dk/httpd.www/kiwitrees/library/KT/DBStatement.php:87 Stack trace: #0 /customers/3/3/e/melfar.dk/httpd.www/kiwitrees/library/KT/DBStatement.php(87): PDOStatement->execute(Array) #1 /customers/3/3/e/melfar.dk/httpd.www/kiwitrees/includes/session.php(367): KT_DBStatement->__call(‘execute’, Array) #2 [internal function]: {closure}(‘372eb7d3f8621b0…’, ‘KIWITREES|a:6:{…’) #3 /customers/3/3/e/melfar.dk/httpd.www/kiwitrees/library/Zend/Session.php(732): session_write_close() #4 /customers/3/3/e/melfar.dk/httpd.www/kiwitrees/library/KT/Controller/Page.php(221): Zend_Session::writeClose() #5 /customers/3/3/e/melfar.dk/httpd.www/kiwitrees/index.php(66): KT_Controller_Page->pageHeader() #6 {main} thrown in /customers/3/3/e/melfar.dk/httpd.www/kiwitrees/library/KT/DBStatement.php on line 87 , nearly the same thing happening if i try to access kiwitrees.net (see picture)

is there any thing i can do ?

best regards

Ole H Madsen

Hi

What Ip address do you have on the vpn?

Nigel
My personal kiwitrees site is www.our-families.info

<h2 class=”fw-normal”><span id=”ipv4″ class=”mr-2 h3 fw-light”>185.236.203.101</span></h2>
Best regards

Ole H Madsen

That doesn’t make sense. That is a normal length IP address, so there is no good reason why it should trigger the error “String data, right truncated: 1406 Data too long for column ‘ip_address’”

It presumably happened when you tries to login, so check the “kt_session” table in your database. (your prefix may be different to kt_) to see what length the field ip_address is.

But it is also possible that the ip address you gave here was not the one that caused the error, because VPNs (I believe) change IP addresses often.

I also looked at your login activity here at kiwitrees.net. That does confirm you send different IP addresses, some appearing to be from unusual countries. It is entirely possibly that is the cause of the problem. This site gets a huge number of fake attempts to access it, so has very strict checks, especially regarding known hacker countries. Not much I can do about that, as the checks are necessary to avoid me spending every hour I have on these attempts.

Back to your site – kiwitrees has the “kt_access” table in your database where IP addresses can be ‘allowed’ or denied’ access to the site. I guess one of your VPN IP addresses was part of a block marked as “deny”. You could try deleting all records in that table marked as “deny”. DO NOT remove any marked “allow”, as this may block ALL access. The difficulty will be that you might need to do this everytime your VPN uses a new IP address.

Nigel
My personal kiwitrees site is www.our-families.info