[SOLVED] SQL ERROR

Hello,

I've uninstalled JFBCONNECT from my site and now i can't edit any CB profiles because of this message:
moscomprofiler::store failed: Unknown column 'facebook_id' in 'field list' SQL=UPDATE `jos_comprofiler` SET `user_id`=63,`firstname`='',`middlename`='',`lastname`='',`hits`='833',`message_last_sent`='0000-00-00 00:00:00',`message_number_sent`='0',`avatar`='63_4ac1fdf372c7c.jpg',`avatarapproved`=1,`approved`=1,`confirmed`=1,`registeripaddr`='164.128.54.35',`cbactivation`='',`banned`='0',`acceptedterms`='0',`facebook_id`='',`lastupdatedate`='2009-09-29 14:30:43',`fbviewtype`='_UE_FB_VIEWTYPE_FLAT',`fbordering`='_UE_FB_ORDERING_OLDEST',`cb_gender`='joueur',`cb_datedenaissance`='1979-02-15',`cb_pgtotalitems`='1',`cb_pgtotalsize`='32858',`cb_pglastupdate`='2009-09-08 18:10:25' WHERE id='63'

Please help!!!!! <!-- s:cry: --><img src="{SMILIES_PATH}/icon_cry.gif" alt="" title="Crying or Very Sad" /><!-- s:cry: -->

You must have some other tweak than JFBConnect. I have both commubity builder and JFBConnect loaded on my site, and I see no facebook_id. I doubt that they put code to write to a field that was never added. Have you been adding plug-ins to your community builder?

About the only option I would see at this point is to start combing the files of Community builder for update statements of the comprofiler table. Make sure to look in the administrator folder where they have a controller file. You can replace these files alone to be the safest. If you want a quick fix, you may be alright copying all .php and .js files in /administrartor/components/com_profiler and /components/com_profiler files back into the directories from your original community builder zip file.

Your data is in the database, the .php and .js files will not erase data by simply restoring them to their original state, but you might break whatever it is that is trying to add a facebook_id.

Hello,

thank's for your help.
i've not installed any CB plugins but you're right i will try to erase my CB files with a backup.

Let's go...

Ok it was not JFBCONNECT but JCONNECTOR....

Here is the answer...
check your #__users table and delete facebook_id field from it. That's the only actual presense that may have left after jConnector was uninstalled.

Hi, I never had JConnector and still I got the facebook_id in my jos_users table, not sure how that got in there since I have a new joomla instalation.

Well, anyway, I deleted it and solved my problem

That is the importan thing!