How can i drop all signatures?
 

I'm running 2.30 and curious how I can drop all signatures and avatars. moving to subscription based and want these to start all over.

thanks!

I prefer to do command line. I know how to log into mysql etc.

thanks!

UPDATE $table SET '' WHERE $column;

$table = Table sigs are in
$column = Sig column name

[sql]UPDATE user SET avatarid=0,customavatar=0,signature=''[/sql]

Definatly use his ^^^^^^^^

He is a god at this stuff.

Thanks, i'll give that a try. I just had to restore my database and it took a few hours. 900MB worth :)

I get an error message:

ERROR 1054: Unknown column 'customavatar' in 'field list'

It's because it should only be:
[sql]UPDATE user SET signature='', avatar='0'[/sql]

oops, yes but it's not just one query:

[sql]UPDATE user SET avatarid=0, signature=''
DELETE FROM customavatar[/sql]