Got this when trying to add a link. The links apparently get added, however, as they showed up on the main page. I tried adding it by only using the title and link fields.

user error: Unknown column 'isbn' in 'field list'
query: INSERT INTO weblink (nid, weblink, monitor, refresh, threshold, feed, spider_site, spider_url, isbn, author, publisher, translator, dateofissue, rating) VALUES ('4', 'http://www.google.com', '0', '0', '0', '', '0', '', '', '', '', '', '', '0') in /home/ikon/public_html/includes/database.mysql.inc on line 66.

warning: Cannot modify header information - headers already sent by (output started at /home/ikon/public_html/includes/common.inc:384) in /home/ikon/public_html/includes/common.inc on line 192.

Comments

Marandb’s picture

I have recieved the same error.

Any ideas?

Thanks.

Bèr Kessels’s picture

ISBN? do you have any other modules then weblinks installed. Can you please give me a list here?

Marandb’s picture

Title: User Error? » Modules Installed

I have been testing alot of stuff out lately... Here is the list.

address
album
article
attachment
auction
bbcode
cart
comment
contact
dba
file
filemanager
filter
flexinode
folksonomy
forms
forum
front_page
help
image
live_discussions
members
menu
node
page
parcel
payment
paypal
poll
product
profile
search
shipping
smileys
smileys
store
stores
story
submanage
system
tangible
taxonomy
theme_editor
tinymce
tracker
urlfilter
user
watchdog
weblink

Thanks,
Marand B.

Bèr Kessels’s picture

wow! thats an enourmous alount. This way i cannot help you. sorry. you must clean up you DB, chances aer very big one of your other modules changed the database tables.

Reginleif’s picture

I installed it on a clean system. No other modules other than the ones that came with the 4.6.0 install.

pyromanfo’s picture

No I'm getting it too, the weblink code is trying to insert fields into the DB that their DB spec doesn't allow. I'm going back to the 4.5.0 module for now

jhriggs’s picture

I have seen this too and can confirm this. In addition to applying the weblink.mysql file, you have to apply both update_weblink*.mysql files to your database. There are some fields that are added by the updates that are not in weblink.mysql. Then it will work. I am using it successfully with 4.6.

<rant>
To be honest, this module is a complete mess right now, so I hope that the rewrite is making good progress. (Bèr???) Since no one has really "owned" this module for some time, many people have applied arbitrary patches to it to fit their specific needs. It has become a free-for-all. What should be a module for simply keeping a list of links (URLs) has somehow taken on lots of book attributes and other things that should not be in there: author, ISBN, translator, publisher, ratings, etc. Much of this was added by user tma0, and I don't know how much (if any) discussion was done before these changes were committed. What's more, the documentation was not updated, so only by trial and error would someone realize that they need to run the update sql files.
</rant>

I beg you to get your updated version out, Bèr, even if it is not quite ready for prime time yet. Or if it's really not ready for public consumption, maybe we should just do a major clean up and repair of what we have for an interim 4.6 solution?

TDobes’s picture

I completely agree with jhriggs. The module is a total disaster as-is and suffers from serious feature bloat. We all anxiously await the release of the more modular new version.

Bèr Kessels’s picture

Title: Modules Installed » Weblinks database errors

I am completely flabbergasted. I have been monitoring this ,module, as maintainer for quite a while. I dd not put in any more functions and features, nor did I commit any patches other than fixes to make it work on 4.5. Since I no longer use it myself, i merely kept an eye on patches. mostly to refuse more and new features to go in....

Someone committed changes without letting me know it, even without my permission. There is ABSOLUTELY no way i would have ever allowed ISBN and such crap to go in.

Someone is going to get so,e angry mails from, me soon. In the mean time? i will roll back the changes ASAP (this weekend) so that at the least it works for 4.6 again. (I tested it, and it worked other then for that funny bug that has a bounty of 30 Euro on it)

O, and please note that you should not change the title. You will then change the title of the complete thread
Ber

Bèr Kessels’s picture

postoponing this.
For one, all you peolpe reporting this bug: the module has NOT been released for 4.6 yet. There is a reason for that.... ;)
Secondly someone has been adding features without my agreement. I will first have to fix all that, before it can be released for 4.6
HEAD is NOT ready for poduction sites. don't use it!

Bèr Kessels’s picture

Fixed in HEaD. NOTE that head might still change. Upgrading to HEAD is on your own risk. It does work on 4.6 though!

Anonymous’s picture