AAC [ERROR] Out of range value for column 'create_ip' at row 1

[tanii]

hello i have some issue when i create account on gesior acc 0.3.6 - 0.4 the error messege is:
Error message: Out of range value for column 'create_ip' at row 1

i tried solve this issue: In phpMyAdmin go to -> accounts - > Structure TAB - > find create_ip row - > edit - > Change Type to VARCHAR -> SAVE
Solved - [Gesior aac] Problems with gesior in linux

the issue is i can crete accounts on gesior but accounts in db are not updating.

but it gives me error:
#1366 - Incorrect integer value: '\x00' for column 'create_ip' at row 1

SELECT `id`, `name`, `password`, `premdays`, `lastday`, `email`, `key`, `group_id`, `create_ip`, `create_date`, `premium_points`, `page_access`, `location`, `rlname`, `email_new`, `email_new_time`, `email_code`, `next_email`, `last_post`, `flag` FROM `accounts` WHERE `name` = 'TEST'
SQLSTATE: 00000
Driver code:
Error message:
Query: INSERT INTO `accounts` (`name`, `password`, `premdays`, `lastday`, `email`, `key`, `group_id`, `create_ip`, `create_date`, `premium_points`, `page_access`, `location`, `rlname`, `email_new`, `email_new_time`, `email_code`, `next_email`, `last_post`, `flag`) VALUES ('TEST', 'a94a8fe5ccb19ba61c4c0873d391e987982fbbd3', '999', '1541539612', '[email protected]', '', '1', '2335116215', '1541539612', '', '', '', '', '', '', '', '', '', 'us')
SQLSTATE: 22003
Driver code: 1264
Error message: Out of range value for column 'create_ip' at row 1

 

[SpookieGamer]

Look at what type of data is create_ip column accepting. You can do this by looking at your accounts table columns.

 

[tanii]

thanks solved!

 

[115820]

thanks solved!

How you fixed?

 

[diegoknight95]

how u solved it?

 

[domciacho]

ALTER TABLE accounts MODIFY create_ip VARCHAR(15);

Insert IP Address: Once the data type is correct, you can insert the IP address as a string with single quotes around it, like this

INSERT INTO accounts (name, password, premdays, lastday, email, key, group_id, create_ip, create_date, premium_points, page_access, location, rlname, email_new, email_new_time, email_code, next_email, last_post, flag)
VALUES ('TEST', 'a94a8fe5ccb19ba61c4c0873d391e987982fbbd3', '999', '1541539612', '[email protected]', '', '1', '233.511.62.15', '1541539612', '', '', '', '', '', '', '', '', '', 'us');