The Arcive of vBulletin Modifications Site.

What is wrong with this query!! · **Released**: 10-02-2002

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 · #2 10-02-2002, 07:55 PM

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

Remi · #3 10-04-2002, 05:56 PM

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 · #4 10-04-2002, 08:54 PM

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