unknown column in i.nodes
| Project: | Kudos |
| Version: | 6.x-1.5 |
| Component: | Code |
| Category: | support request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed |
Jump to:
General Issue
We loaded the module files, enabled the module, set permissions and then configure Points and Kudos settings. My configurations aren't anything special so I have a hard time thinking that's the source of the issue. But then as I go leave the config settings page, and go to the home page I start seeing some nasty sql errors.
* user warning: Unknown column 'i.nodes' in 'where clause' query: SELECT i.id, i.name, i.label, i.status, i.comments, i.icon_give, i.icon_rescind, i.icon_disabled , (SELECT 1 FROM kudos_granted g WHERE g.kudo_id = i.id and g.content_type = 'node' AND g.content_id = 783 AND g.uid = 29) as given FROM kudos_info i JOIN kudos_info_types t ON i.id = t.kudo_id AND t.node_type = 'grouppost' WHERE i.nodes = 1 AND i.status = 1 in /var/www/html/community/sites/all/modules/kudos/kudos.inc on line 336.
* user warning: Unknown column 'i.nodes' in 'where clause' query: SELECT i.id, i.name, i.label, i.status, i.comments, i.icon_give, i.icon_rescind, i.icon_disabled , (SELECT 1 FROM kudos_granted g WHERE g.kudo_id = i.id and g.content_type = 'node' AND g.content_id = 776 AND g.uid = 29) as given FROM kudos_info i JOIN kudos_info_types t ON i.id = t.kudo_id AND t.node_type = 'grouppost' WHERE i.nodes = 1 AND i.status = 1 in /var/www/html/community/sites/all/modules/kudos/kudos.inc on line 336.
* user warning: Unknown column 'i.nodes' in 'where clause' query: SELECT i.id, i.name, i.label, i.status, i.comments, i.icon_give, i.icon_rescind, i.icon_disabled , (SELECT 1 FROM kudos_granted g WHERE g.kudo_id = i.id and g.content_type = 'node' AND g.content_id = 800 AND g.uid = 29) as given FROM kudos_info i JOIN kudos_info_types t ON i.id = t.kudo_id AND t.node_type = 'grouppost' WHERE i.nodes = 1 AND i.status = 1 in /var/www/html/community/sites/all/modules/kudos/kudos.inc on line 336.And going back to the points settings page, I see more
warning: Invalid argument supplied for foreach() in /var/www/html/community/sites/all/modules/kudos/contrib/kudos_userpoints/kudos_userpoints.module on line 23.
Environment Background
- Drupal 6.10 with the 6.11 patch applied.
- MySql 5.0.58
- PHP 5.2.9
- Apache 2.28
- Kudos 6.x.1.5
- Voting API 6.x-2.0-rc2 http://drupal.org/project/votingapi
- User Points 6.x.1.0 http://drupal.org/project/userpoints
We have a lot of other optional modules installed too. A few examples you may be interested in: Views, CCK, FCK Editor, Organic Groups, 5 Star Voting, Webform, Messaging, Notifications, FCK Editor, and since this is our dev box we also have Devel, Administration Menu, Demonstration Site. We have quite a few more but I doubt they'd cause an issue.
Does anything jump out at you as to what might be going on?
#1
Hi, There was a problem with the install hook. If you run update.php, it may fix it. I've also just pushed an updated version of the module which should also fix the problem.
#2
Thanks for your prompt response.
Running update.php didn't do anything. I'll try the new version next and post an update accordingly.
#3
After installing 6.x-1.6, the sql error is gone. error one above.
But the second error message on the points settings page is still there. E.g.
warning: Invalid argument supplied for foreach() in /var/www/html/community/sites/all/modules/kudos/contrib/kudos_userpoints/kudos_userpoints.module on line 23.I'm seeing unexpected behavior in other places too. But it could easily be just getting my head around the module. Or, it could be the above error message is a sign of a bigger problem. I'll post back as I know more.
#4
When does this occur? Have you set up kudos for each piece of content?
Does this happen when you attempt to grant a kudo to another user?
Thanks... any info you provide will be extremely helpful.
#5
It first happened as I was setting up my configuration and as I went to the Points settings page.
I proceeded to set things up and everything saved fine. So I proceeded to the kudos config pages. No errors there. But if I go back to the Points settings page, I still see that same error.
#6
Automatically closed -- issue fixed for 2 weeks with no activity.