Portal Forums Calendar Active Threads
Previous Thread
Next Thread
Print Thread
Hop To
Attachments in Database
#266128 07/23/2024 6:46 PM
Joined: May 2006
Posts: 175
FREAK
Offline
Member
FREAK
Member
Offline
Joined: May 2006
Posts: 175
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 7:07 PM
Joined: Jun 2006
Posts: 16,447
Likes: 141
Portland, OR; USA
Gizmo Online: Eye-Popping
UBB.threads Developer
Gizmo
UBB.threads Developer
Online: Eye-Popping
Joined: Jun 2006
Posts: 16,447
Likes: 141
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, Scouters World
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 4:58 AM
Joined: Dec 2003
Posts: 6,634
Likes: 87
Lutz,FL
Ruben Offline
Ruben
Offline
Joined: Dec 2003
Posts: 6,634
Likes: 87
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 1:53 PM
Joined: May 2006
Posts: 175
FREAK
Offline
Member
FREAK
Member
Offline
Joined: May 2006
Posts: 175
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
Graemlin pictures to the shoutbox
by VaGunTrader - 11/14/2025 6:15 PM
How to add embed video function for Youtube ?
by ShiftKnowledge - 11/11/2025 12:44 AM
Forum time/date setting
by Conrad - 11/10/2025 2:03 PM
Icon Images Look Blurry
by ShiftKnowledge - 11/09/2025 7:01 PM
Who's Online observation
by Morgan - 11/09/2025 4:38 AM
Who's Online Now
2 members (Gizmo, Conrad), 22,752 guests, and 417 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
test
test
by Gizmo, August 20
Ride safe!
Ride safe!
by Morgan, December 7
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Forum Rules · Mark All Read Contact Us · Forum Help · UBBCentral
Powered by UBB.threads™ PHP Forum Software 8.1.0
(Snapshot build 20250209)