Closed (fixed)
Project:
Balance Tracker
Version:
6.x-1.6
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
16 Feb 2010 at 13:35 UTC
Updated:
2 Mar 2010 at 14:40 UTC
On a fresh install, on admin/reports/balances, I get the following error:
user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ISTINCT b1.uid) FROM balance_items b1' at line 1 query: SELECT COUNT(D ISTINCT b1.uid) FROM balance_items b1 in /home/leonth/webapps/leapon_net/sites/all/modules/balance_tracker/balance_tracker.module on line 675.
user warning: Unknown column 'bi1.balance' in 'order clause' query: SELECT b1.uid, (SELECT b.balance FROM balance_items b WHERE b.uid = b1.uid ORDER BY b.bid DESC LIMIT 0,1) as balance FROM balance_items b1 GROUP BY b1.uid ORDER BY bi1.balance DESC LIMIT 0, 50 in /home/leonth/webapps/leapon_net/sites/all/modules/balance_tracker/balance_tracker.module on line 675.
Using drupal 6.15.
Comments
Comment #1
brianV commentedThere is definitely a space there, but the module operates / installs / uninstalls correctly on my test site. Anyways, it's been fixed in CVS...
Comment #2
brianV commentedFix released in 1.7