After installing weblink 4.6 I got this error below on to drupal 4.61

user error: Table 'db_drpl1.weblink' doesn't exist
query: SELECT n.nid, n.title, n.teaser, n.status, n.moderate, w.weblink, w.click FROM node n, weblink w, linkattach l WHERE n.nid = w.nid AND n.nid = l.lid AND l.nid = 14 AND n.type='weblink' AND n.status = 1 AND n.moderate = 0 ORDER BY n.title in /home/drupal/public_html/drupal/includes/database.mysql.inc on line 66.

- something i noticed that the error looking for 'weblink' table on the database but [weblink.mysql] installed 'weblinks' table...is there a typo mistake there?

CommentFileSizeAuthor
#6 linkattach.module3.46 KBNaX

Comments

Bèr Kessels’s picture

Bèr Kessels commented

Did you run the upgrade scripts?

ica’s picture

ica commented

Yes I have used update-weblink.php as instructed first nothing happened (blank screen) and tried again i got blank screen and the message below
________________________________
query: SELECT * FROM weblink
error:
_________________________

on the site i get those again
user error: Unknown column 'w.weblink' in 'field list'
query: SELECT n.nid, n.title, n.teaser, n.status, n.moderate, w.weblink, w.click FROM node n, weblink w, linkattach l WHERE n.nid = w.nid AND n.nid

How can i insert missing n.title, n.teaser, n.status, n.moderate, w.weblink, w.click tables.. via mysql? how? any ideas?
thanks

ica’s picture

ica commented

I run again the update script I got this message
--------
query: SELECT * FROM weblink
error:Table 'simplex_drpl1.weblink' doesn't exist

user error: Table 'simplex_drpl1.weblink' doesn't exist
query: SELECT * FROM weblink in /home/simplex/public_html/dp/includes/database.mysql.inc on line 66.

-----
point is on my sql i can see the table is called 'weblinks' but the script is looking for 'weblink' table to update which is not there

somewhere therse is missing typo or confusion beteen 'weblinks' and 'wblink' table

any ideas?

ica’s picture

ica commented

sorry the last line has some mistakes

I correct here
-------
point is on my sql i can see the table is called 'weblinks' but the script is looking for 'weblink' table to update which is not there

somewhere there is missing typo or confusion between 'weblinks' and 'weblink' table.. I guess

any ideas?

Bèr Kessels’s picture

Bèr Kessels commented

There is no confusion.

it *was* called weblink
it *is* called weblinks

in the *new* system you need both weblinks as weblinks_node

your upgrade failed. So:

Put your backup back
run weblink.mysql
run the upgrade.

You must have forgotten to run the sql file.

NaX’s picture

NaX commented
StatusFileSize
new linkattach.module3.46 KB

I had the same problem when I tried the weblinks module. But I found the problem to be with the link attach module. In the linkattach.module file the SQL is referring to the wrong table and columns. I don’t know if the changes are correct. All I did ways make the SQL not give a error.

Changes:

{weblink} to {weblinks}
w.weblink to w.url
w.nid to w.lid
w.click to w.clicks

On line 15 and 65.

I don’t know how this module works so my changes might be wrong, like I said all I did was make the SQL not give a error.

trailerparkopera’s picture

trailerparkopera commented

I can verify that the fix that NaX proposes does the trick. The problem is in the linkattach module, lines 15 and 65.

NaX’s picture

NaX commented

The linkattach module does not seem to be added to the issues tracking system. I have been the project page and I am unable to submit a bug or post a patch to this problem.

Some one with CVS access needs to patch or update the linkattach module. And when they do they should close this issue(cleanup)

NaX’s picture

NaX commented
Status: Active » Closed (fixed)

I have checked the latest CVS version of the linkattach module and it has been updated and is working fine with the latest version of the weblinks module.

Problem solved, download the latest version of the linkattach module from here: http://cvs.drupal.org/viewcvs/drupal/contributions/modules/linkattach/