[nubian]

Originally Posted by sv1cec

You have not left a space between the word "default" and the zero. I think this is your error. Is it?

I'll wait for you to tell me. I'll have another cigarette.

Rgds

i tired this:
ALTER TABLE vb3_post ADD COLUMN `warn_flag` int(5) default 0 AFTER attach

and got this:
Error

SQL-query :

ALTER TABLE vb3_post ADD COLUMN `warn_flag` int( 5 ) default 0 AFTER attach

MySQL said:

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'default0 AFTER attach' at line 1

there is a space between default and 0