What's new
Xen Factory

Register today to become a member! Once signed in, you'll be able to start purchasing our products, ask questions, request support and suggest new ideas!

  • 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


New Member
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.


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

I am going to fix this.