• New here? Register here now for access to all the forums, download game torrents, private messages, polls, Sportsbook, etc. Plus, stay connected and follow BP on Instagram @buckeyeplanet and Facebook.

PM / Database Problems?

Jump to latest Follow Reply
Sort by date Sort by votes
3yardsandacloud

3yardsandacloud

Administrator Emeritus
Anyone having a problem with their Private Messages? I just tried to access them and got a error message. I sent Clarity & LongwoodBuck an Email, but maybe they will see this here as well.



There seems to have been a slight problem with the BuckeyePlanet Ohio State Forums database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.



Database error in vBulletin 3.0.1:

Invalid SQL:
SELECT pm.*, pmtext.*
, icon.title AS icontitle, icon.iconpath
FROM pm AS pm
LEFT JOIN pmtext AS pmtext ON(pmtext.pmtextid = pm.pmtextid)
LEFT JOIN icon AS icon ON(icon.iconid = pmtext.iconid)
WHERE pm.userid=23 AND pm.folderid=0
ORDER BY pmtext.dateline DESC
LIMIT 0, 50

mysql error: Got error 28 from table handler

mysql error number: 1030

Date: Thursday 19th of May 2005 09:15:57 AM
Script: Removed
Referer: Removed
Username: 3yardsandacloud
IP Address: Removed
 
One of the partitions filled up to max capacity.

Managed to create a little space, but not much. Most of what's in there is mission critical, and me nuking and moving stuff comes at the risk of mangling the functioning of the site.

I may have to find someone with more of a clue to get in there and buy us some time. It was at 99%, now it's at 98%...

Anyway, the errors should go away briefly.
 
Upvote 0
I had almost 4000 PMs in my account, between my Inbox and Sent PMs. I just cleaned out over 500 old PMs from my Sent folder, and will eventually clean all but a few out, and then do the same for my Inbox. I know at least one person here on the site who had his allotment of 10000 PMs filled and had to clear some out just to get new PMs. I'm sure there are quite a few of us, especially admins and mods, who have a ton of PMs stored.

I think we may want to ask members to police their PM folders once in a while, and do the same ourselves. With 4000+ members, I'm sure that PMs, although singularly small in size, quickly end up taking a shit load of database space.
 
Upvote 0
BuckeyeNation27 said:
if we all delete our PMs...will that free up some space?
Click to expand...

It certainly will.

Not asking anyone to empty their PM folders entirely, nor is any action at all necessary. But if going through and organizing (deleting old stuff, keeping 'keepers') is something that's overdue for you, now is good. :)
 
Upvote 0
Clarity said:
It certainly will.

Not asking anyone to empty their PM folders entirely, nor is any action at all necessary. But if going through and organizing (deleting old stuff, keeping 'keepers') is something that's overdue for you, now is good. :)
Click to expand...
deleted all but four. maybe were down to 97%
 
Upvote 0
Mili....i thought i was the PM whore....:wink:

I will go through this weekend and get it down to a bare minimum.....even 1000 is just lazy on my part.....Heck, good thing i didnt know there was a way to store more....my lazy but would have found a way...
 
Upvote 0
Just spent a couple more beers worth of deleting. Went from just under 4000 PMs stored to 81 total. Hopefully I can get into the habit of cleaning out shit at least once a month...PMs add up faster than you think.
 
Upvote 0
You must log in or register to reply here.
Back
Top