Patch (to be ported)
Project:
Node Limit Number
Version:
6.x-2.0-beta2
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
28 Feb 2011 at 17:16 UTC
Updated:
5 Jul 2011 at 08:05 UTC
Basically i tried to create a rule that limits the amount of published items per Group (using OG integration) and I got an SQL error saying:
User warning: Column 'nid' in field list is ambiguous query: SELECT nid FROM node INNER JOIN og_ancestry ON node.nid=og_ancestry.nid WHERE og_ancestry.group_nid = 123 AND node.type='philosophy' in _db_query() (line 128 of /home/matiasfigueroa/grey/grey-site-www/grey-dev/includes/database.mysql.inc).
this is easily solved modifying just one line of the code, the one with the query with the ambiguous column SELECT.
I've attached a patch with the fix for this, I've tested it on my environment and it worked just fine.
Regards
| Comment | File | Size | Author |
|---|---|---|---|
| node_limitnumber.patch | 735 bytes | mx7102 |
Comments
Comment #1
held69 commentedConfirming the patch is working.
Thanks!