What is wrong with this query!!

[Remi]

This query crashed my server twice!! beleve it or not:

ALTER TABLE post ADD hidden SMALLINT(6) UNSIGNED DEFAULT '0' not null

It is part of a hack done by the great tubedogg, but I don't know whay it is not working for me

[Steve Machol]

You probably don't have 'ALTER' permissions. You would need to ask your host to grant your db user these permissions.

[Remi]

Hi Steve

Thank you for your answer, but I have a root permissions.

I have droped some tables and recreated them on the same DB

[g-force2k2]

Remi:

Steve is correct... you must not have 'alter' permissions...

there is a major difference between having 'drop' & 'create' permissions then having 'alter' permissions... just make sure you ask your host about it... regards...

g-force2k2