This is the error message:
Unknown column 'wl.nid' in 'on clause' query: SELECT DISTINCT n.nid, n.title, wl.*, wln.link_title, wln.weight FROM node n INNER JOIN weblinks wl ON n.nid=wl.nid INNER JOIN weblinks_node wln ON n.nid=wln.nid LEFT JOIN links_node ln ON wl.nid=ln.nid WHERE n.type='weblink' AND ln.nid IS NULL LIMIT 1000 in /var/www/wkvkano_nl/includes/database.mysql.inc on line 120.
Problem is ... weblinks does not have a nid column. weblinks_node does.
I changed the query to what I think it should be and then ran update-weblinks.php again. It seems to have worked fine, weblink nodes can be viewed (with link) now, but I'm not entirely sure of myself whether my correction is 100% perfect. I'm attaching it, hopefully it will be useful for someone. No guarantees.
Comment | File | Size | Author |
---|---|---|---|
update-weblinks.php_1.txt | 3.34 KB | eveltman |
Comments
Comment #1
Uccio CreditAttribution: Uccio commentedGood,
It works perfectly
Bye Uccio