[bitbender]

Today at 01:32 AM shorty said this in Post #359
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;

   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;

   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!