AAC Error leave guild Znote AAC

kennyubuntu

Member
Joined
May 20, 2016
Messages
96
Best answers
0
Reaction score
5
When i try to leave guild show me this:
Code:
string(75) "UPDATE `players` SET `rank_id`='0', `guildnick`= NULL WHERE `id`=5 LIMIT 1;"
(query - SQL error)
Type: voidQuery (voidQuery is used for update, insert or delete from database)

Column 'guildnick' cannot be null
And i cant leave on znote... Why?
 

Bogart

...has super panda powers
Joined
Jun 21, 2009
Messages
8,010
Best answers
27
Reaction score
532
Location
Panda Land!
Not sure if this is the best solution since I do not know if there's a reason for the guildnick to be not null but..
Execute this query in your database.
SQL:
ALTER TABLE `players` MODIFY `guildnick` VARCHAR(30);
 
OP
kennyubuntu

kennyubuntu

Member
Joined
May 20, 2016
Messages
96
Best answers
0
Reaction score
5
Not sure if this is the best solution since I do not know if there's a reason for the guildnick to be not null but..
Execute this query in your database.
SQL:
ALTER TABLE `players` MODIFY `guildnick` VARCHAR(30);
Thank you.
 
Top