user warning: Unknown column 'news_last_arrived' in 'field list' query: INSERT INTO leech (nid, url, refresh, news_last_arrived, adaptive) VALUES (337, 'http://mjroseblog.typepad.com/buzz_balls_hype/rss.xml', 21600, 1173148294, 1) in C:\xampp\htdocs\thrillus5\includes\database.mysql.inc on line 172.

Comments

aron novak’s picture

aron novak
Primary language Hungarian
Location Hungary, Budapest
commented
Assigned: Unassigned » aron novak

Did you upgrade the leech module from an older version without creating the tables again? If yes, please re-create the tables according to the newest leech.install.
If the case is different, please give me the output of the following SQL statement:
DESC leech;
Yes, we should handle properly this situation with this: http://api.drupal.org/api/5/function/hook_update_N . The above instructions are just a simple workaround.

jt6919’s picture

jt6919 commented

gotta say - I've had the same kind of problem a bunch of times. Used the old leech....drupal 4.7x, then upgraded to 5.1 and 5.x-1.6 version of leech. adding the modules or running update.php does NOT update the tables at all. If fact, leech won't even appear in the list of modules available for upgrade or not when running update.php.

In every case, I ended up having to drop all 4 leech tables and strip out the SQL from the install file and go into phpMyAdmin in the database and create them tables using the SQL queries by hand. Then I get the tables created fine, and I can create a new leech item. So I do, and after creation I go to "leech" new items and it tries to....then on the confirmation page it says xx minutes until next run, but there is no link to view items. I check content and there are no new items. I go to the main page and nothing has been promoted. I go back to admin and get 500 server error. Back to main page - works fine, but all admin pages now give 500 server error.

This is quite the mess...