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

[GaryOPA]

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:

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.

 

[Clement]

In fact, it was not a question of bigger field but the way to write in it.

I am going to fix this.