[] ALTER TABLE nuke_modules ADD mcid int(11) NOT NULL default '1'; [/]

whats the fuction of this command? and how can i deactivate this command

This command is run against your database using shell access and mysql directly or a tool like phpMyAdmin and a web interface.

It will ALTER the table nuke_modules and it will ADD the column mcid of type Integer with max length 11 digits which cannot be null and if not specified in an insert query it will always get assigned the value 1.

This command is run only by install/upgrade scripts. You either don't run it (if you are doing manually things) or alter the script that has the command.

It might fail because the field already exists.

BTW: Which part of .threads you saw that? To my knowledge there is no modules table assuming that your prefix is nuke. Is this a custom modification or an addon?

It seems to be a post nuke query.