By emcher on

I installed the weblinks module, but kept getting this error on top of the home page:

user error: Table 'wscommun_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 = 2 AND n.type='weblink' AND n.status = 1 AND n.moderate = 0 ORDER BY n.title in /home/wscommun/public_html/drupal/includes/database.mysql.inc on line 66.

So I dropped the tables in the db, and deleted the weblinks module folder.

But I'm still getting the error above. How the heck can I get that to go away?

Comments

jt6919’s picture

jt6919 commented

before you deleted the folder, did you disable the module in the "Administer" -> "Modules" section and save?

now that you've deleted the folder, did 'weblinks' disappear from your modules admin page?

emcher’s picture

emcher commented

I believe I did disable before deleting the module folder. I also deleted a record that referenced the weblinks module in the system table.

That error message is being generated from the database.mysql.inc file in the includes folder. Where is it getting the info to even try that query?

adlitinc’s picture

adlitinc commented

link attach is the module that is causing the problems, I have had the same.

in the link attach module replace {weblink} for this {weblinks}, and you should be good with the weblink and link attach module

emcher’s picture

emcher commented

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, weblinks w, linkattach l WHERE n.nid = w.nid AND n.nid = l.lid AND l.nid = 2 AND n.type='weblink' AND n.status = 1 AND n.moderate = 0 ORDER BY n.title in /home/wscommun/public_html/drupal/includes/database.mysql.inc on line 66.

It only shows when I go to the home page....

Reinstalled, deleted, and now it's okay. Chalk it up as user errror.

adlitinc’s picture

adlitinc commented

but i've loaded the cvs module now and that seems to do the trick

emcher’s picture

emcher commented

Where do you get the CVS module?

adlitinc’s picture

adlitinc commented

you can get it here :

http://drupal.org/project/Modules/cvs

or

http://cvs.drupal.org/viewcvs/drupal/contributions/modules/linkattach/#d...

I use tortoisecvs to keep a copy of cvs drupal and cvs modules on my computer

Bèr Kessels’s picture

Bèr Kessels commented

Please focus your attention around that issue.
You can find the weblink table bug here.

---
if you dont like the choices being made for you, you should start making your own.
---
[Bèr Kessels | Drupal services www.webschuur.com]

emcher’s picture

emcher commented

I apologize in advance, but even after reading the 'weblink table' trhread, I still can't make it work.

Can't someone just put together a clear set of installation instructions?

Again, I apologize for being a novice about this in advance.