Getting this error when saving ipv6 IP address
โค้ด: เลือกทั้งหมด
General Error
SQL ERROR [ mysqli ]
Data too long for column 'rc_ip_address' at row 1 [1406]
SQL
INSERT INTO tools_resistor_calculator (rc_username, rc_color_bar_1, rc_color_bar_2, rc_color_bar_3, rc_color_bar_4, rc_result, rc_number_bar, rc_ip_address, rc_created_date) VALUES ('dfsdfdsfdsfdsfdsfdf', '6', '1', '10000', '0.1%', '610 k Ohms 0.1%', 4, '2001:0db8:85a3:0000:0000:8a2e:0370:7334', 1731296709)
BACKTRACE
FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()
FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 1031
CALL: trigger_error()
FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 202
CALL: phpbb\db\driver\driver->sql_error()
FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 353
CALL: phpbb\db\driver\mysqli->sql_query()
FILE: [ROOT]/tools_resistor_calculator.php
LINE: 232
โค้ด: เลือกทั้งหมด
`rc_ip_address` varchar(20) NOT NULL ,
How to fix it ?