Guild list znote problem

jackl90

Member
Joined
Jul 25, 2017
Messages
159
Reaction score
6
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?
 

Apollos

Dude who does stuff
Joined
Apr 22, 2009
Messages
735
Reaction score
449
Location
United States
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 '';
 
Top