Cannot access Package Manager to upgrade to the latest version

[mfarmer]

To save space, in the future, you might want to consider lowering the limits for picture sizes and stuff, in attachments.

Whilst I think about it, look for files, in the root, named "CORExxx" or similar. They can take-up huge amounts of room and they're not, really, needed. They're dumps from when the server had problems. Although, if there're a lot of them, you might want to let you host know.

Not sure where to find these files-  CORExxx   

I have deleted all pics from my gallery and everything from the Avatar folder and I'm still over 100mb over :-(

[mfarmer]

I am doing this correctly- 

I'm in binary and I'm just deleting up.  Does this then delete from my forum server? 

Have checked the mb figure on my host service, and it hasn't changed suggesting things are deleting out.

[Illori]

are you over space on your database or your storage space on the hard drive?

[mfarmer]

On my database.

[Illori]

then removing files from your server will not decrease your database space. the easy answer is to find a host with more space rather then deleting posts etc that your users made.

[mfarmer]

then removing files from your server will not decrease your database space. the easy answer is to find a host with more space rather then deleting posts etc that your users made.

??

I'm not in a position to switch host at the moment and I need to get the forum back up and running, why cannot delete from the database on their server to reduce the size?

[Illori]

you cant just randomly delete stuff in the database without possibly breaking it totally. do you really want to risk removing your users posts etc because your host will not give you enough space?

[margarett]

Please have your host telling how is your space being occupied.

You didn't tell me the size of your forum (members, posts)

[mfarmer]

My forum host finally got back to me. 

They have checked my tables and 1.1Gb is taken up by error logs 

How do I find and delete these in Filezilla?  There is no file called error logs that I can find!

[kat]

If you have access to it, you might have a directory named "logs" in the level above (Or below, depending on how you look at it) the public_html directory, if you have that.

You can see them and delete them from SMF's admin panel, though.

Have a look at "Error logs" (Oddly enough) in Forum Maintenance. If you click on the main "Admin" tab, there should be an "Error log" that you can select, there. 'course, it might be an idea to see what all those errors are, before you bin 'em.

[margarett]

If you can access your forum, try to follow K@'s advice.

If not, you can go to phpmyadmin and TRUNCATE smf_log_errors

[Kindred]

my database for my site is over 2 gigs...


I think you need to look for another host, honestly.

[mfarmer]

If you can access your forum, try to follow K@'s advice.

If not, you can go to phpmyadmin and TRUNCATE smf_log_errors

Not able to access through the forum website, on through filezilla or phpmyadmin 

Where is the option to TRUNCATE?   

I have under table maintenance: 

Table maintenance
Check table    Documentation
Analyze table    Documentation
Repair table    Documentation
Optimize table    Documentation
Flush the table ("FLUSH")    Documentation

Or some other options: 

Browse
Structure
SQL
Search
Insert
Export
Operations
Empty
Drop

[margarett]

Go to SQL tab and execute the TRUNCATE instruction there

[mfarmer]

Thanks, but how: 

Server: db452575559.db.1and1.com  -   Database: db452575559  -   Table: smf_log_errors
BrowseBrowse StructureStructure SQLSQL SearchSearch InsertInsert ExportExport OperationsOperations EmptyEmpty DropDrop

Run SQL query/queries on database db452575559Documentation         Fields:
      
Show this query here again   

Or Location of the text file:
   (Max: 49,152KB)
  Compression:
     Autodetect    None    "gzipped"    "bzipped" 
Character set of the file:    
Insert data from a text file into the tableInsert data from a text file into the table

[mfarmer]

There is no truncate option listed anywhere.

[margarett]

Not an option, you need to write it in the SQL tab

Please perform a full cPanel backup before you do this, try not to hit the wrong table

[mfarmer]

How and how??!!!???

[margarett]

Some may say, an image is worth a thousand words

1 - Go to your phpmyadmin and select your SMF database. Mine is called "smf2" in this example


2 - In the tables list, click on smf_log_errors. Before you do so, take a moment to note the values in the fields I marked in red. Let us know what was there


3 - Click the "SQL" tab


4 - In the edit field, replace the default text shown with "TRUNCATE smf_log_errors"


5 - Click the "Go" button in the lower right corner. There 'ya go

[kat]

You're a good man, Bruno. You're a good man.