Posted by Jupiter on June 24, 2008 at 6:54pm
Jump to:
| Project: | Site notes |
| Version: | 5.x-1.3 |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | NancyDru |
| Status: | closed (fixed) |
Issue Summary
I get this SQL error in the sitenotes display page :
* user warning: Column 'status' in where clause is ambiguous query: SELECT COUNT(*) FROM node n LEFT JOIN i18n_node i18n ON n.nid = i18n.nid WHERE (i18n.language ='en' OR i18n.language ='' OR i18n.language IS NULL) AND ( type='sitenotes' AND status=1 ) in /includes/database.mysql.inc on line 172.
* user warning: Column 'status' in where clause is ambiguous query: SELECT n.nid FROM node n LEFT JOIN i18n_node i18n ON n.nid = i18n.nid WHERE (i18n.language ='en' OR i18n.language ='' OR i18n.language IS NULL) AND ( type='sitenotes' AND status=1 ) ORDER BY n.sticky DESC, n.created DESC LIMIT 0, 10 in /includes/database.mysql.inc on line 172.
Comments
#1
Well, this shouldn't be hard to fix, but if you upgrade to MySql 5 (which is needed for D7), you wouldn't see this.
#2
Committed to both -dev releases.
#3
Thanks for the update. The server running this site is running Mysql5. But since posting I had the same error message show up in another context which did not involve sitenotes. I'll keep looking!
#4
Automatically closed -- issue fixed for two weeks with no activity.