AAC Out of range value for column.

[luhfe]

Hi, good night.
That problem occurs affter create account, and when anybody try enter on "Create characters" page.
Error on create acc. if someone can help, i apprec.

SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'ip' at row 1


Backtrace:

#0 C:\tf1.2\UniServerZ\www\system\libs\pot\OTS_Account.php(981): PDO->exec()
#1 C:\tf1.2\UniServerZ\www\system\pages\createaccount.php(175): OTS_Account->logAction()
#2 C:\tf1.2\UniServerZ\www\index.php(347): require('C:\\tf1.2\\UniSer...')
#3 {main}

OTS_Account.php (981)
return $this->db->exec('INSERT INTO ' . TABLE_PREFIX . 'account_actions (account_id, ip, ipv6, date, action) VALUES (' . $this->db->quote($this->getId()).', ' . ($ip == '' ? '0' : $this->db->quote(ip2long($ip))) . ', (' . ($ipv6 == '0' ? $this->db->quote('') : $this->db->quote(inet_pton($ipv6))) . '), UNIX_TIMESTAMP(NOW()), ' . $this->db->quote($action).')');

Createaccount.php(175)
$new_account->logAction('Account created.');

Index.php (344, 345, 346, 347) - all code lines

ob_start();
if($hooks->trigger(HOOK_BEFORE_PAGE)) {
if(!$ignore)
require $file;

Using Uniform Server
MyAAC version : otbr/myaac (https://github.com/otbr/myaac)

On Try acc page of Chars on site (God account or ADM or any) automatic redirec to login page.
Ty anyway. @Alpha (Sorry for mark u but i see u giving a help hand in another topic like this) !
I know that is only a problem of config, but i dont know sql so can help ? ty

---

Edit : in my SQL database i cant found this dates (ip, ipv6...)

 

[Alpha]

Might be wrong datatype in the database, try running that in phpmyadmin or whatever you use

ALTER TABLE `myaac_account_actions` CHANGE COLUMN `ip` `ip` INT(10) UNSIGNED NOT NULL DEFAULT 0 AFTER `account_id`;
ALTER TABLE `myaac_account_actions` CHANGE COLUMN `ipv6` `ipv6` BINARY(16) NOT NULL DEFAULT 0 AFTER `ip`;

 

[luhfe]

On exe in SQL :

Erro​

Comando SQL: Copiar



ALTER TABLE myaac_account_actions CHANGE COLUMN ip ip` INT(10) UNSIGNED NOT NULL DEFAULT 0 AFTER account_id;
ALTER TABLE myaac_account_actions CHANGE COLUMN ipv6 ipv6` BINARY(16) NOT NULL DEFAULT 0 AFTER ip



Mensagens do MySQL :

#1064 - Você tem um erro de sintaxe no seu SQL próximo a '` INT(10) UNSIGNED NOT NULL DEFAULT 0 AFTER account_id;
ALTER TABLE `myaac_ac' na linha 1

i'm sure that is a wrong date aplication, i dont know where hehehe ty for reply...i'm not sure that error its becouse dont have the colum or anything in data base or in .php . i'm a little lost here :|

 

[Alpha]

I made a typo, try again

 

[luhfe]

After see u seting a myacc_account_actions i try check it on DB and return that :

�

account_id	ip	ipv6	date	action
2	178126852	0x00000000000000000000000000000000	1612118453	Account created.

i think the error r on create date (in .php), ipv6 format !? =S i`ll try again your reply and lets see what hap...ty man :`) its a pain in the a$$

------

Edit
Exe SQL, auto change the fields, Using localhost and this stop erros and create all good, but in external acess that sh!t still happining...
i have no clues...rlly =\

Edit²
Mayba its a 'question' of permission on UniForm Server ??? i have open 443,80,8090,7171,7172,3306 port's...in anything.

Edit³
Thats msg have occour on exe the command on SQL and i dont pay attention

Warning: #1681 Integer display width is deprecated and will be removed in a future release.

Edit¹+³
i try change the Field 'ip' to varchar (15) Null (dunno if change to that will affect anything, im dumb) and i CAN now create accout but after login in account and try create another character, i'm redirect to Login page and has be logout. Field Type 'Int(10)' can save numbers with ' : ' incluse ??? maybe its try save ports indeed like '0.0.0.0:0000' ...i rlly dont know what think x.x

Last Edit (i promisse)
i'm using a No-Ip redirec Ex: servename.servegame.com to redirect for Ex: 0.0.0.0:8090 with a options in no-ip to use ports too.
when i try create a new char in external ip (Using a No-IP endress) i CANT create a new char...But...BUT... if i use '0.0.0.0:8090' (NOT localhost obivious, with the external ip), CAN create a new char. WTF ? :S HELP

 

[luhfe]

up

Edit
My problem is not at MySQL or AAC (that have be resolved like @Alpha explain - ty again bro for any help).
the problem now is on mask of dns (no-ip), thats dont work on accountmanagement.php dunno why oO' !
close pls.