I just upgraded to the latest version (16-Feb), got a couple of errors when returning back to the broken link list after fixing a bad link, and figured "oh, well, might as well clear the links to get a fresh start with this version."

Doing so generated a dozen or so of these errors:

user warning: Unknown column 'ln.nid' in 'where clause' query: SELECT url FROM linkchecker_links ll INNER JOIN linkchecker_boxes ln ON ll.lid = ln.lid WHERE ln.nid = 11 AND token IN ('6c2398e33465b628cccc4c904a165276','18a266ba4ef57a9316aef8f77588f41f','9d6db24c3e9e12e4df4cfbe313358d50','49264894f4e3cacf3cb29c043c31cdaa','e6d8cc21be2d23ba0b57fc2aadd65d2d','c04f856626b956a6c20916fa89a5a07d','55e8a408f7e759004a68bb51aab84a94','ef77c77527c2575ae658b5afae37d189','3d5f50bb479d367ac0baf8b3b0bd33c0','557b9820c4d564b3f8fb5e65a9d1431f','fce17bfd5a2094b73b6b2d9e86e3cab2','8b973ab0a72405425a4d7b1fb7d68d20','bbbdafcea95c9778612e86bdce460c0c','01385dc70fcdcbad3a150d3da12d4409','c7bc7884cced641d83196d3a34202a87','aa34a94ecaa440b9a6094ff1e835260f','042ede2bfd7b786485408900634e5ef0','728681de06291b4361c141a2252c35ca','f6bb2471e47d16ed43ec945e2e730bf2','d1b1c520c3fd47718a39d01ca15acc2c','2edbd081facdaec457ece62f3d04f20a','e291ecc08bf56ed2188d4490c00556ed','23e155b68f2bbd717ca8a29e95a6b431','cd2edb792cd75cf7c2e83d7485ff1c4c','d6780f41b06933c9d4ec3c5e4d4270fc','b233c9f128726e32a2552f57853b9c62','9c9adea3e12a5c05763a45927fd65d24','94fbc5ca59af2cb6e4467e14a9934db5','da2dcb6aca8b7bba8d0dd9987b06b4b6','115bdf556e74556d16e50ab734eca9d2','9c6825217866ed596e458692aad61121','a6c333b2a25e8bdc87e65969cf570218','5f3692839d2d663b24590a442e693ac8','1eb00e23957f4531095d73937a7bbbd4','a5444a82f5e5873d3b65bb0edf9453ec','0b845ad6288078a477782d26d254a9a2','95c3028af672f989d2b655d982ddb157','fdf900c0d8a15fb91d904bbcfb4a4e9f','921e9c58310afaef54ddd4de630419f0','6e0015843f10c0e7ed00d41b10434c03','a4a205ccdd35ad6369d5b705b36533a6','651b9cbba36c7cb5b7a1aeb7db520c4b','9e1b35359386bc875caa04f3e6d42fc8','486b96d2b82c84b97236d95bb494e865','bedbd820f02ba0e7686dff510a9c23ae','2bfeac7852cefc9ebeb2b6a8fc5e56f7','2645072b7ced7cfae0ebd014d04915f6','55c36ab0084c47cddc9b373e8f55a8fd','ddb5e2ed307c55fea4c8e560d8413880','68df44a7053ad47af19cdf727d0e837f','672514f0cf8418560d3f46ec8fb5d9e7','31b828b4b94580642b5180c03fb5e2ba','fed67d21cbc05aa94696f1136c6c63e6','2a7d619462758059586b40dd89d9ab04') in /home/publicdev/public_website/sites/all/modules/linkchecker/linkchecker.module on line 750.

All the updates ran properly when I upgraded to this latest version. Happy to provide more info for diagnosis.

Thanks,

TC

Comments

hass’s picture

hass commented
Title: User Warning on Clear Link Data » Wrong table aliases and column names for comments and boxes
Status: Active » Fixed

Copy and paste bug on my desk :-(. You can analyze only to add the missing links from boxes and comments only.

Status: Fixed » Closed (fixed)

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

leop’s picture

leop commented
Version: 6.x-2.x-dev » 6.x-2.0
Status: Closed (fixed) » Active

I think I stumbled on a similar error:

line 712 in linkchecker.module reads:

return db_query("DELETE FROM {linkchecker_comments} WHERE nid = %d ...

there is however no column nid in the linkchecker_comments table. I upgraded from 5.x-1.2. This produced no errors.

Version 6.x-2.x-dev also has this line. Maybe it should read:

return db_query("DELETE FROM {linkchecker_comments} WHERE cid = %d ...

or the upgrade from path to 6.x-2.0 does not work entirely correct.

hass’s picture

hass commented
Status: Active » Fixed

*Damn*. This slipped through my fingers... "nid" must be "cid". Fixed in CVS. Thank you!

Status: Fixed » Closed (fixed)

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