Re: Database upgrade bugs

Posts: 6
Joined: 11/25/2007

I still have some errors using the uc_file on beta 2(I have reported the same problem previously when I upgraded to alpha8 as well........)

On the page...http://....../admin/store/products/files

There is this error.
user warning: Unknown column 'fp.fid' in 'on clause' query: SELECT n.nid, f.filename, n.title, fp.model, f.fid, pf.pfid FROM uc_files as f LEFT JOIN uc_file_products as fp ON (f.fid = fp.fid) LEFT JOIN uc_product_features as pf ON (fp.pfid = pf.pfid) LEFT JOIN node as n ON (pf.nid = n.nid) ORDER BY f.filename ASC LIMIT 0, 50 in /home2/portabl/public_html/includes/database.mysql.inc on line 172.

On the check out page.......
I have this error..
user warning: Unknown column 'shippable' in 'field list' query: SELECT shippable, model FROM uc_file_products as fp INNER JOIN uc_product_features as pf ON pf.pfid = fp.pfid WHERE nid = 162 in /home2/portabl/public_html/includes/database.mysql.inc on line 172.

The only workaround I have is by using the good old uc_file_product 1.7.4

However, I would still like to get this sorted and use the new uc_file module instead. I have tried to run the uc_file update #1 again and even tried to manually made the required database update. However, I still see the same error.

Does anyone know how do I fix this problem?

Puzzled...
Eric

I've got beta things to do... By: Ryan (34 replies) Wed, 01/16/2008 - 18:19