By mbravo@yoshinkan.spb.ru on

I have upgraded a 4.3.2 installation to 4.4.1 ; upgrade went relatively smoothly. However, about in 24 hours after the upgrade, I started getting messages from the cron execution, like this:

user error: Unknown column 'timestamp' in 'where clause'
query: SELECT * FROM feed WHERE timestamp + refresh < 1085378403 in /home/mbravo/www/yoshinkan.spb.ru/includes/database.mysql.inc on line 97.

When I checked the sources to aggregator.module and compared them with my database structure, sure enough, there were differences. There were no fields like timestamp, or author in the "feed" table. I checked database/mysql sources, and there were no such fields in that table either. At the same time, the feeds I have defined for syndication seem to be updating.

What am I missing with this error, and how do I fix it correctly?

Thank you ever so much for useful advice.

--
/\/\ike

Comments

mbravo@yoshinkan.spb.ru’s picture

mbravo@yoshinkan.spb.ru commented

After failing to get an answer here, I tried to read between the lines in other postings here that related to the aggregator.module ; I then decided, that having both import.module and aggregator.module enabled after upgrade from 4.3.2 to 4.4.1 looks wrong. I then disabled import.module, and, apparently, that was it.

I would suggest including, at the very least, a warning into upgrade instructions, or, better yet, allow the upgrade script to turn off import module when enabling aggregator.

Lineman-at-lineman.net’s picture

Lineman-at-lineman.net commented

Thanks a ton! I had the same problem.

I was also getting two blocks created for each feed and this apparently fixed it.