Portal Forums Calendar Active Threads
Previous Thread
Next Thread
Print Thread
Hop To
Attachments in Database
#266128 07/23/2024 7:46 PM
Joined: May 2006
Posts: 177
FREAK
Offline
Member
FREAK
Member
Offline
Joined: May 2006
Posts: 177
Hello,

In CP it shows I have 142 attachments totaling 74.91 MB. How do I see what exactly these attachments are?

Please give me a detailed way of finding it in layman's terms smile

Thanks
Re: Attachments in Database
FREAK #266129 07/23/2024 8:07 PM
Joined: Jun 2006
Posts: 16,532
Likes: 150
Portland, OR; USA
Gizmo Offline
UBB.threads Developer
Gizmo
UBB.threads Developer
Offline
Joined: Jun 2006
Posts: 16,532
Likes: 150
Portland, OR; USA
FTP would probably be your easiest bet, there is no dashboard page to display which attachments are in the database.

I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: Attachments in Database
FREAK #266133 07/27/2024 5:58 AM
Joined: Dec 2003
Posts: 6,649
Likes: 88
Lutz,FL
Ruben Offline
Ruben
Offline
Joined: Dec 2003
Posts: 6,649
Likes: 88
Lutz,FL
You could do a sql query via the CP
Goto Tools & Information-Database Tools
Select the SQL Command tab
Type
SQL Query
Select *
From ubbt_FILES

or for just the file name and size enter
SQL Query
Select FILE_ORIGINAL_NAME,FILE_SIZE
From ubbt_FILES
You can save the query for future use on that page if you wish

Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Re: Attachments in Database
Ruben #266135 07/27/2024 2:53 PM
Joined: May 2006
Posts: 177
FREAK
Offline
Member
FREAK
Member
Offline
Joined: May 2006
Posts: 177
Originally Posted by Ruben
You could do a sql query via the CP
Goto Tools & Information-Database Tools
Select the SQL Command tab
Type
SQL Query
Select *
From ubbt_FILES

or for just the file name and size enter
SQL Query
Select FILE_ORIGINAL_NAME,FILE_SIZE
From ubbt_FILES
You can save the query for future use on that page if you wish

This worked, I was able to see a listing of the 143 files. Thanks for this.

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
PHP 8 bug in membermanage.tmpl
by phoenix011235 - 09/08/2026 7:47 PM
Are any of these legitmate?
by Baldeagle - 09/06/2026 1:37 PM
After server reboot
by Morgan - 09/02/2026 8:27 AM
Email Settings
by Outdoorking - 05/13/2026 2:44 AM
Who's Online Now
0 members (), 118 guests, and 136 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Ride safe!
Ride safe!
by Morgan, December 7
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Forum Rules · Mark All Read Contact Us · Forum Help · UBBCentral
Powered by UBB.threads™ PHP Forum Software 8.1.0
(Snapshot build 20260527)