[sedonagate]

I enabled an extra field for file upload of pdf documents, and the latest one I add to my listings is successful, but each time I add one to a listing, I notice the previously uploaded pdf files have all disappeared from the other listings that were already done!

I thought it was something I was doing, or my setting in Extra Fields for file upload, but it looks like it's all correct, and after all, I have one listing where it's appearing just fine. It's always the last listing I do that gets the file, while the others have all fallen out (disappeared). This seems like a major bug to me.

Thanks for anyone's help!!!

[sporthorsebreeder]

Hello Sedonagate
This is a bug in the file upload feature. See my previous post on the forum.
http://www.68classifieds.com/forums/...ead.php?t=1319

Eric in support fixed it for me. Here is what he changed.

"Here is what I had to change. This was both for the frontend and administration:"

Open the modify listing and locate this line:
$sSQL="DELETE FROM ".PREFIX."products_fields WHERE fID=".$fid;

Replace it with:
$sSQL="DELETE FROM ".PREFIX."products_fields WHERE pID=".$productid." AND fID=".$fid;

I hope that helps.
Hugh

[sedonagate]

Hi Hugh,

Wow you are so nice to help me out...thank you...I will try this (just getting to this today...)

Will let you know how it goes...

Victoria

[sedonagate]

Hi Hugh,

Yes that worked just fine! For future seekers of the solution to the problem as well, those two files specifically are:

1. httpdocs/administration/modifylisting.php

and

2. httpdocs/modifylisting.php

At first I was not sure which files to look into, so made backups of these, then fixed and uploaded them, and it all works now!

Thanks again for your help!
Victoria