Resolution appears to be in the cvs version of the linkattach module [#34765]

I get this error weblink.module 4.6
any idea? how can it fixed
wierd thing is i still get the error when i deleted the module from the server + i dropped the weblink database tables and still i can not get rid of error below... it's a bit pain in the neck -literally- after spending hours try to find out something to solve it - so far no success
-------------------------------------------------------
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 = 8 AND n.type='weblink' AND n.status = 1 AND n.moderate = 0 ORDER BY n.title in /home/public_html/dp/includes/database.mysql.inc on line 66.

Comments

Comment #1

singularo

Adelaide, AUS

CreditAttribution: singularo commented 21 October 2005 at 11:37

Well you're getting the error because the table doesn't exist, and its looking for the weblink details for nid 8.

Is it possible there is a block with the top links enabled still, or that the module itself is still enabled?

Recreate the weblink table with no contents to let you into administration again, then you can check.

Hope that helps

Comment #2

ica CreditAttribution: ica commented 21 October 2005 at 12:01

thanks for your post but,
I make it clear again after your help,
-weblink.module is activated
-tables are inserted as below so what else needs to be done? I still get the error above

-------------------------
Your SQL query has been executed successfully
SQL query:
-- $Id: weblink.mysql,v 1.6 2005/05/08 15:22:24 ber Exp $
-- WARNING! This is a preliminary version for a rewritten "weblinks"
-- module. DO NOT apply this against an existing Drupal installation,
-- or it will ERASE your weblinks table.
DROP TABLE IF EXISTS weblinks;# MySQL returned an empty result set (i.e. zero rows).
-- lid, the link ID, is linked to the sequence weblinks_lid
CREATE TABLE weblinks(
lid INT( 10 ) UNSIGNED NOT NULL DEFAULT '0',
url_md5 CHAR( 32 ) NOT NULL ,
url TEXT NOT NULL DEFAULT '',
clicks INT( 10 ) UNSIGNED NOT NULL DEFAULT '0',
last_click_time INT( 11 ) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY ( lid ) ,
UNIQUE INDEX url_ix( url_md5 ) ,
UNIQUE INDEX stale_ix( last_click_time, lid ) ,
INDEX short_url_ix( url( 20 ) )
);# MySQL returned an empty result set (i.e. zero rows).
DROP TABLE IF EXISTS weblinks_node;# MySQL returned an empty result set (i.e. zero rows).
-- lid is a foreign key to weblinks
CREATE TABLE weblinks_node(
lid INT( 10 ) UNSIGNED NOT NULL DEFAULT '0',
nid INT( 10 ) UNSIGNED NOT NULL DEFAULT '0',
weight INT( 4 ) NOT NULL DEFAULT '0',
link_title VARCHAR( 255 ) NOT NULL DEFAULT '',
PRIMARY KEY ( lid, nid ) ,
UNIQUE INDEX node_link_ix( nid, lid, weight )
);# MySQL returned an empty result set (i.e. zero rows).
---------------------------------

Comment #3

singularo

Adelaide, AUS

CreditAttribution: singularo commented 21 October 2005 at 13:03

Ahhh. I missed it the first time, but the word "linkattach" gives it away.
You need to disable the linkattach module, which depends on weblink.
Then you should be able to disable the modules and remove the weblink & linkattach tables.

Comment #4

ica CreditAttribution: ica commented 21 October 2005 at 13:35

YES! i disabled the linkattached module and weblink module does not give the error -so far
weblink module still active
I think this conflict issue should be on the ReadMe doc and the top of the
http://drupal.org/project/weblink

Thanks singularo!!

Comment #5

hintbw CreditAttribution: hintbw commented 15 November 2005 at 22:11

Title:	User error: Table 'db_drpl1.weblink' doesn't exist? a pain in the neck	» Resolution appears to be in the cvs version of the linkattach module
Assigned:	Unassigned	» hintbw

I was having the same problem (and there are other issues open about this problem). The error mentioned above would only show on the home page of my drupal site, when I was not logged in. The fix for me, and it seems likely for others experiencing this same error, is related to a patch in the linkattach module.

Here is how to fix the issue:

1. Get the latest version of the linkattach module in the cvs (it will be version 1.2 of module - committed to CVS in July)

2. Disable the linkattach module in your Drupal site

3. Replace the "old" linkattach module with the one you just downloaded from the CVS

4. Re-enable the linkattach module

5. The error should now be gone