• This area is dedicated to the support of our xF1 add-ons. For xF2, please use the dedicated area: HERE.
  • We are aware that a no permission error was shown when you tried to purchase in the last 2 days, this is now fixed.

Bug Fixed Data Column 'IP' too small for IPv6 servers

GaryOPA

New Member
Joined
Jul 21, 2016
Messages
2
My server allows people to browse via both IPv4 and IPv6, but when they try voting via an IPv6, I get this following error message:

Code:
Error Info

Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Data too long for column 'ip' at row 1 - library/Zend/Db/Statement/Mysqli.php:214
Generated By: TheGreek Boy, Today at 2:02 PM

Stack Trace

#0 /var/www/virtual/maxconsole.net/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /var/www/virtual/maxconsole.net/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /var/www/virtual/maxconsole.net/library/XFA/VotingsSystem/Model/Voting.php(715): Zend_Db_Adapter_Abstract->query('\n\t\t\tINSERT INTO...')
#3 /var/www/virtual/maxconsole.net/library/XFA/VotingsSystem/ControllerPublic/Votings.php(468): XFA_VotingsSystem_Model_Voting->insertUserVote(Array, 50301, 1, '2a02:0587:e003:...')
#4 /var/www/virtual/maxconsole.net/library/XenForo/FrontController.php(351): XFA_VotingsSystem_ControllerPublic_Votings->actionVote()
#5 /var/www/virtual/maxconsole.net/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#6 /var/www/virtual/maxconsole.net/index.php(13): XenForo_FrontController->run()
#7 {main}

Request State

array(3) {
  ["url"] => string(47) "http://www.maxconsole.com/votings/2/vote?vote=1"
  ["_GET"] => array(1) {
    ["vote"] => string(1) "1"
  }
  ["_POST"] => array(0) {
  }
}
I manually increased the width the the IP Column and that reduced the amount of errors, but it still occurs from time to time.

Something to look into for the next release. - Only problem I have found so far.
 
  • Like
Reactions: MtoR

MtoR

Freaky Coder
Staff member
Joined
Nov 14, 2015
Messages
5,219
In fact, it was not a question of bigger field but the way to write in it.

I am going to fix this.