"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.
 
Top