Something has gone very wrong with leech and it has become unable to add new feeds. I had things working fine before with the link to the first v5 zip file. Since upgrading to the cvs these problems have appeared. I have spent hours trying to solve this including attempting to remove leech by deleting the db tables + deleting the db variables but after that leech refused to install the tables and variables from either version. I restored my db back to just before I did that. I have tried creating a new template which still has no effect, and I am completely stuck.

The new feature 'adadptive' was introduced between these versions, could that be the problem? I have attached what I think are a list of all the variables and settings from the varibal table, if you could have a look and see if there is anything out of place that would be helpful.

CommentFileSizeAuthor
leech_variables.txt2.1 KBAstralP

Comments

alex_b’s picture

alex_b commented

Hi,

You caught us working. You have to upgrade the DB manually when you _upgrade_ to the latest dev version of leech from a previous one (like 1.2). The new adaptive leeching feature, that throttles the frequency of visits to feeds by the feeds frequency of updates requires some new fields in the database:

ALTER TABLE leech ADD COLUMN `adaptive` tinyint default '0';
ALTER TABLE leech ADD COLUMN  `news_last_arrived` int(10) default'0';
ALTER TABLE leech ADD COLUMN `avg_btw_news` float default '0';
ALTER TABLE leech ADD COLUMN `deviation` float default '0';
ALTER TABLE leech ADD COLUMN `num_of_tests` int(10) default '0';

Alex

AstralP’s picture

AstralP commented

I've just discovered that the extra columns needed for adaptive are not created when updating, here is the mysql code to update them:

ALTER TABLE leech 
ADD adaptive tinyint default 0,
ADD news_last_arrived int(10) default 0,
ADD avg_btw_news float default 0,
ADD deviation float default 0,
ADD num_of_tests int(10) default 0;

still not solved the problem so far though...

AstralP’s picture

AstralP commented

aha :)

AstralP’s picture

AstralP commented

After creating a new feed, the node now does appear on the leech page (though the additional options still don't appear when editing/creating). When trying to leech watchdog reports:

Missing argument 2 for variable_get() in
....../includes/bootstrap.inc

I'll continue trying to fathom this in a few hours time.

AstralP’s picture

AstralP commented
Status: Active » Closed (fixed)

I failed to resolve this problem, something went very wrong with my installation and drupal stopped responding to installing modules + their variables so decided to start with a fresh installation. The additional options are now appearing.

The 'Missing argument 2 for variable_get()' error was unrelated to Leech.

worldcoast’s picture

worldcoast commented

This is not a problem. Basically what was happening is the URL to the rss feed you were entering couldn't be resolved. The Additional options only show up when the feed resolves and leech can read data from it. This is done after you paste in the url to the feed.

toologic’s picture

toologic commented

To worldcoast
The Additional options only show up when the feed resolves and leech can read data from it. This is done after you paste in the url to the feed.

Please see my post in http://drupal.org/node/123062 #5.
From localhost my feed url can resolved, but from workserver - can not. What factors may affected on this problem. (now on localhost and hostserver all software is equal.