Posted by prasoon gupta on June 15, 2008 at 10:46am
3 followers
Jump to:
| Project: | User Points |
| Version: | 6.x-1.x-dev |
| Component: | Other |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed (fixed) |
Issue Summary
I got this warning displayed on User Account page
"user warning: Unknown column 'tid' in 'where clause' query: SELECT points FROM userpoints WHERE uid = 1 AND tid = 0 in /home/computl9/public_html/creativeteensclub/ctc/modules/userpoints/userpoints.module on line 421."
I had just enabled UserPoints..
Please Help
Comments
#1
This was the error message on Use By Point (userpoints) page
* user warning: Unknown column 'tid' in 'where clause' query: SELECT COUNT(DISTINCT(uid)) FROM userpoints WHERE tid = 0 in /home/computl9/public_html/creativeteensclub/ctc/modules/userpoints/userpoints.module on line 1337.
* user warning: Unknown column 'p.tid' in 'field list' query: SELECT p.uid, u.name, p.points, p.tid, t.name as cat FROM userpoints p INNER JOIN users u USING (uid) LEFT JOIN term_data t ON p.tid = t.tid GROUP BY p.uid, u.name, p.points, p.tid, t.name ORDER BY p.points DESC LIMIT 0, 30 in /home/computl9/public_html/creativeteensclub/ctc/modules/userpoints/userpoints.module on line 1337.
#2
The schema does have the tid column in it, so why has it not been created?
Can you please paste the output from this SQL command:
SHOW CREATE TABLE userpoints;Did you install an old 5.x-2.x, then add 6.x-1.x-dev on top of it? Or what?
#3
yes earlier I had 5.x now using Fantastico i installed 6.2 .. earlier I was very angry to see that 6.2 doesnt support 5.x modules.. but later i found many new 6.2 modules..
but few of them were not working.. Fivestar is now working after Database Update. but Userpoint gives error still..
I dont know how to execute SQL commands.. can u give a simple idea.. I also want to contribute to Open Source.. and this community is made 4 students. http://www.creativeteensclub.org . so if i will know about how to develop module i can do much better..
#4
Try to run update.php and see if it solves the problem.
If not, then it is better to uninstall userpoints (not just disable, also uninstall), then install it again fresh.
Let us know if either of them solves the issue.
#5
Ok I will try uninstalling it,, and installing it again..
Thanks for your response,, this is my best experience with drupal.. mean i am getting help from it.. something i was not able to get till now.. m very happy.. m in class 11.. and started this website for teens n students.
#6
i removed the the userpoint folder from the modules directory..
then I ran update.php to refresh database.
then I again uploaded the the module "userpoint" in module directory.
then i enabled the module in Admin > Site building > modules
but again the same problem has occurred :
On clicking adjust button on the user profile, I added Points to the user's account.
it gave following messege ->
user warning: Unknown column 'operation' in 'field list' query: INSERT INTO userpoints_txn (uid, points, time_stamp, status, operation, description, reference, expirydate, expired, parent_txn_id, tid, entity_id, entity_type) VALUES (28, 2, 1214931594, 0, 'admin', '
', '', 0, 0, 0, 0, 0, '') in /home/computl9/public_html/creativeteensclub/ctc/modules/userpoints/userpoints.module on line 713.
i am not able to understand, will i have to uninstall the module then install a new one.. but that will lead to loss of old data that was in drupal 5.x .
But lossing data is not the problem please tell me shall i try that.
#7
Use the uninstall tab after disabling the module, then try again using the latest download.
#8
YES Its working Now..
i uninstalled old .. and fresh installed new..
#9
shouldnt this be fixed? it has been a while since a response and seems to have his problem solved
#10
Automatically closed -- issue fixed for two weeks with no activity.