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: 174
FREAK
Offline
Member
FREAK
Member
Offline
Joined: May 2006
Posts: 174
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,355
Likes: 125
Portland, OR; USA
Gizmo Online: Eye-Popping
UBB.threads Developer
Gizmo
UBB.threads Developer
Online: Eye-Popping
Joined: Jun 2006
Posts: 16,355
Likes: 125
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 5:58 AM
Joined: Dec 2003
Posts: 6,624
Likes: 84
Lutz,FL
Ruben Online: Yawn
Ruben
Online: Yawn
Joined: Dec 2003
Posts: 6,624
Likes: 84
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: 174
FREAK
Offline
Member
FREAK
Member
Offline
Joined: May 2006
Posts: 174
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
Another error
by Baldeagle - 10/07/2024 9:08 PM
Is this a cookie issue?
by Baldeagle - 10/05/2024 2:01 PM
Search button not there
by ehill - 10/02/2024 2:56 PM
Change the Order of the buttons in a post
by Unixspot - 09/19/2024 10:04 PM
Purging logs does not work
by Baldeagle - 09/12/2024 5:16 PM
Who's Online Now
1 members (Gizmo), 648 guests, and 53 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Forum Rules · Mark All Read Contact Us · Forum Help · UBBCentral
Powered by UBB.threads™ PHP Forum Software 8.0.1
(Snapshot build 20240918)