Home » Projects » Ubercart Contributed Modules » Ubercart Contributions » Issues

File Downloads Randomly Disappearing

Submitted by helderluis on Thu, 04/09/2009 - 05:36
Project:Ubercart Contributions
Component:Code
Category:bug report
Priority:critical
Assigned:helderluis
Status:active
Description
Project: 
Ubercart

http://www.ubercart.org/forum/bug_reports/8594/file_downloads_randomly_d...

"Hey all, I have an interesting (and perplexing issue) with Ubercart 2.0-beta2 (running on drupal 6.9). I'm currently using the file downloads module to sell a subscription to a series of files. I set them to not expire and with a limit of 35 downloads per file. For awhile, this works great! Unfortunately, I've began to notice that as time goes on (an hour or so), seemingly random files disappear off of people's accounts.
I can't seem to figure out a pattern as to why this happens. If I go back in through admin and restore access to that file, an hour or so later multiple files will be missing from their account. The files themselves are not being deleted from my directory either, they're all still there."
ibuprofen

I think i'm experiencing the same problem, but i'm running Drupal 6.8 + Ubercart 6.x-2.0-beta5.

After i create a product page and assign a "Download" "Feature" it all works out for a couple of hours, then it disappears from the Features tab, the only thing remaining is the "Role Assignment" Feature (previously set up).

If i set it up again, it works again for a couple of hours, then it vanishes again...

Has anyone found a solution for this problem yet? I have a site that needs to go online and is stalled because of this!

Thanks,
Helder Luis

Version: 
Ubercart 2.0-beta4
Thu, 04/09/2009 - 09:42
#1 View page
Lyle
Lyle's picture
Offline
AdministratoreLiTe!
Joined: 08/07/2007
Juice: 6846
Re: File Downloads Randomly Disappearing

Files that people have bought disappearing off of their accounts sounds like a different problem from file download features disappearing from their products. I suppose they could be related in that it sounds like something is removing rows from their database tables. Check the uc_files, uc_file_products, uc_file_users, and the uc_product_features tables in your site's database. If some rows are missing that should be there, we can start tracking down whatever is deleting them.

Top
Thu, 04/09/2009 - 10:17
#2 View page
helderluis
helderluis's picture
Offline
Joined: 04/07/2009
Juice: 19
Tables in question...
Assigned to:Lyle» helderluis

Hi, thank you for your reply...since i don't know what to look for in case something is missing, here are the tables you mentioned...

Does it help? Do you need more info?

Just ask... thank you for the help!

Table: uc_file_products:

Field Type Collation Attributes Null Default Extra Action
fpid int(10) UNSIGNED No auto_increment
pfid int(10) UNSIGNED No 0
fid int(10) UNSIGNED No 0
model varchar(255) utf8_general_ci Yes NULL
description varchar(255) utf8_general_ci Yes NULL
shippable tinyint(4) No 0
download_limit int(11) Yes -1
address_limit int(11) Yes -1
time_granularity varchar(16) utf8_general_ci No -1
time_quantity int(11) No -1

Table: uc_file_users:

Field Type Collation Attributes Null Default Extra Action
fuid int(10) UNSIGNED No auto_increment
fid int(10) UNSIGNED No 0
uid int(10) UNSIGNED No 0
pfid int(10) UNSIGNED Yes NULL
file_key varchar(32) utf8_general_ci No
granted int(11) No 0
expiration int(11) Yes 0
accessed smallint(5) UNSIGNED No 0
addresses text utf8_general_ci Yes NULL
download_limit int(11) Yes NULL
address_limit int(11) Yes NULL

Table: uc_product_features:

Field Type Collation Attributes Null Default Extra Action
pfid int(10) UNSIGNED No auto_increment
nid int(10) UNSIGNED No 0
fid varchar(32) utf8_general_ci No
description text utf8_general_ci Yes NULL

Top
Tue, 04/14/2009 - 13:15
#3 View page
helderluis
helderluis's picture
Offline
Joined: 04/07/2009
Juice: 19
Any news?

Just checking to see if you got any news on the subject...

I've already posted the tables you asked, need anything more?

Thanks,
hl

Top
Tue, 04/14/2009 - 14:28
#4 View page
Lyle
Lyle's picture
Offline
AdministratoreLiTe!
Joined: 08/07/2007
Juice: 6846
Re: Any news?
Assigned to:helderluis» Lyle

Those are just the columns. I was wondering more if you could see if any particular rows were in the tables that you couldn't see as files on the website, or if they really weren't there in the database.

Top
Fri, 06/17/2011 - 19:26
#5 View page
Bill-TNB
Bill-TNB's picture
Offline
Joined: 06/17/2011
Juice: 2
#5
Category:» bug report
Assigned to:Lyle» helderluis

I'm seeing the same issue (files getting removed from their products)

The module seems to work fine with a single file/product; however, when I go to add a second product ... it seems to truncate the the uc_files table, cascade deleting the files in uc_file_products and uc_file_users.

It then rescan the download folder, and fills out the uc_files table again.

EDIT:
Appears that when uploading the files of SFTP, it didn't end up with write permission, which seemed to be the cause of this.

Top
Tue, 07/12/2011 - 22:46
#6 View page
royerd
royerd's picture
Offline
Joined: 01/22/2008
Juice: 293
#6

similar problem. random. I'm wondering if it's related to the sequence table. Not sure.

Top
Sat, 07/16/2011 - 08:33
#7 View page
royerd
royerd's picture
Offline
Joined: 01/22/2008
Juice: 293
#7

Can you say a little more about the permissions issue here? What permission was needed? What permission was automatically assigned on FTP upload? Do you know why this would delete records from the tables?

Any clues here would be appreciated.

Dan

Top