• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

AAC Out of range value for column.

luhfe

New Member
Joined
Apr 26, 2018
Messages
48
Reaction score
2
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...)
 
Last edited:

Alpha

Relentless
Premium User
Joined
Apr 3, 2011
Messages
649
Solutions
35
Reaction score
446
Location
South Korea
Might be wrong datatype in the database, try running that in phpmyadmin or whatever you use

SQL:
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`;
 
Last edited:
OP
OP
luhfe

luhfe

New Member
Joined
Apr 26, 2018
Messages
48
Reaction score
2
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 : Documentação

#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 :|
 
Last edited:
OP
OP
luhfe

luhfe

New Member
Joined
Apr 26, 2018
Messages
48
Reaction score
2
After see u seting a myacc_account_actions i try check it on DB and return that :


account_idipipv6dateaction
21781268520x000000000000000000000000000000001612118453Account 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
 
Last edited:
OP
OP
luhfe

luhfe

New Member
Joined
Apr 26, 2018
Messages
48
Reaction score
2
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.
 
Last edited:
Top