• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

"You have to choose at least one column to display" Error

Matthew Hawley

Well-known member
#1
I'm trying to submit this query:

ALTER TABLE xf_smilie
DROP smilie_category_id,
ADD smilie_category_id INT UNSIGNED NOT NULL DEFAULT 0,
ADD display_order INT UNSIGNED NOT NULL DEFAULT 1,
ADD display_in_editor TINYINT UNSIGNED NOT NULL DEFAULT 1,
ADD INDEX display_order (display_order)
And I am getting the following error.

"You have to choose at least one column to display"
 

Matthew Hawley

Well-known member
#6
Oh also I got this error when I entered it, but I think it has a problem to do with the smiley manager.

#1091 - Can't DROP 'smilie_category_id'; check that column/key exists
 

Chris D

XenForo developer
Staff member
#7
It's trying to say it can't drop the column because it doesn't exist. So you can remove that drop statement from your query.