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]

UPDATE user SET avatarid=0,customavatar=0,signature=''

[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:
UPDATE user SET signature='', avatar='0'

[Xenon]

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

UPDATE user SET avatarid=0, signature=''
DELETE FROM customavatar