Was wondering if this hack is kinda like what vb3 does now? It saves attachments as files and your database size will be greatly reduced correct? But Diskspace will be increase??

The main benefit that i can see and want is ease of transfering to a new server without dealing with the attachments in the database. Let me know.

Oh my god, you do not know what this hack has done to my forum! THANK YOU SO MUCH!

I had to disable attachments due to such a large database, anyways, this is a miracle hack!!

Very good work! Best Hack Ever Made!!!

:banana: :banana: :banana:

After some problems initially the hack now works on my 2.3.0 test site & I have tried attach, edit & delete attachments.

Although I delete an attachment in a post, or delete the whole post itself, the file attachment still remains in the /home/mystuff/attachments folder

Why does it not delete the attachments at the same time as the thread?

Have I missed something in editing another file?

Thanks

john

any idea when the attachments as files hack will be ready for vb3?

Im just wondering if this is even worth installing alot of people have had errors so is it worth installing

This is a excelent hack, but I need to uninstall it and placed files back into the data base to upgrade to vB 3.0 Beta 4 on my development site.

Is there a easy way ?

skc vB 3.0 has this hack built in as of beta 4

WOOOOOTTT!!!

FIxed as of Beta 5 for me !!

W000TTT!!

PARTY ON !! :) ( i know, it doesn't take much for me)

If this is true.. Im installing this hack tonight!

Thanks for the information BB that it works with beta 5.

Yep, it IS true !! It was Soo true I did it three times!! (ok, so I couldn't sleep last nite)

Be SURE to follow the instructions closely, and be patient.

MY issue was that even thou I altered the attachpath variable to be the CORRECT value, the cache was still point back to the place I restored it FROM (an invalid path).

So, I flushed cache, and ran again, and log and behold, it worked just fine.


So....here is what I did.

1. Create a backup (I have a cron script, but it's the same as reccomended by the VB3.0 upgrade)
2. Create a database for VB 3.0 (if your host only allows one, of course you cannot do this)
3. Restore the new DB using the backup just made (Skip this is you only have one DB available to you)
4. Using PHPmyAdmin, add the field filedata back to the attachments table;
   Code:

   ---

   ALTER TABLE attachment ADD filedata mediumtext NOT NULL

   ---

5. Run Repair, and Optimize on the attachment table using the functions in PHPMyAdmin
6. Again, using PHPmyAdmin, select the settings table, and locate the variable attachpath Edit this to ensure you have the CORRECT path there. What's key here is that it is an absolute path;
   Code:

   ---

   For my installation it was;
/home/virtual/site22/fst/var/www/html/vb30/attach_folder

   ---

7. Execute admin/attachment_upgrade.php - On the BBF test Server, a full copy of VB 2.3.0 was already place in the VB30 directory structure, so that prior to the VB30 cutover I could still access it as 2.3.0. The script attachment_upgrade.php depends on the vb 2.x struture to be intact and in place to work correctly. Believe me, I called it's bluff.
8. Once That completed, I proceeded thru the install/upgrade.php, no issues, or worries, straight thru. It DID take some time, as 1.3 GB worth of attachment files takes a bit of time.

Next up? Pushing them BACK out to the file system, along with the Av's!

PARTY on VB!! I'm renewing today! Totally pleased, am I!