Attachments as files

Well after alot of time leaving it in the beta hacks forums without any problems, I'm now moving it to the Full Releases, I'm satisfied that there isn't any bugs that need to be addressed. Thanks to Jawelin he pointed out most of the mistakes through alot of his testing.
I've attached it as an installer file here, as it needs to make changes to the database. Two new rows to settings and a new column in the attachment table.

Scott

Updated some more

Note the > is missing off the bottom of the file after the ?, add it before trying to install

[Tim Wheatley]

As I'm only testing I've empted the attachment table and wiped the line in the post table also, hopefully we can get the conversion for the next version?

Thanks.

[ptenthus]

Any idea when a conversion script to get a production board's attachments into the new vB3 format will be released?

I'd imagine that, even in beta, that this should be something that could be written now (not much chance of a change in data format during the beta process, right?)

[gmarik]

Yesterday at 11:01 PM Tim Wheatley said this in Post #340
Any news on this for the beta 3?

The same question. :disappointed:

[Tim Wheatley]

Scott has uploaded it here:
http://www.vbulletin.com/forum/showt...threadid=73467

[bitbender]

THANK YOU.

[roxics]

Does this limit file size uploads? What I mean is do you still have to edit PHP to accept larger file size uploads? I'd like my members to be able to attach videos up to 20MB's or more.

[bitbender]

Ok, I must have missed something. I have attempted to follow the path of redemption, and get my attachments working under my VB3.0 beta test. I am one of the hundreds that enjoy the attachments as files hack.

1. Took a good backup from 2.3.0 and restored it to my test server.
2. Added the filedata column back to the attachment table via phpmyadmin;
   

   ALTER TABLE attachment ADD filedata mediumtext NOT NULL

3. Ran an optimize on the attachment table (if I didn't, MySql kept getting 122 table handler errors at insert after a number of inserts)
4. Ensured that the current value for the VB setting field 'fileattach' was correct, and pointed to said directory where all the attachements were
5. Executed the attachment_upgrade.php from /vb22/admin directory (no output does it make to the panel, just a blank screen after it runs for about 3 minutes and then says "done" in the lower left )
6. Verified that 'filedata' column in the attachment table was populated with data via phpmyadmin
7. Ran the VB3 conversion (upgrade.php) on the DB, and yes, it worked thru the attachments, and then updated another table related to attachements

What I am seeing in my VB3.0 beta is broken links for the attachments. It "thinks" it got them, but in reality the file sizes are zero for the attachements (when you disable viewing of attachements, it gives a handy link with file size instead)

I really, really like what I have seen so far of VB3.0, but I gota beat this 1000 pound gorrilla where the attachments as files hacks is concerned.

Any ideas? If any one wants a look, let me know, as I have it locked down to stay in compliance with the "no public" rule

[shorty]

Hello BB .. have you enabled attachments as files in the VB3 backend?

Im gonna run this on my dev board then upgrade it to VB3 later.

I really wanna run it over at Short-media. Been live for two weeks and the forums db is over 300mb already :ermm:

Il let ya know how I get on. You are still on VB 2.3.0 aren't you?

[dssstorm]

I installed the hack and all my dl are 0kb any insite?

[bitbender]

Yesterday at 01:23 AM shorty said this in Post #348
Hello BB .. have you enabled attachments as files in the VB3 backend?

Im gonna run this on my dev board then upgrade it to VB3 later.

I really wanna run it over at Short-media. Been live for two weeks and the forums db is over 300mb already :ermm:

Il let ya know how I get on. You are still on VB 2.3.0 aren't you?

You dont have much choice, bud. You HAVE to load the attachments back to the DB, BEFORE you run the VB3 upgrade. The Upgrade.php will process only attachments that are in the data base.

Then, if that part WORKS right, you can go thru the part that moves them BACK to files via the attachment manager functions. But, neither worked, for me.

And I kind of figgured that, if it didn't display them properly and showed all zero file sizes when the attachments had been moved back to DB. When I used the VB3 admincp "backend" (as you are calling it, I have no idea what you meant) to move them back out, of course that failed too.

0 + 0 = 0.

The attachments folder in vb 2.3.0 (yes, I got the attachments as files hack working there, too) is close to 1GB in size.

Any real insight into this matter would be very helpful.