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

Matthew Hawley

Well-known member
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"
 
Are you running that in PHP My Admin?

Make sure you use the SQL tab. Not the Query tab.
 
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
 
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 Bottom