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

[Matthew Hawley]

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"

 

[Chris D]

Are you running that in PHP My Admin?

Make sure you use the SQL tab. Not the Query tab.

 

[Matthew Hawley]

Are you running that in PHP My Admin?

Make sure you use the SQL tab. Not the Query tab.

Oh.... I was doing it in the Query tab.

 

[Chris D]

You're welcome

 

[Matthew Hawley]

You're welcome

Oh sorry!!!! Thanks!

I'm trying to say thank you more often. Sorry for forgetting.

 

[Matthew Hawley]

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]

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.

 

[Matthew Hawley]

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.

Thanks! Worked like magic.