Topic-icon FB request not working

Active Subscriptions:

None
12 years 6 months ago #38893 by al3xandr0sss
Hi.

I have set up an ssl certficate that i know its working. I have also set up the canvas url, canvas secure url etc in my fb apps. I can see my canvas at apps.facebook.com/myname . However when i sent a friend request(using the request module) from my site to a test user and then i log in with a second fb account binded to that second user i get the following:

1) i receive the the app request
2) i click on it and i get redirected to the apps page. However apart from the facebook side bar with suggestions the main page is blank. What am i doing wrong?
The topic has been locked.
Support Specialist
12 years 6 months ago #38898 by alzander
Replied by alzander on topic FB request not working
If the page is blank, please go to the Joomla Global Configuration area and set "Error Reporting" to 'maximum'. Then the white area will hopefully display a PHP error message. Let us know the error, and we can help you track down what may be the cause.

Thanks,
Alex
The topic has been locked.
Active Subscriptions:

None
12 years 6 months ago #38923 by al3xandr0sss
Replied by al3xandr0sss on topic FB request not working
Bellow is the screenshot of what i see from the fb side.

File Attachment:



I know it seems like there is a bad ip address thing or not have enough privilleges. But i have checked my fb app settings and they are correct.
My base url is allgreens.gr My canvas one is allgreens.gr/ and secure one is allgreens.gr (recently installed certification). I can visit my facebook canvas alright here:

apps.facebook.com/allgreensgr

I have set the request settings for your extension to "Breakout canvas". Is anything wrong with this set up?


(with the cert installed you get a dedicated ip as well. Maybe its a dns update issue? I have installed it 24 hours ago. However i see my canvas allright through facebook which mean it is able to be accessed).
The topic has been locked.
Active Subscriptions:

None
12 years 6 months ago #38924 by al3xandr0sss
Replied by al3xandr0sss on topic FB request not working
Maybe there is a cookie conflict? As i described i have created two users in my site. I have two facebook accounts. So i log in to my site using the one facebook account and i send to my test FB friend a request. When i log out and i use my other facebook account i see i have received the app and its working fine. When i do the other way around , meaning i log to my site with the other facebook account and i send the request , the other facebook account receives it but when clicked it gives me the 0 error which could possibly mean a privillege thing. So it works ok one way not both ways. I have set the automatic facebook login for my site registered visitors. Do you have a test fb account that i could add you as friend and send you a request? I think there must be a mix up with cookies.
The topic has been locked.
Support Specialist
12 years 6 months ago #38935 by alzander
Replied by alzander on topic FB request not working
The error message you post posted an image of is stating that there's an issue with the SQL query being performed. Can you check your database to see if the jos_jfbconnect_notification table exists? That should have been created when JFBConnect was installed. Another thing to check is that the request is properly logged in the admin area of JFBConnect. You can see the Sent/Received requets there.

Let me know if that helps narrow things down. If the database doesn't exist, please let me know:
* What version of JFBConnect you are using
* How long you've been using JFBConnect, or what version you last upgraded from.

Thanks,
Alex
The topic has been locked.
Active Subscriptions:

None
12 years 6 months ago #38958 by al3xandr0sss
Replied by al3xandr0sss on topic FB request not working
"to see if the jos_jfbconnect_notification table exists"
It exists and have correct values (phpmyadmin)

"Another thing to check is that the request is properly logged in the admin area of JFBConnect. You can see the Sent/Received requets there."
It is all there.

" What version of JFBConnect you are using"
Since few hours ago i am using 5.2.1(U realeased it just now)

Two days ago i purchased it and i had the first install at 5.2(In which i saw immediately the issue). Never before i had installed your extension. So the issue i attached the screenshot is from a first install(5.2).

I am running joomla 3.1.5 and jomsocial 3.x

Question: In JFBC configuration under profiles tab i have filled the values for the custom database (db prefix, db name, db password etc) even though i am using jomsocial. Should i delete those values? I think the values regarding the jomsocial must be hardcoded in your code. The custom database logicaly is for custom third party extensions so propably not needed in my case.

I can provide admin joomla account and cpanel account if you wish. Tell me how should we proceed.

Thank you
Alex.
The topic has been locked.
Support Specialist
12 years 6 months ago #38967 by alzander
Replied by alzander on topic FB request not working
Alex,
We did a lot more investigation and found out there is a bug in our Requests code. If you can make the following update, it should get things going for you. Please edit the /components/com_jfbconnect/models/notification.php . Around line 90, you should see:
->where($this->_db->qn('fb_request_id') . "=" . implode("' OR fb_request_id = '", $this->_fbRequestIds));
Update that to the below:
->where($this->_db->qn('fb_request_id') . "='" . implode("' OR fb_request_id = '", $this->_fbRequestIds)) . "'";
It can be difficult to see the differences there. Specifically:
* There's a ' after the first = sign
* There's a . "'" at the end before the ;

I hope that helps, but definitely keep us posted on how it goes.

Thanks,
Alex
The topic has been locked.
Active Subscriptions:

None
12 years 6 months ago #38974 by al3xandr0sss
Replied by al3xandr0sss on topic FB request not working
Ok i have done the changes. I will monitor it and let you know.


Thanks
Alexandros
The topic has been locked.
Active Subscriptions:

None
12 years 6 months ago #38975 by al3xandr0sss
Replied by al3xandr0sss on topic FB request not working
I Have changed the code but still getting the same.


File Attachment:
The topic has been locked.
Active Subscriptions:

None
12 years 6 months ago - 12 years 6 months ago #38979 by al3xandr0sss
Replied by al3xandr0sss on topic FB request not working
The corresponding request seen from joomla admin for the sql error i attached in facebook is added as well.

Its number 7 in sorting request id ending in xxxx252 . You ll see that even if i clicked on it on facebook is marked as sent and not as "read" since it failed.


File Attachment:
Last edit: 12 years 6 months ago by al3xandr0sss.
The topic has been locked.