Error after upgrade from 1.10 to 3.13

apodic - October 29, 2008 - 19:26
Project:Localizer
Version:5.x-3.9
Component:Miscellaneous
Category:bug report
Priority:normal
Assigned:Unassigned
Status:active
Description

After upgrade I am getting a following error:
user warning: Column 'weight' in where clause is ambiguous query: SELECT DISTINCT(n.nid) FROM node n LEFT JOIN helptip ht ON ht.nid = n.nid LEFT JOIN helptip_user_data ht_hidden ON ht_hidden.uid=1 AND ht_hidden.nid=n.nid AND ht_hidden.relation='hidden' LEFT JOIN localizernode loc ON loc.nid=n.nid LEFT JOIN( SELECT 0 AS weight, CAST('bs' AS CHAR(10)) AS language UNION SELECT -100 AS weight, CAST('en' AS CHAR(10)) AS language ) lanw ON lanw.language=loc.language LEFT JOIN (select pid, MIN(weight) AS minweight from localizernode loc2 LEFT JOIN ( SELECT 0 AS weight, CAST('bs' AS CHAR(10)) AS language UNION SELECT -100 AS weight, CAST('en' AS CHAR(10)) AS language ) lanw2 on lanw2.language=loc2.language group by pid) loc1 ON loc.pid=loc1.pid WHERE (lanw.weight=loc1.minweight) AND ( n.status = 1 AND ht_hidden.relation IS NULL AND ('admin/user/access' LIKE ht.path) AND weight >= -10 AND weight <= 10 ) ORDER BY ht.weight, RAND() LIMIT 1 in C:\xampp\htdocs\eko\includes\database.mysql.inc on line 172.

 
 

Drupal is a registered trademark of Dries Buytaert.