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

Guild list znote problem

jackl90

Member
Joined
Jul 25, 2017
Messages
249
Reaction score
12
PHP:
string(159) "SELECT `id`, `name`, `creationdata`, `motd`, (SELECT COUNT('guild_id') FROM `guild_membership` WHERE `guild_id`=`id`) AS `total` FROM `guilds` ORDER BY `name`;"
(query - SQL error)
Type: select_multi (select multiple rows from database)

Unknown column 'motd' in 'field list'

this error appear when i click in guild list in my website, how can i fix this?
 
PHP:
string(159) "SELECT `id`, `name`, `creationdata`, `motd`, (SELECT COUNT('guild_id') FROM `guild_membership` WHERE `guild_id`=`id`) AS `total` FROM `guilds` ORDER BY `name`;"
(query - SQL error)
Type: select_multi (select multiple rows from database)

Unknown column 'motd' in 'field list'

this error appear when i click in guild list in my website, how can i fix this?
Run this SQL query in phpmyadmin:
SQL:
ALTER TABLE `guilds` ADD `motd` varchar(255) NOT NULL DEFAULT '';
 
Back
Top