• 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!

Gesior AAC layout problem guild

zapo

Member
Joined
Nov 10, 2020
Messages
129
Solutions
3
Reaction score
11
Hi,

When i go to guilds page i got white page.

I turn on debug database and i have this
Adnotacja 2021-01-25 122138.png

Similar when i try made account

Adnotacja 2021-01-25 123652.png
 
Last edited:
Solution
Edit tables accounts, guilds and players in database (phpmyadmin etc.).
In all tables edit column create_ip and change it's "data type" from "int(11)" to "int(11) UNSIGNED".
In phpmyadmin that 'unsinged' attribute can be editable in some field.

OR
Execute these SQLs in database:
Code:
ALTER TABLE accounts MODIFY COLUMN create_ip INT(11) UNSIGNED DEFAULT 0 NOT NULL;
ALTER TABLE guilds MODIFY COLUMN create_ip INT(11) UNSIGNED DEFAULT 0 NOT NULL;
ALTER TABLE players MODIFY COLUMN create_ip INT(11) UNSIGNED DEFAULT 0 NOT NULL;
Edit tables accounts, guilds and players in database (phpmyadmin etc.).
In all tables edit column create_ip and change it's "data type" from "int(11)" to "int(11) UNSIGNED".
In phpmyadmin that 'unsinged' attribute can be editable in some field.

OR
Execute these SQLs in database:
Code:
ALTER TABLE accounts MODIFY COLUMN create_ip INT(11) UNSIGNED DEFAULT 0 NOT NULL;
ALTER TABLE guilds MODIFY COLUMN create_ip INT(11) UNSIGNED DEFAULT 0 NOT NULL;
ALTER TABLE players MODIFY COLUMN create_ip INT(11) UNSIGNED DEFAULT 0 NOT NULL;
 
Solution
Back
Top