Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length

JoomlaTune Support Forum    JComments component    Bug-reports    Topic: IPv6 Adress
Pages: [1]   Go Down
  Print  
Author Topic: IPv6 Adress  (Read 2000 times)
0 Members and 1 Guest are viewing this topic.
Holli
Newbie
*

Karma: 0
Offline Offline

Posts: 1


« on: August 29, 2010, 15:16:07 »

Good Morning

I found a little bug.

When somebody use ipv6 and write a comment, the ip will not save correct. Problem is, that IPv6 adresses longer then v4 adresses.

The solution is easy. Change in the sql table in jos_comment the type of the field "ip" to "varchar(39)".

After change it, jcomment save the complete ipv6 adress.
Logged
smart
Administrator
Hero Member
*****

Karma: 163
Offline Offline

Gender: Male
Posts: 2161



WWW
« Reply #1 on: August 30, 2010, 14:47:35 »

Ok, thank you for this report. I'll include script to update this field size in next version.
Here is quick fix:

Code: (sql)
ALTER TABLE `jos_jcomments` CHANGE `ip` `ip` VARCHAR(39) NOT NULL DEFAULT '';
ALTER TABLE `jos_jcomments_votes` CHANGE `ip` `ip` VARCHAR(39) NOT NULL DEFAULT '';
ALTER TABLE `jos_jcomments_reports` CHANGE `ip` `ip` VARCHAR(39) NOT NULL DEFAULT '';

Don't forget to replace jos with your site's table prefix (if you've changed it).
« Last Edit: August 30, 2010, 14:52:26 by smart » Logged

If you use JComments, please post a rating and a review at the Joomla! Extensions Directory
Pages: [1]   Go Up
  Print  
JoomlaTune Support Forum    JComments component    Bug-reports    Topic: IPv6 Adress
 
Jump to: