Error when create guild: Guild list is empty. ~ Field 'checkdata' doesn't have a default value

[caquinha]

Anyone know how to fix this error when create guild on znote aac?

Guild list is empty.
string(114) "INSERT INTO `guilds` (`name`, `ownerid`, `creationdata`, `motd`) VALUES ('New Age', '2', '1476275366', '');"
(query - SQL error)
Type: voidQuery (voidQuery is used for update, insert or delete from database)

Field 'checkdata' doesn't have a default value

Another problem now.. "Field 'checkdata' doesn't have a default value" when I'm trying to create a guild. Can be solved by adding default value 0 in the DB but then I get some random crashes on the homepage.

https://otland.net/threads/znote-aac-1-4-tfs-0-2-13-tfs-0-3-6-0-4.166722/page-30

 

[caquinha]

bump

 

[caquinha]

bump

 

[caquinha]

bump

 

[maikons]

I have same problem...
And when create character show me this:

1string(758) "INSERT INTO `players`(`name`, `group_id`, `account_id`, `level`, `vocation`, `health`, `healthmax`, `experience`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `maglevel`, `mana`, `manamax`, `manaspent`, `soul`, `town_id`, `posx`, `posy`, `posz`, `conditions`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `rank_id`, `guildnick`, `lastlogout`, `blessings`, `direction`, `loss_experience`, `loss_mana`, `loss_skills`, `premend`, `online`, `balance`) VALUES ('Fucking Error', '1', '11', '1', '0', '150', '150', '0', '68', '76', '78', '58', '128', '0', '0', '0', '0', '0', '100', '7', '392', '929', '6', '', '400', '1', '0', '2130706433', '1', '0', '0', '0', '', '0', '0', '0', '10', '10', '10', '0', '0', '0');" 
(query - SQL error) 
Type: voidQuery (voidQuery is used for update, insert or delete from database)

Field 'guildjoin' doesn't have a default value

 

[Danger II]

guildjoin

Does that column exist in your players table?

Field 'checkdata' doesn't have a default value

Does that column exist in your guilds table?

If these column exist, check the class-file where the query is called at and add the column to it.

Alternate search in files for:
INSERT INTO `guilds` (`name`, `ownerid`, `creationdata`, `motd`)
and replace it with:
INSERT INTO `guilds` (`name`, `ownerid`, `creationdata`, `motd`, `checkdata`)
Same to maikons

 

[caquinha]

Does that column exist in your players table?

Does that column exist in your guilds table?

If these column exist, check the class-file where the query is called at and add the column to it.

Alternate search in files for:
INSERT INTO `guilds` (`name`, `ownerid`, `creationdata`, `motd`)
and replace it with:
INSERT INTO `guilds` (`name`, `ownerid`, `creationdata`, `motd`, `checkdata`)
Same to maikons

In players, in my phpmyadmin:
56 guildjoin int(11) No None

Class-file ?
Sorry i dont understand...

 

[maikons]

Does that column exist in your players table?

Does that column exist in your guilds table?

If these column exist, check the class-file where the query is called at and add the column to it.

Alternate search in files for:
INSERT INTO `guilds` (`name`, `ownerid`, `creationdata`, `motd`)
and replace it with:
INSERT INTO `guilds` (`name`, `ownerid`, `creationdata`, `motd`, `checkdata`)
Same to maikons

I don't understand tbm search for
INSERT INTO `guilds` (`name`, `ownerid`, `creationdata`, `motd`)
Where?

 

[Danger II]

I don't understand tbm search for
INSERT INTO `guilds` (`name`, `ownerid`, `creationdata`, `motd`)
Where?

https://github.com/Znote/ZnoteAAC/b...4a9f3d910082c5/engine/function/users.php#L446
mysql_insert("INSERT INTO `guilds` (`name`, `ownerid`, `creationdata`, `motd`) VALUES ('$name', '$cid', '$time', '');");
to
mysql_insert("INSERT INTO `guilds` (`name`, `ownerid`, `creationdata`, `motd`, `checkdata`) VALUES ('$name', '$cid', '$time', '', '0');");

