On fresh Drupal install I put essential modules active and create a product. At userpoints features setting of the product I tried to add 3 points to the product, but on Add got below message:

user warning: Unknown column 'fid' in 'where clause' query: select pfid from uc_userpoints_products where nid = 0 and fid = 0 in /home/example/public_html/drupal/sites/all/modules/userpoints_ubercart/uc_userpoints_product.module on line 110.

Are other experiencing this problem?
I have run update.php and have everything up to date.

Thank you!

Comments

Bilmar’s picture

Bilmar commented

additionally, when i press Edit under Operations on the userpoints feature that was just added - it always shows Number of points: 0 even though I saved as 3. Is this as per design?

I hope this helps troubleshoot if this is a bug.

Thank you!

trackleft’s picture

trackleft commented

I am also receiving the same issue, but it only happened one time out of two, meaning it only happened the first time I added points to a product..

trackleft’s picture

trackleft commented

Actually, it happens every time I add points to a product. OOOpppss

trackleft’s picture

trackleft commented

And it doesn't add points to a user at all, I added a column to the database in table uc_userpoints_products and the error message goes away, but it still doesn't add points to the user when they buy the product..

betz’s picture

betz commented
Status: Active » Closed (duplicate)

This problem is known and solved if you apply following patch: http://drupal.org/node/595890#comment-2115520
I will commit it, but i'm refreshing my cvs knowledge before once more ;)