File downloads problem (I think)
| Project: | Ubercart |
| Version: | 6.x-2.x-dev |
| Component: | Code |
| Category: | support request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed |
Jump to:
After having purchased my product (using paypal webpayments standard) I go back to my site where I'm greeted with this:
* user warning: Unknown column 'key' in 'field list' query: INSERT INTO uc_file_users (fid, uid, pfid, `key`, granted, accessed, addresses) VALUES (148, 1, 56, '4ca43757340bc8161d7f4bb4c483caef', 1227303142, 0, 'a:0:{}') in /home/ucmeta5/public_html/starlightjournal.com/sites/all/modules/ubercart/uc_file.original/uc_file.module on line 942.
* user warning: Unknown column 'key' in 'where clause' query: SELECT * FROM uc_file_users WHERE uid = 1 AND `key` = '4ca43757340bc8161d7f4bb4c483caef' in /home/ucmeta5/public_html/starlightjournal.com/sites/all/modules/ubercart/uc_file.original/uc_file.module on line 943.
* user warning: Unknown column 'key' in 'field list' query: INSERT INTO uc_file_users (fid, uid, pfid, `key`, granted, accessed, addresses) VALUES (592, 1, 57, '1b3125e7367a1c3872ab5493979470ea', 1227303142, 0, 'a:0:{}') in /home/ucmeta5/public_html/starlightjournal.com/sites/all/modules/ubercart/uc_file.original/uc_file.module on line 942.
* user warning: Unknown column 'key' in 'where clause' query: SELECT * FROM uc_file_users WHERE uid = 1 AND `key` = '1b3125e7367a1c3872ab5493979470ea' in /home/ucmeta5/public_html/starlightjournal.com/sites/all/modules/ubercart/uc_file.original/uc_file.module on line 943.
* user warning: Unknown column 'key' in 'field list' query: INSERT INTO uc_file_users (fid, uid, pfid, `key`, granted, accessed, addresses) VALUES (591, 1, 58, '087bf77258bb855048e1f95f1d294867', 1227303142, 0, 'a:0:{}') in /home/ucmeta5/public_html/starlightjournal.com/sites/all/modules/ubercart/uc_file.original/uc_file.module on line 942.
* user warning: Unknown column 'key' in 'where clause' query: SELECT * FROM uc_file_users WHERE uid = 1 AND `key` = '087bf77258bb855048e1f95f1d294867' in /home/ucmeta5/public_html/starlightjournal.com/sites/all/modules/ubercart/uc_file.original/uc_file.module on line 943.
Then, when I go to my account, files I see no files for download but see this:
user warning: Unknown column 'key' in 'field list' query: SELECT granted, filename, accessed, description, `key`, f.fid FROM uc_file_users as u LEFT JOIN uc_files as f ON u.fid = f.fid LEFT JOIN uc_file_products as p ON p.pfid = u.pfid WHERE uid = 1 ORDER BY u.granted DESC LIMIT 0, 50 in /home/ucmeta5/public_html/starlightjournal.com/sites/all/modules/ubercart/uc_file.original/uc_file.pages.inc on line 29.
The status of my order is complete. Any help?
#1
Be sure to run update.php any time you update to the latest dev snapshot.
#2
I ran update.php, and got those messages. I even ran it just now and though I can't verify the post purchase errors, the error in the Files section of My Account is still there.
#3
I'm not sure how this got "fixed" but the issue is still active.
#4
When I look at the latest uc_file.install, I see that the key field and all its queries were updated to file_key. Perhaps you just failed to update completely, but grab the latest code for 6.x-2.x-dev and re-run the updates. Honestly, we're not handling support here and as far as I can tell, this is not a bug in the current development code. That's why I marked it fixed... I just think you're running old code.
#5
Hi there. I don't want to waste anyone's time here, so maybe someone can point me where I should be posting this? I have installed the latest dev for Drupal 6. I have run update.php, and I'm still getting this error code under My Account, and File downloads:
The only other thing I can add to this is that I did take the advice from this post http://drupal.org/node/331667. Could this mix things up?
I'm sorry to bother you on here, and would be more than happy to take this to the correct place.
#6
Automatically closed -- issue fixed for two weeks with no activity.