feed items seem no longer attached to the feed
| Project: | Leech |
| Version: | 5.x-1.8 |
| Component: | leech |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | postponed (maintainer needs more info) |
Jump to:
It seems that since the upgrade to leech 1.8 feed items have lost their connection to the feeds when you go on the feed item and click "edit".
When I go and edit a page, I get this error:
user warning: Unknown column 'n.nid' in 'on clause' query: SELECT DISTINCT(n.nid), n.title FROM node n, leech_news_feed f LEFT JOIN leech_news_item lni ON n.nid = lni.nid WHERE ((lni.fid NOT IN(SELECT id FROM contentblocker WHERE type = 'leech_news_feed' AND uid = 1) OR lni.fid IS NULL) AND (n.uid NOT IN(SELECT id FROM contentblocker WHERE type = 'user' AND uid = 1) OR n.uid IS NULL)) AND ( f.nid = n.nid) in /var/www/html/geekfr/includes/database.mysql.inc on line 172.
It seems that this is maybe related to contentblocker module, but I'm not sure, any idea what this error is about?
If I check out all the feed items for a specific feed I can see that the feed items are still associated with their feed, but just not when I edit a specific feed item, the feed field is actually empty.
Thanks for any input you could give me!
Patchak
#1
From which version did you upgrade?
#2
It stopped working when I upgraded from 1.7 to 1.8 and I tested also with 1.9 and it's the same problem...
Thanks
#3
I tried hard to reproduce this error without success. It 'd be great if you can tell me if in your environment, Is this bug reproduceable without 3rd party modules enabled?
If yes - please share more details on the server environment, like php and mysql version
If no - i'd like to get an exact list of 3rd party modules enabled (with all the settings - it'd be good to share the DB dump of the site if possible. It can speed up my debugging process)