Facebook Connect Integration

:unsure:
After install it i get this

**Forbidden

You don't have permission to access /facebook/ on this server.**

i have changed the permissions on the folder but nothing please help....

Hey guys... any responses from the module author would be really awesome! :clap:

To get rid of 'COWOA_account' error, you have to make sure that the COWOA_account column exists in your zencart customers table in your zencart sql database. I got that far.... but this is still a fail for me so far because once I click the facebook connect "OK" granting my new app permissions, the module then loads an empty (ie no html) page where it should either load some finishing section for the user to click to continue logging in.... I'm not sure what it's supposed to load b/c it's not working but whatever it is, it's not doing it (see my original longer up-all-night w/ too much caffeine post). :lamo:

Basically, from what I can tell, the facebook.php module script is NOT getting the $_POST (or) the $_SESSION variables it needs to actually finish the sign up process correctly via the internal execution path of the various scripts that are getting called and getting data passed into them. :blink: I wish I was more familiar with zen cart to know where to look right away and just fix this but after a couple hours of perusal through files with the occasional google search....

Anyways I've not had a chance to finish looking at how to fix this since I spent a couple more hours on it that day. But really really want this module installed!!! It just started to suck too much of my time and I need to get other things done.

As for the COWOA error, I was able to get past it by reinstalling the SQL commands via admin "tools->install sql patches" but, like I said, my install is not fully operational yet, so keep that in mind when you run this.

Also MAKE SURE TO BACKUP YOUR SQL DATABASE by saving a full backup via phpMyAdmin or whatever other sql database tool you use (disclaimer) -- I grabbed this sql from the install for the easy signup module, which I had installed, so patching this back over it by just copy/paste/ and hitting the "send" button did the trick to get past the first error...

ALTER TABLE customers ADD COWOA_account tinyint(1) NOT NULL default 0;
ALTER TABLE orders ADD COWOA_order tinyint(1) NOT NULL default 0;
INSERT INTO query_builder ( query_id , query_category , query_name , query_description , query_string ) VALUES ( '', 'email,newsletters', 'Permanent Account Holders Only', 'Send email only to permanent account holders ', 'select customers_email_address, customers_firstname, customers_lastname from TABLE_CUSTOMERS where COWOA_account != 1 order by customers_lastname, customers_firstname, customers_email_address');

Ok. Has anyone else gotten this module installed successfully -- or can any one send out some advice or point me in the direction of which zen cart php files I should look at to try and fix this myself?

Basically I just can't find which scripts are calling which and why the $_POST variable would have no data in it.

Need help... please... pretty please.... :blush: this is a really great module to help incentivize people to join the site. Thanks...

...Bump.... anyone? Am I missing something obvious?

Thanks.

oh ...uh... I think it might be the SSL settings on my server, this is a new set up I'm still configuring -- does that ring any bells w/ anyone?

Nope, take that back. SSL is all set up, had that done a many days back.

New update.

Just quadruple checked my json which is true, and i do have installed... good so far...

