Loading...
 
Skip to main content

Ip logging in many table too short for IPv6

  • Tracker item actions
Trackers
Items
Status
Closed
Subject
Ip logging in many table too short for IPv6
Version
6.x
Category
  • Feature request
  • Less than 30-minutes fix
Feature
Comment
Poll
Tags
Wiki Structure (book & table of content)
Resolution status
Fixed or Solved
Submitted by
canelli
Lastmod by
Marc Laporte
Rating
(0)
Description

In tables
tiki_comments, tiki_history, tiki_pages, tiki_tags tiki_user_voting
the column IP is too short (varchar 15) for IPv6 logging

In tables
tiki_actionlog, tiki_download, tiki_logs the column IP is very big (too big ?) varing from 39 to 200 char . In tiki_download the IP cloumn is in UPPERCASE (may be problem with some Mysql installation)

In tables
tiki_banning
the IP is split in three columns . so we can't bann an IPv6

Solution

for tiki_comment, tiki_history, tiki_pages, tiki_tags tiki_user_voting
use the following sql to enlarge the ip column

ALTER TABLE `tiki_comments` CHANGE `user_ip` `user_ip` VARCHAR( 21 ) DEFAULT NULL ;
ALTER TABLE `tiki_history` CHANGE `ip` `ip` VARCHAR( 21 ) DEFAULT NULL ;
ALTER TABLE `tiki_pages` CHANGE `ip` `ip` VARCHAR( 21 ) DEFAULT NULL ;
ALTER TABLE `tiki_tags` CHANGE `ip` `ip` VARCHAR( 21 ) DEFAULT NULL ;
ALTER TABLE `tiki_user_votings` CHANGE `ip` `ip` VARCHAR( 21 ) DEFAULT NULL ;

Importance
9 high
Easy to solve?
10 easy
Priority
90
Demonstrate Bug on Tiki 19+
Demonstrate Bug (older Tiki versions)
Ticket ID
3904
Created
Monday 30 May, 2011 10:14:39 UTC
by canelli
LastModif
Friday 10 August, 2012 19:15:02 UTC


Show PHP error messages