Set phpbb_attachments_desc.thumbnail to '1' in all rows

This is an archive of the phpBB 2.0.x convertors forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
Registered User
Posts: 67
Joined: Thu May 06, 2004 7:32 pm

Set phpbb_attachments_desc.thumbnail to '1' in all rows

Post by »

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!
User avatar
Former Team Member
Posts: 11030
Joined: Thu Jul 01, 2004 4:15 am
Location: GA, USA

Post by 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. ;)


Thread Lockinated
Support Resources: Support Request Template
If you need professional assistance with your board, please contact me for my reasonable rates.

Return to “[2.0.x] Convertors”