...but found the obvious problem, why I'm losing the session data, haha. I was diving in to debug the meat of the php code when it's right there in the tpl_ <?php > javascript html code, getting NULL back from json encode on $session. Eh? Will look into that right now, shouldn't that be $_SESSION? Hmm, will report back in a few.

  window.fbAsyncInit = function() {
    FB.init({
      appId   : '#confidential#',
      session : null, // don't refetch the session when PHP already has it
      status  : true, // check login status
      cookie  : true, // enable cookies to allow the server to access the session
      xfbml   : true // parse XFBML
    });

Notice the 'null' that is getting suck into the session variable

Ok. So I solved it. Had nothing to do with $session, this is a facebook api thing, which I realized pretty quickly after looking at it for five more seconds. Finally had another few minutes to look at this last night and solved it.

This is a case of me being old at php & new at zen cart. But, I think others could have the same problem, even though it's partially an id 10 T error on my part.

The problem was, that in the zip file attached, there are two things that, if not done correctly, will cause a failure at installation.

1. The COWOA_account ALTER line appears to cause problems after installation, requiring the patch I previously posted.

2. The "tpl_*" files in the .zip attached to this thread, are in the wrong directory to just "copy the files to your server" as the installation instructions for the module state. If I was more of a seasoned zenner I would have picked up on this immediately, but, as it is, it took me tracing through almost every single script before I came to this realization. Well, learned some stuff along the way, starting to respect this whole zen cart thing a bit more.

Most importantly, these two files need to be NOT HERE:

./includes/templates/template_default/tpl_modules_facebook.php
./includes/templates/template_default/tpl_facebook_default.php

BUT, rather they should be in your custom template directory:

./includes/templates/YOUR_TEMPLATE/templates/tpl_modules_facebook.php
./includes/templates/YOUR_TEMPLATE/templates/tpl_facebook_default.php

Or, if for some reason you're running off the default template, they should be in the default template directory, ie:

./includes/templates/template_default/templates/tpl_modules_facebook.php
./includes/templates/template_default/templates/tpl_facebook_default.php

But, regardless, they certainly should not be where they are in the attached zip file if you want the module to work. Good news is, if you put the files in the correct spot, the facebook connect seems to work great.

Only problem is it does not appear to play nicely with the phpBB integration... so I went and disabled that.... and I also customized some of the code for the sign on form so that it gives the option to subscribe to the email list, since this version disables that option for some reason. At any rate, Overall, this plugin is great - thanks for the contribution, really came at the right time for the site I'm working on! Cheers.

S.O.S

After install it and login with my facabook acount i get this

**Forbidden

You don't have permission to access /facebook/ on this server.**

i have changed the permissions on the folder but nothing please help....

I was able to get this module working with the customizations that erickmiller pointed out.

I wanted to bring up a certain scenario. If a user already has an account on my site where they didn't use facebook connect to create it, but later decide to log in via facebook, I would like for the module to detect that that email already exists in my customers table and assign their facebook ID to that already existing account. As it is now, it looks like it will just create another account for them. Maybe this module isn't set up to handle that case yet, but I was wondering if anyone else wanted this functionality, and if so has anyone gotten it to work this way? Thanks.

I install appeared when the following error don't know how to solve.
API Error Code: 191
API Error Description: The specified URL is not owned by the application
Error Message: redirect_uri is not owned by the application.

Who can help me? thank you.

ok I installed this mod and it seems like its working but its not...
when a customer clicks on the facebook button a new window opens up (facebook page) but receive an error "An error occurred. Please try again later."
Maybe it is me not knowing how to set up my site on facebook page?
I do have my App ID and App Secret from when i set up my like button...
anyone here that might know what I need to do / doing wrong...
:dontgetit

well I got it working but not without some bugs...
anyone here would know how I could get the page to refresh after facebook connects?
I need to manually refresh the page... wish there was a way to get it to auto refresh or go to a page that welcomes them..:lookaroun

rstevenson:

Let me be the first to ask: what does it do?

Rob
Can I get on board with Rob's comment, by also asking what exactly this addon does?

Since plenty of people are trying it, surely someone could take the time to explain what it does, if that is not too much trouble :smile:

well since social networking is so big now this takes advantage of it
if you have a facebook page and you advertise on facebook you want to make it easier for your customers to buy from you
this allows your customers that have facebook to log in using their facebook account and that information gets copied to your database allowing them to have a true guest account
no need to enter their DOB or email or mailing address... (if facebook has it then with this app you have it)
to sum everything up its just to make it easier for your customers to buy from you

anyhow I finally got it working... i had another script on my common template that mixed with this script... once i commented out the one from common this one worked. plus the SQL code needs a bit of editing. im sure if you take a good look at it and compare it with another code you will figure it out. also the php command that goes on the template login file is missing ' '
besides that this code works as expected.
If anyone wants I will post a detailed fix to get this mod to work but if there is very little demand then there is no point...

An error occurred. Please try again later.

I am getting the above error please help me to solve this

Thanks in advance :flex:

I installed it, works great.

Question:
It seems like this is a very powerful tool, but as is we're only using it for logins rather than for advertising.

The coding as is, sets permissions to give access to the login users friends list, ability to post on the users walls.

Is there a way to make so that the once a customer purchases a product we can post a message and link on the users wall like "John Doe just purchased Product A from ZenCartSite.com"

or

Is there a way to send a message to the users friends "John Doe Recommend's using ZenCartSite App with ZenCartSite.com"

See I would like to create an incentive using the fconnect login by offering promo codes to those that do, and tradeoff would be social media advertising.

im getting this error:

Error

SQL query:

ALTER TABLE `customers` ADD `facebook_id` VARCHAR( 64 ) NULL

MySQL said: Documentation
#1146 - Table 'oritta.customers' doesn't exist 

when trying to install the sql file. not working with installing it from zen cart admin panel and not from the B admin panel.

what should i do?

fixed the DB issue...

i have a problem after agree to connect with the app im getting a blank screen.

im using 1.3.9b , with godaddy servers and db.

what is the problem? and how to fix it?

when i fixed the db issue , (1 reply above) , i add
ALTER TABLE zen_customers ADD facebook_id VARCHAR( 64 ) NUL

insted of
ALTER TABLE customers ADD facebook_id VARCHAR( 64 ) NUL

maybe this is the problem?

Please advice!!!!

picture

any1 ? please?

thi doesnt work for me.. all i get is

NOTE: Zen Cart database-upgrade scripts should NOT be run from this page.
Please upload the new zc_install folder and run the upgrade from there instead for better reliability.

i'm using the latest version on zencart.

(You are presently using: v1.3.9h)

any ideas?