Facebook Connect For 7.0.3 Changeset Bugs

I realize this is a premature bug report, but I thought I should submit it to make sure it doesn't make it to the 7.0.3 release.

Having installed the changeset I found a SQL error

ALTER TABLE `Profiles` ADD `FacebookProfile` VARCHAR(32) NOT NULL; 
ALTER TABLE `Profiles` ADD INDEX (`FacebookProfile`) ; 

`Name` = 'bx_facebook_connect_api_key', 
`kateg` = @iKategId, 
`desc`  = 'Facebook api key', 
`desc`  = 'Facebook api ID', 
`Type`  = 'digit', 
`VALUE` = '', 
… …  
`sys_options`  
SET 
`Name` = 'bx_facebook_connect_secret_key', 
`Name` = 'bx_facebook_connect_secret', 
`kateg` = @iKategId, 
`desc`  = 'Facebook secret key', 
`desc`  = 'Facebook secret', 
`Type`  = 'digit', 
`VALUE` = '', 

The line `kateg` = @iKategId,  - is missing single quotes

~ Also, when I applied the update the settings area disappeared from the admin area of the Facebook Connect module. This means there is no place to put the api and secret key.

~ Finally, even after going to the database and manually entering the api and secret keys, the module still threw an error and instructed me to configure the mod through the admin panel - which has no settings area to configure.

I downloaded the .zip file of the changes and replaced the earlier files with the modified versions. I did this 3 times to make sure I wasn't just missing something, but if I am please let me know what.

~TheGuyPC

Hello there no any of bugs, you'll need download and make fresh install of module!

Where do I get the full module instead of just the changed files then?

Thanks,

~PC

http://www.boonex.com/unity/forums/topic/Facebook-Connect-not-working-in-7-0-2.htm

Since you said I was incorrect about there being a database error, how would you suppose I just got this?

Installation of: Facebook connect Failed

INSERT INTO`sys_options`SET`Name` = 'bx_facebook_connect_api_key',`kateg` = @iKategId,`desc`  = 'Facebook api ID',`Type`  = 'digit',`VALUE` = '',`order_in_kateg` = 1

The old facebook_connect mod was uninstalled & I replaced the entire mod folder with the one from the SVN.

It doesn't flippin' work!

Becuase there was no remove api key statement in the unistall.sql in the facebook module.   just open the database and remove the api key you are trying to use  or leave it there and make a new api key at facebook.

And before you say there is here is the uninstall.sql.

  --
    -- Dumping data for table `sys_objects_auths`
    --

    DELETE FROM
        `sys_objects_auths`
    WHERE   
        `Title` = '_bx_facebook';
 
    --
    -- `sys_alerts_handlers` ;
    --

    SET @iHandlerId := (SELECT `id` FROM `sys_alerts_handlers`  WHERE `name`  =  'bx_facebook_connect');

    DELETE FROM
        `sys_alerts_handlers`
    WHERE
        `id`  = @iHandlerId;

    --
    -- `sys_alerts` ;
    --

    DELETE FROM
        `sys_alerts`
    WHERE
        `handler_id` =  @iHandlerId ;

    ALTER TABLE `Profiles`
        DROP `FacebookProfile`;

    --
    -- `sys_menu_admin`;
    --

    DELETE FROM
        `sys_menu_admin`
    WHERE
        `title` = '_bx_facebook';

    --
    -- `sys_options_cats` ;
    --

    SET @iKategId = (SELECT `id` FROM `sys_options_cats` WHERE `name` = 'Facebook connect' LIMIT 1);
    DELETE FROM `sys_options_cats` WHERE `id` = @iKategId;

    --
    -- `sys_options` ;
    --

    DELETE FROM `sys_options` WHERE `kateg` = @iKategId;

    --
    -- permalink
    --

    DELETE FROM
        `sys_permalinks`
    WHERE
        `standard`  = 'modules/?r=facebook_connect/';

    --
    -- settings
    --

    DELETE FROM
        `sys_options`
    WHERE
        `Name` = 'bx_facebook_connect_permalinks'
            AND
        `kateg` = 26;

I wasn't about to argue with you  ; )

Worked perfectly - thank you very much dolphin_jay!

It would be nice if the danged thing uninstalled/reinstalled properly in the first place, wouldn't it?

yes i suppose it would.  pretty sure there are other modules that leave junk behind on uninstall as well.  Personaly i cant stand that facebook mod more trouble then its worth.  If your gonna have a facebook login you might as well show my facebook comments, friends and content in a block someplace....