Export bug

mobil1_oils · Post by **mobil1_oils** » Wed Sep 07, 2005 8:06 am

I just realised after running out of space, that i would now have to remove some of my old posts, So i decided to start with the month i opened my blog, which was december 2004, and i realised that it only goes up to November 2004, there is no december. Also, there isn't a way you can download all the months at once is there? lol.

Post by **Scott** » Wed Sep 07, 2005 8:33 am

Will fix the months problem in a second. I'm afraid you can only do 1 month at a time, otherwise it would put a bit of a strain on the server.

mobil1_oils · Post by **mobil1_oils** » Wed Sep 07, 2005 8:36 am

Figured as much with the strain on the server, but thanks /smile.gif' class='bbc_emoticon' alt=':)' />,

Post by **Scott** » Wed Sep 07, 2005 8:39 am

December is back on the calendar...wouldn't like to miss that month out /cry.gif' class='bbc_emoticon' alt=':(' />

mobil1_oils · Post by **mobil1_oils** » Wed Sep 07, 2005 9:16 pm

Yeah, thats when all the cheery happy posts about all the free stuff you got are made /blum.gif' class='bbc_emoticon' alt=':P' />.

Just a thought too, don't know if this is plausible but maybe when you make the export.tar file, could you include the date in the filename? so when you're exporting multiple files you can have export1204.tar for december or something, just so you don't have to export it, then unzip it to a directory, or rename it so you know which month it is. Shoot me if i'm going to fast here /blum.gif' class='bbc_emoticon' alt=':P' />.

Post by **Scott** » Thu Sep 08, 2005 12:14 am

The problem with that is that the .rars would then build up in the /temp dir. At the moment export.rar is being rewritten every time someone exports, so not too much of a problem.

I'll ponder it...

mobil1_oils · Post by **mobil1_oils** » Thu Sep 08, 2005 7:54 am

Yeah, i didn't think of that, but is there a way you could set it to remove the .rar from the /temp directory after the user downloads it? Sorry if that didn't make any sense, i've been out all night and i just got home and i'm so tired, but not tired also (if anyone knows how that feels, it's like you feel tired, but you really don't want to go to bed because you've got urges to just go out and do something, but you live in a town where theres nothing to do except A) go to the pub, or /shades.gif' class='bbc_emoticon' alt='B)' /> go to the 24 hr kebab shop [which i might add, usually comes in handy after going to option A])

Josh · Post by **Josh** » Thu Sep 08, 2005 1:40 pm

[quote name='Vulture' date='Sep 7 2005, 09:39 AM']December is back on the calendar...wouldn't like to miss that month out /cry.gif' class='bbc_emoticon' alt=':(' />
[right][post="28356"][/post][/right][/quote]

I would. /smile.gif' class='bbc_emoticon' alt=':)' /> *stabs your creepy santa you put on your blog* O_o

Post by **Scott** » Thu Sep 08, 2005 1:54 pm

/dry.gif' class='bbc_emoticon' alt='<_<' /> That Santa pwns j00. Period.

mobil1_oils · Post by **mobil1_oils** » Sat Sep 10, 2005 7:55 am

Ok, i exported all posts from december 04, till september 05, and renamed them all and have them saved. But when i went to prune comments, december is missing from those aswell /cry.gif' class='bbc_emoticon' alt=':(' />.

Also, when you click "Support" on the KB page, then click "Forum" it leads straight to an Apache test page for me. Even when i hold shift and refresh. But if i type the page in exactly as it was before by hand and shift+refresh it, it loads the forum fine :s. Anyone else get this prob?

EDIT: Pruned the comments from my blog, it only has 8 pages of comments now, well under the threshold, but still it's showing my remaining space as 0, and it wont let anyone post comments yet.

Josh · Post by **Josh** » Sat Sep 10, 2005 8:23 am

yes, I get a cent-os test page. :\

Post by **NightStorm** » Sat Sep 10, 2005 8:59 am

MySQL is showing you as using 503.4KB, mobes...
If you're having a real hard time cleaning out enough to bring you under the total, I suppose I could go in sometime today and remove all the "http://" from the 'poster_url' field... since they are not real links, anyway.
That would probably be enough to bring it down.

mobil1_oils · Post by **mobil1_oils** » Sat Sep 10, 2005 9:25 am

What exactly is the threshold amount? because when kb2 came in, i was about 4kb under the limit, then 2 more posts put me over, so i cleaned out about 11 pages of posts and i'm still over the amount. The majority of posts on there at the moment i will delete soon anyway, as they are december 04 posts that i can't get to at the moment /blum.gif' class='bbc_emoticon' alt=':P' />.

Post by **NightStorm** » Sat Sep 10, 2005 9:36 am

846 posts right now in there. I have you down to 501.1 KB database size... I believe the limit is 500KB.
I'll see if I can shave off a little more, just to get you back to a usable size.

mobil1_oils · Post by **mobil1_oils** » Sat Sep 10, 2005 9:40 am

Any posts that are in there up to June 2005, should have been removed. Because i don't see how there could be 800 odd posts, unless thats including comments aswell. Thanks for trying to get me under the limit too /smile.gif' class='bbc_emoticon' alt=':)' />.

Post by **NightStorm** » Sat Sep 10, 2005 9:49 am

Yeah, it counts comments as well... the current total, as stands, is 500.9 KB. And I won't be able to get it any lower without either chopping the posts/comments themselves, or removing important data which would cause a critical error on your blog (I'm sure neither of which you would want).
By the looks of it, if you could find 1 more good one to trim, you should drop below the max limit. Your Ashlee Simpson post/comments would likely give you more than enough space... its probably taking up a 100kb or 2 just in itself.

mobil1_oils · Post by **mobil1_oils** » Sat Sep 10, 2005 9:54 am

According to the blog, the Ashlee Simpson post should be already gone. I searched all 8 pages and found nothing.

Post by **NightStorm** » Sat Sep 10, 2005 10:03 am

179 comments for "Stop Ashlee".
The original blog post is also still listed in the database, so as far as it is concerned, the topic is still around.
Might want to report it as a bug, if your site says the topic is gone.

mobil1_oils · Post by **mobil1_oils** » Sat Sep 10, 2005 10:06 am

I'll let Scott read this thread and see what he thinks, I'm going to prune out all of december, which is a good 5 pages of posts when i can too, so hopefully that will bring me in under aswell. Thanks for having a look in the db for me though.

Post by **Scott** » Sun Sep 11, 2005 3:24 am

From what I can see your only using around 185KB (give or take), so you should be well under the limit. The "Stop Ashlee" post does not exist in the database. /smile.gif' class='bbc_emoticon' alt=':)' />

mobil1_oils · Post by **mobil1_oils** » Sun Sep 11, 2005 5:17 am

Yeah, it's all good now, it say's i've still got about 322kb now, thanks /smile.gif' class='bbc_emoticon' alt=':)' />.

Josh · Post by **Josh** » Sun Sep 11, 2005 6:08 am

Maybe it's just a little slow to communicate from website to database? /blum.gif' class='bbc_emoticon' alt=':P' />