when I enable flag friend module,there is an error message that shows below:
user warning: Unknown column 'fc.fcid' in 'on clause' query: SELECT fc.*, ffm.message FROM flag_content fc LEFT JOIN flag_friend_message ffm ON ffm.fcid = fc.fcid WHERE content_type = '' AND content_id = 1 in /var/www/5.10/includes/database.mysql.inc on line 172.

and I can not find the column fcid on table flag_content,only exsits fid.

Comments

sirkitree’s picture

sirkitree commented
Category: bug » support

Sorry, I thought that the fcid column was added between beta5 and 6. It turns out however that it is only added to the development snapshot. I'll update the requirements and try to get them to push another beta with the two main features flag friend requires which are the following:

#160519: Allow admin to select Ajax or non-ajax behaviour per Bookmark type
#328745: Primary key on flag_content table

The next is not required, but flag_friend DOES require a flag named 'friend'. The following patch makes this easier for you.
#330141: Allow modules to expose default flags

sirkitree’s picture

sirkitree commented
Title: is this a bug? » Flag Friend Requirements
sirkitree’s picture

sirkitree commented
Component: Code » Documentation

Note that this also applies to 6.x-dev

benjaminlhaas’s picture

benjaminlhaas commented

I downloaded and installed Flag Friend today, and I got the same "Unknown column" warning message. Any word on an update going into the stable version?

Thanks,
Ben

sirkitree’s picture

sirkitree commented

#4, do you have the latest 5.x-dev release of Flag module installed?

benjaminlhaas’s picture

benjaminlhaas commented

#5, nope, I tried version 5.x-1.1. Do you recommend trying 5.x-1.x-dev instead? I've generally been averse to using dev versions that are going to go into production sites...what do you think?

Anonymous’s picture

Anonymous (not verified) commented

Just installed it for 6 and same kind of message.. any news ?

user warning: Unknown column 'fc.fcid' in 'on clause' query: SELECT fc.*, ffm.message FROM flag_content fc LEFT JOIN flag_friend_message ffm ON ffm.fcid = fc.fcid WHERE fc.fid = 0 AND fc.content_type = '' AND fc.content_id = 1952 in XXX/modules/contrib/flag_friend/flag_friend.module on line 128.

sirkitree’s picture

sirkitree commented

for both 5.x and 6.x you MUST have the latest -dev release of Flag module, as stated in my first reply.

krobi’s picture

krobi commented

i have just installed the newest dev version of flag and flag friends, everything seemes to work good but how can i add a friend? i dont see any button for that?

i use drupal 6.9

sirkitree’s picture

sirkitree commented

You should see the link on the user's profile page.

If you edit the actual friend flag, you will see towards the bottom a setting for Display Options with a check box "Display link on user profile page". If that is still checked (should be by default) you should see the link on any user page. That is, if you haven't themed it to not do so.

krobi’s picture

krobi commented
Version: 5.x-1.1 » 6.x-1.x-dev

hm i have checked my settings, on my local testserver and on my web-testserver. and i dont get a "add friend" link anywhere but i dont get any warnings or errors - i dont understand this.

i have checked the "display link on user profile page"

when i go to testdrupal/user/3/friends
all i see is "flagged", "pending" and on my web-testserver i also see "friends" - thats under the first two things.

edit
maybe a interesting info i use the Advanced Profile Kit

krobi’s picture

krobi commented

hello

no answer? i would like to usw flag friends but i dont know why there is no add friends button and i dont know what i do wrong - i can give the dev access to my testsite so he can look at it himself.

sirkitree’s picture

sirkitree commented

Has not been integrated with Advanced profile... see #335912: Integration with Advanced Forum and Advanced Profile Kit

kaay’s picture

kaay commented
Title: Flag Friend Requirements » No Add Friend Button.......

I have installed flag friend module. I can see friends tab in the profile but can't find a "add friend" button anywhere in the profile page. if i click on friends tab i see three butts. "view all firends" "awaiting friends approvals" and "Friend request" infact I am also using Advanced Profile Kit my question is can i create a add and delete friends buttons in the side menu (navigation) if yes then please tell me how this task is possible. thanks

sirkitree’s picture

sirkitree commented
Status: Active » Closed (duplicate)

read #13

basically it is not been done yet - #366844: Flag friend integration with Author Pane

michaeldrupal’s picture

michaeldrupal commented
Assigned: Unassigned » michaeldrupal
Priority: Normal » Critical

Hi sirkitree,

I have same issue that button cannot be shown. I am using content profile and I create a panel for user profile. Is there any possibility to creat a button link? Appreciate any advice!!

sirkitree’s picture

sirkitree commented
Assigned: michaeldrupal » Unassigned
Priority: Critical » Normal
Status: Closed (duplicate) » Closed (fixed)

Please do not mark things critical. They are reserved for issue where there is something that absolutely breaks the module making it unusable. Also, only assign things to yourself if you plan on fixing it yourself.

This issue is marked duplicate as it is a feature that is added by the ticket that is referenced in #15 where this issue was marked as a duplicate. This means that you should read the issue that is linked within that comment.

Now that some basic etiquette has been explained, I'll let you know that I have not used content profile and it would be nice is you could open up a separate ticket there and maybe even try to get someone who frequents the issue queue for that module to help you out.

I'll be happy to review any patches that need to be made to flag_friend as a result.

This issue has been badly mangled - closing. Please open another one for your request.