Just upgraded to Beta 5 and I'm getting the following SQL error, and yes I did run update.php :

user warning: Unknown column 'content' in 'field list' query: select cid, match(content) against('Sources: Jennifer Aniston & John Mayer Split\n Dating since April, friends of the couple say the singer and actress have parted ways' ) as score from memetracker_content WHERE timestamp > 1218415088 AND cid in ('1','2','3','4','5','6','7','8','9') in /var/www/drupal/sites/all/modules/contrib/machinelearningapi/machine_learning_api.inc on line 210.

I also tried it on a fresh install of drupal and got the same error. I checked the memetracker_content table and of course there's no content column but phpMyAdmin also gave me the following warning that I wasn't sure about:

"The following indexes appear to be equal and one of them should be removed: PRIMARY, memetracker_content_cid"

Comments

kyle_mathews’s picture

kyle_mathews commented

I'm pretty sure you haven't upgraded machinelearningapi along with memetracker. The content field was moved to a different table (memetracker_search_N) but the query you're failing on is from an older version of the machinelearningapi module.

SeanBannister’s picture

SeanBannister commented
Status: Active » Closed (fixed)

Oh I feel stupid. Thanks for that :)