How can i drop all signatures?

[ryans]

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!

[ryans]

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

thanks!

[SmEdD]

UPDATE $table SET '' WHERE $column;

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

[Xenon]

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

[SmEdD]

Definatly use his ^^^^^^^^

He is a god at this stuff.

[ryans]

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

[ryans]

I get an error message:

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

[Link14716]

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

[Xenon]

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

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