1662 - possible error in ajax.php

[reporter]

Sync'ed up to svn tip, changeset 1662.

Getting a SQL error thrown when marking feed as read. May need a schema update.

Steps:

Go to a feed, click mark as read button

Expect results:

feed should be marked as read, goes to next unread feed

Can reproduce 100 percent of time

Host info:

Fedora Core 6, Apache 2.2.3, mysql 5.0.21, php 5.1.6

Actual results:

Error is thrown as displayed below:

Failed to execute the SQL query

select cid, count(*) from item where (unread & 1) and not (unread & 8) and not (i.unread & 4) group by cid

Error 1054: Unknown column 'i.unread' in 'where clause'

Do note that feed is actually marked as read (if go back in browser, the feed is no longer 'unread')

[reporter]

More info:

This occurs only if feed is contained within a folder, if marking the folder as read, the error does not occur.

[mbonetti]

Probably fixed in [1663]. Please confirm.

[reporter]

working now with 1665

was on the plane during the last couple of changesets...