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

nancydru’s picture

nancydru
she/her/hers
Primary language English
Location Boston
commented

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.

nancydru’s picture

nancydru
she/her/hers
Primary language English
Location Boston
commented
Assigned: Unassigned » nancydru
Status: Active » Fixed

Committed to both -dev releases.

jmlavarenne’s picture

jmlavarenne commented

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!

Anonymous’s picture

Anonymous (not verified) commented
Status: Fixed » Closed (fixed)

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