_(I'm not sure the title makes sense, change if you can find a better title)_

Hi, today I needed to alter the flippy query used get the related nodes (first, last, etc..) using a join on a table that uses the ``nid`` as a key, so I stumbled tinto this error:

PDOException: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'nid' in where clause is ambiguous:

I took a look into the flippy code and I noticed that in some places it refers to the nid without using the 'n.nid' notation, so I created this patch to fix this issue.

If you need any further explanation just ask. :)

CommentFileSizeAuthor
#1 2356203-flippy-use-table-alias-with-nid.diff1.24 KBesolitos

Comments

esolitos’s picture

esolitos
he/him
Primary language Italian
Location Trondheim
commented
StatusFileSize
new 2356203-flippy-use-table-alias-with-nid.diff1.24 KB

Patch File

  • esolitos authored 88da739 on 7.x-1.x 
    Issue #2356203: nid in query needs to have table name as prefix.
rli’s picture

rli
Primary language English
Location Canberra
commented
Status: Needs review » Fixed

Committed to dev.

Thanks.

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.