Set phpbb_attachments_desc.thumbnail to '1' in all rows

[MoparTalk.co.uk]

ok, not a conversion per se, but a simple task to do housekeeping

I just need to set phpbb_attachments_desc.thumbnail to '1' instead of '0' for all rows, can this be put into a simple php script? there's 16500 rows to do!

[pentapenguin]

Use this command in phpMyAdmin after you select your database:

Code: Select all

UPDATE phpbb_attachments_desc SET thumbnail = 1;

You should make a backup though just in case.

Do note that next time questions about a MOD need to go on the MOD pre-existing topic in one of the MOD forums.

Thanks!

Thread Lockinated