Unknown column 'flag_content_users__flag_friend_message.fcid' in 'on clause' query

You should be using the latest release of Flag, 6.x-1.1

This is basically saying that there is no fcid column in your drupal_flag_friend_message table. Can you verify this?

Also, have you run update.php? And if so, what version did you start with?

I think I found the problem. Please try this patch.

Patch committed - please reopen if you still have this problem.

Hi - sorry to reopen but I'm also getting this error with 6.x-1.0-beta4. I tried applying the patch but I believe this code is already in beta 4.

I get the error when attempting to view "Awaiting Friend Approvals" or "Friend Requests", using the subtabs on the user profile page.

user warning: Unknown column 'flag_content_users__flag_friend_message.fcid' in 'on clause' query: SELECT DISTINCT(users.uid) AS uid, users.picture AS users_picture, users.name AS users_name, flag_content_users__flag_friend_message.message AS flag_content_users__flag_friend_message_message, flag_content.content_id AS flag_content_content_id, DATE_FORMAT(FROM_UNIXTIME(flag_friend.created), '%Y%m%d%H%i') AS flag_friend_created_minute FROM users users INNER JOIN flag_content flag_content_users ON users.uid = flag_content_users.content_id AND (flag_content_users.fid = 3 AND flag_content_users.uid = 1) LEFT JOIN flag_friend_message flag_content_users__flag_friend_message ON flag_content_users.fcid = flag_content_users__flag_friend_message.fcid LEFT JOIN flag_content flag_content ON users.uid = flag_content.content_id AND (flag_content.fid = 3 AND flag_content.uid = 1) LEFT JOIN flag_friend flag_friend ON users.uid = flag_friend.uid ORDER BY flag_friend_created_minute DESC in /sites/all/modules/views/includes/view.inc on line 731.

Can you tell me if there is an 'fcid' column in your 'flag_friend_message' table?

Haha I haven't the faintest idea. How would I find that out?

Have you cleared your cache tables? Have you overwritten these views (customized them)?

This was a change to Flag friend's view argument handler which those default views implement so they should be working properly, but making sure that the views cache is cleared would be the first step to troubleshooting.

Your error message suggests that it is still using the old query that was generated before the patch.

fix here: #420250: Flag D5->D6 Update Doesn't Add Auto-increment to flags.fid Column which I think was related to this. Please open if still having the problem after upgrading.

also I think might have been related: #420250: Flag D5->D6 Update Doesn't Add Auto-increment to flags.fid Column