What's this?

user error: Unknown table 'n' in on clause
query: SELECT SUM(wishlist_purch_quantity) as quantity_purchased FROM wishlist_purchased INNER JOIN node_access na ON na.nid = n.nid WHERE (na.grant_view = 1 AND CONCAT(na.realm, na.gid) IN ('all0','term_access2','term_access5','term_access7','term_access9')) AND wishlist_purch_nid = 127 in C:\webapps\xampp\htdocs\drupal\includes\database.mysql.inc on line 66.
user error: Unknown table 'n' in on clause
query: SELECT p.wishlist_purch_wid, p.wishlist_purch_buyer_uid, p.wishlist_purch_quantity FROM wishlist_purchased p INNER JOIN node_access na ON na.nid = n.nid WHERE (na.grant_view = 1 AND CONCAT(na.realm, na.gid) IN ('all0','term_access2','term_access5','term_access7','term_access9')) AND p.wishlist_purch_buyer_uid=2 AND p.wishlist_purch_nid=127 in C:\webapps\xampp\htdocs\drupal\includes\database.mysql.inc on line 66.
user error: Unknown table 'n' in on clause
query: SELECT SUM(wishlist_purch_quantity) as quantity_purchased FROM wishlist_purchased INNER JOIN node_access na ON na.nid = n.nid WHERE (na.grant_view = 1 AND CONCAT(na.realm, na.gid) IN ('all0','term_access2','term_access5','term_access7','term_access9')) AND wishlist_purch_nid = 126 in C:\webapps\xampp\htdocs\drupal\includes\database.mysql.inc on line 66.
user error: Unknown table 'n' in on clause
query: SELECT p.wishlist_purch_wid, p.wishlist_purch_buyer_uid, p.wishlist_purch_quantity FROM wishlist_purchased p INNER JOIN node_access na ON na.nid = n.nid WHERE (na.grant_view = 1 AND CONCAT(na.realm, na.gid) IN ('all0','term_access2','term_access5','term_access7','term_access9')) AND p.wishlist_purch_buyer_uid=2 AND p.wishlist_purch_nid=126 in C:\webapps\xampp\htdocs\drupal\includes\database.mysql.inc on line 66.

Comments

bigbman’s picture

bigbman commented

actually, I found your fix in CVS. Sorry for the false alarm - everything (except for hiding 'purchased' items from the user) is working great.

scott.mclewin’s picture

scott.mclewin commented
Assigned: Unassigned » scott.mclewin

Ah good. I read this after my rather lenghy post in reply to your comment in the other thread. I'm glad to hear that it is working and that the patch did the job.

scott.mclewin’s picture

scott.mclewin commented
Status: Active » Closed (fixed)

closing issue. See this issue for full details.