I have same problem...
And when create character show me this:

1string(758) "INSERT INTO `players`(`name`, `group_id`, `account_id`, `level`, `vocation`, `health`, `healthmax`, `experience`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `maglevel`, `mana`, `manamax`, `manaspent`, `soul`, `town_id`, `posx`, `posy`, `posz`, `conditions`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `rank_id`, `guildnick`, `lastlogout`, `blessings`, `direction`, `loss_experience`, `loss_mana`, `loss_skills`, `premend`, `online`, `balance`) VALUES ('Fucking Error', '1', '11', '1', '0', '150', '150', '0', '68', '76', '78', '58', '128', '0', '0', '0', '0', '0', '100', '7', '392', '929', '6', '', '400', '1', '0', '2130706433', '1', '0', '0', '0', '', '0', '0', '0', '10', '10', '10', '0', '0', '0');"
(query - SQL error)
Type: voidQuery (voidQuery is used for update, insert or delete from database)

Field 'guildjoin' doesn't have a default value

Add after:
https://github.com/Znote/ZnoteAAC/b...a9f3d910082c5/engine/function/users.php#L1179
this:
'guildjoin' => '0',
And after:
https://github.com/Znote/ZnoteAAC/b.../api/modules/base/player/class/player.php#L40
add this:
'guildjoin' => null,

Never worked with znote, let me know if it worked..

 

[caquinha]

https://github.com/Znote/ZnoteAAC/b...4a9f3d910082c5/engine/function/users.php#L446
mysql_insert("INSERT INTO `guilds` (`name`, `ownerid`, `creationdata`, `motd`) VALUES ('$name', '$cid', '$time', '');");
to
mysql_insert("INSERT INTO `guilds` (`name`, `ownerid`, `creationdata`, `motd`, `checkdata`) VALUES ('$name', '$cid', '$time', '', '0');");


Add after:
https://github.com/Znote/ZnoteAAC/b...a9f3d910082c5/engine/function/users.php#L1179
this:
'guildjoin' => '0',
And after:
https://github.com/Znote/ZnoteAAC/b.../api/modules/base/player/class/player.php#L40
add this:
'guildjoin' => null,

Never worked with znote, let me know if it worked..

Everything is working now thankts to you!!!!!!

 

[oliverarrow]

https://github.com/Znote/ZnoteAAC/b...4a9f3d910082c5/engine/function/users.php#L446
mysql_insert("INSERT INTO `guilds` (`name`, `ownerid`, `creationdata`, `motd`) VALUES ('$name', '$cid', '$time', '');");
to
mysql_insert("INSERT INTO `guilds` (`name`, `ownerid`, `creationdata`, `motd`, `checkdata`) VALUES ('$name', '$cid', '$time', '', '0');");


Add after:
https://github.com/Znote/ZnoteAAC/b...a9f3d910082c5/engine/function/users.php#L1179
this:
'guildjoin' => '0',
And after:
https://github.com/Znote/ZnoteAAC/b.../api/modules/base/player/class/player.php#L40
add this:
'guildjoin' => null,

Never worked with znote, let me know if it worked..

Looking the way u follow to fix this script i think i found where was my problem:
https://otland.net/threads/znote-whats-worng-with-my-register-php.246370/

Could you help me to fix it?

 

[maikons]

Solved ty @Danger II

 

[poko360]

@Danger II
sqlite3_step(): SQLITE ERROR: guilds.checkdata may not be NULL

help me pls

 

[dunnish]

i laso get

1. string(109) "INSERT INTO `guilds` (`name`, `ownerid`, `creationdata`, `motd`) VALUES ('omg123', '7', '1539548781', '');"
2. (query - SQL error)
3. Type: voidQuery (voidQuery is used for update, insert or delete from database)
4. 
   
5. Field 'checkdata' doesn't have a default value

and dossnt find the sulosion :/