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.

CommentFileSizeAuthor
update-weblinks.php_1.txt3.34 KBeveltman
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

Uccio’s picture

Good,

It works perfectly

Bye Uccio