Errors and request [#119209]

I just installed your package and when I tried to create a link I got a few errors. At the top of the page I get:

Warning: Unknown column 'weight' in 'field list' query: SELECT url, weight FROM weblinks WHERE nid = 21 in /Users/david/Sites/drupal5/includes/database.mysql.inc on line 172

And inline on the page I get:

warning: Illegal offset type in /Users/david/Sites/drupal5/modules/taxonomy/taxonomy.module on line 1150.
warning: Illegal offset type in /Users/david/Sites/drupal5/modules/taxonomy/taxonomy.module on line 1151.
warning: Illegal offset type in /Users/david/Sites/drupal5/modules/taxonomy/taxonomy.module on line 1154.
user warning: Unknown column 'weight' in 'field list' query: SELECT url, weight FROM weblinks WHERE nid = 21 in /Users/david/Sites/drupal5/includes/database.mysql.inc on line 172.

The node seems to be created but has the same error on it as at the top of the page. Also, the menu item which I'm guessing is supposed to be 'Web Links' is just empty, and the link I created doesn't show up on the 'weblinks' page.

Comments

Comment #1

tknospdr commented 15 February 2007 at 00:46

PS - I meant to give you a link to my test site, here it is.

http://www.technospider.com/~david/drupal5/?q=node/21

Comment #2

ideaoforder commented 15 February 2007 at 20:25

I just posted an updated version--5.x.1.3. Give that a whirl and lemme know if it performs any better.

Cheers.

Comment #3

tknospdr commented 16 February 2007 at 12:38

I found ver 1.4 and there were no changes, I even forced the update script to update Web Links because it didn't automatically show any updates needed.

Thanks,
David
http://www.FloridaPets.org

Comment #4

ideaoforder commented 16 February 2007 at 15:38

Hey David,

The "offensive code" that I excised in 5.x.1.3 actually was nec. for editing weblinks, and thus was put back in. Perhaps that's why there don't appear to be changes. Can you post a list of all the non-core modules you're using? I'm using a pretty stripped down system so perhaps there's a conflict with another modules. Also, have you tried other themes? It looks like you're just using the default theme modified a bit, so I don't think that's the problem. But I'd like to know for sure that it's not a theming issue.

The last thing is that it seems like there is no "weight" column in your DB table. Do you have access (via phpMyAdmin or comman line) to your database?

Otherwise, can you try this PHP code in a test page:

<?php
$result = db_query("SHOW COLUMNS FROM {weblinks}");
if (!$result) {
   echo 'Could not run query: ' . mysql_error();
   exit;
}
if (mysql_num_rows($result) > 0) {
   while ($row = mysql_fetch_assoc($result)) {
       print_r($row);
   }
}
?>

Then post the results back here?

Thanks!

Comment #5

tknospdr commented 16 February 2007 at 23:45

Non-core mods:

CCK
LM_PayPal
Banner
Comment Subjects
Flatforum
Gallery
Google Sitemap
Invite
Meta Tags
PathAuto
Pirate Filter
Sitemap
User Badges
Userpoints
Views
IE Destroyer

Changing themes didn't affect the problem. And I get this as output to your code snippet, which I don't think is right:

0) { while ($row = mysql_fetch_assoc($result)) { print_r($row); } } ?>

Comment #6

ideaoforder commented 19 February 2007 at 20:35

I think maybe the PHP filter wasn't enabled for that test page. But another user who is having a similar problem didn't seem to have database problems, so it's likely something else anyway.

I'm a bit stumped here. I will have to create a fresh install on another test site using most (I don't think I'll install gallery--too much of a pain) of your modules to try to see what's wrong. That'll take a little time though.

Otherwise, you can also try a clean test install with no non-core modules and no new taxonomy terms. If the problem persists then, I can't imagine what the issue would be. That may be a lot of work for one measly little module though. Sorry this is such a pain!

Comment #7

tknospdr commented 19 February 2007 at 23:55

Thanks for the help. I actually am using your mod as a second place replacement. What I'm using on my production site is the linksdb mod and it does exactly what I want. People can suggest links that don't go live until I review them and I just really like the way it works.
You know, the dev for that mod seems to have abandoned it. Would you be interested in trying to get it working under Drupal 5? I'd be super grateful!

Thanks,
David
http://www.FloridaPets.org

Comment #8

ideaoforder commented 27 February 2007 at 17:42

Ha! No way I can take on another module right now. Weblinks can be configured to put links in moderation too. I think that's standard Drupal setup stuff--under content you can set what the default publication status is.

Sorry I've not been able to isolate what's not working with your setup.

Cheers.