Ip logging in many table too short for IPv6
- 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
Wiki Structure (book & table of content)
Tags - Resolution status
- Fixed or Solved
- Submitted by
- canelli
- Lastmod by
- Marc Laporte
- Rating
- Description
In tables
tiki_comments, tiki_history, tiki_pages, tiki_tags tiki_user_voting
the column IP is too short (varchar 15) for IPv6 loggingIn 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 columnALTER 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 (Tiki 19+)
-
This bug has been demonstrated on show2.tiki.org
Please demonstrate your bug on show2.tiki.org
Version: Create show2.tiki.org instanceAbout show2.tiki.orgTo help developers solve the bug, we kindly request that you demonstrate your bug on a show2.tiki.org instance. To start, simply select a version and click on "Create show2.tiki.org instance". Once the instance is ready (in a minute or two), as indicated in the status window below, you can then access that instance, login (the initial admin username/password is "admin") and configure the Tiki to demonstrate your bug. Priority will be given to bugs that have been demonstrated on show2.tiki.org.
- Ticket ID
- 3904
- Created
- Monday 30 May, 2011 10:14:39 GMT-0000
by canelli - LastModif
- Friday 10 August, 2012 19:15:02 GMT-0000
Attachments
| filename | created | hits | comment | version | filetype | ||
|---|---|---|---|---|---|---|---|
| No attachments for this item | |||||||
;){kind=link}
;){kind=link}
;){kind=link}
;){kind=link}