Configuring JFB Connect

ericdunn
Offline

Active Subscriptions:

None

11 years 8 months ago #47212 by ericdunn

Configuring JFB Connect was created by ericdunn

Hi,

Can you please help me set up JFB Connect to get it working properly with the other extensions on my website? I am running Jomsocial, Easyblog and EasyDiscuss.

The first issue I had was during installation, I couldn't get the System - JFBCSystem plugin test to work. I am running JCH Optimize Pro. When I disabled this plugin, the JFBCSystem plugin test worked and I was able to complete the installation. I have re-enabled JCH Optimize Pro - but do you think this may be clashing with JFB Connect? If so, how can I resolve this?

The main issue I have is that Jomsocial comes with a lot of plugins - I don't know which one's I need and which one's I don't. Specifically, do I need to use the Jomsocial Redirect plugin which I previously used to intercept any attempt to login or register?

At the moment, I have published the SCLogin module, but when I use the Facebook connect icon on the module the website crashes and I get a 1064 error. I am unable to access the front end of the website until I reset my safari browser completely. It looks like the website is trying to access a page that doesn't exist and then memorises this in the browser.

I appreciate any help you can give me to get this set up correctly.

Thanks,

Eric.

The topic has been locked.

alzander
Offline

Support Specialist

11 years 8 months ago #47217 by alzander

Replied by alzander on topic Configuring JFB Connect

JCH Optimize shouldn't conflict and should work just fine with JFBConnect. To use them both together though, please make sure that:
* The JCH Optimize plugin is ordered last in the system plugin group and not before the JFBCSystem plugin
* After you update JFBConnect you clear the Joomla and JCH Optimize cache.

For JomSocial plugins, there really aren't any you 'need' for JFBConnect to work. We work with any, or none, of their plugins.

Specifically, do I need to use the Jomsocial Redirect plugin which I previously used to intercept any attempt to login or register?

You don't need this, but you can still use it. The JFBConnect social login buttons are added automatically to the JomSocial and Joomla registration pages, so if you want to use that plugin to redirect users to JomSocial.. that's ok. If not, that's ok too since they'll see the Joomla reg page.

With that said, the JomSocial Redirect page can cause some issues so make sure you've configured all the redirection URLs in it properly.

At the moment, I have published the SCLogin module, but when I use the Facebook connect icon on the module the website crashes and I get a 1064 error.

Can you tell me what the error is? Usually, there's a lot more information when you get a 1064. Knowing that will help. If not, try each of the following and test after each one:
* Disabling the JomSocial Redirect plugin
* Set the "Registration Component" in JFBConnect to "Joomla"
* Disable the Social Profiles - JomSocial" plugin

Hopefully, one of those work, but if not, let us know, and we'll gladly help,
Alex

The topic has been locked.

ericdunn
Offline

Active Subscriptions:

None

11 years 8 months ago #47224 by ericdunn

Replied by ericdunn on topic Configuring JFB Connect

Hi Alex,

I have tried the following, but I still have problems:

1. The JCH Optimize plugin is ordered last in the system plugin group.
2. I have cleared the JCH Optimize plugin cache and the Joomla cache.
3. I have tried the Facebook login button which is published on the SC Login menu with and without the Jomsocial Redirct plugin. In both cases, I still get the 1064 error. The error is as follows:

YOU HAVE AN ERROR IN YOUR SQL SYNTAX; CHECK THE MANUAL THAT CORRESPONDS TO YOUR MYSQL SERVER VERSION FOR THE RIGHT SYNTAX TO USE NEAR ') ) ) ) ) ORDER BY A.ID DESC LIMIT 10' AT LINE 1 SQL=SELECT A.* FROM `RRJHT_COMMUNITY_EVENTS` AS A INNER JOIN `RRJHT_COMMUNITY_EVENTS_CATEGORY` AS B ON A.`CATID` = B.`ID` LEFT JOIN `RRJHT_COMMUNITY_GROUPS` AS C ON A.`CONTENTID` = C.`ID` WHERE A.`PUBLISHED` = '1' AND ( (A.`ID` IN (2) AND ( (A.`PERMISSION` = '0' AND A.`CONTENTID` = '0') OR (A.`PERMISSION` = '0' AND A.`CONTENTID` > '0' AND C.`APPROVALS` = '0') OR (A.`CONTENTID` > '0' AND C.`APPROVALS` = '1' AND C.`ID` IN () ) ) ) ) ORDER BY A.ID DESC LIMIT 10
1064

4. I tried to set the Registration Component in JFB Connect to Joomla, but it doesn't give me that option. The only options available are JFB Connect and Jomsocal.

5. I tried to disable the Social Profiles - Jomsocial plugin, and I still get the 1064 error.

I noticed that if you use the login to Facebook from the Icon published on the Community page, then this works perfectly fine. The problem appears only to be with the Icon in the SC Login module. Does this help troubleshoot the problem further?

Best regards,

Eric.

The topic has been locked.

alzander
Offline

Support Specialist

11 years 8 months ago #47229 by alzander

Replied by alzander on topic Configuring JFB Connect

1/2) Good.
3) That error isn't coming from JFBConnect. That's a query that's looking inside JomSocial's Event, Event Category and Groups table to get a listing of events (I'm assuming to display, but possibly to update for the user). The last portion of the query looks like:

AND C.`ID` IN ()

That's invalid syntax. The IN() should have something inside those parenthesis. Again, that query is not being generated by JFBConnect, so I don't know what it's doing. If you can check the following, it should help narrow things down:
* Set the New User and Returning User Redirection to different pages on your site
* Check your Authentication, User and System plugins to see if any have to do with JomSocial Events. If so, try disabling them
* Try disabling any modules on your site related to JomSocial Events
Hopefully, one of those things will get things working. If so, that will help narrow things down and help us determine how to fix the problem so you can re-enable the feature how you want.
4) Sorry, I meant "JFBConnect" as the Registration Component. From your feedback, I don't think this will make a difference though.
5) Ahh.. you probably have the Returning User Redirection set to "Same Page". So, if the user is redirected to a JomSocial page, it may work whereas other pages don't... for some reason.

I hope that all helps get some progress going. Obviously, keep me posted on anything you find.

Thanks,
Alex

The topic has been locked.

ericdunn
Offline

Active Subscriptions:

None

11 years 8 months ago #47240 by ericdunn

Replied by ericdunn on topic Configuring JFB Connect

Hi,

I disabled the Events module on the front page and its working now! However, I do need to use this events module as I need to display the next event, not the most recent event created. This is not the Jomsocial module, but it is called Mega Module for Jomsocial and is by a company called minitek.gr. How do you think I should proceed? Should I contact minitek about the error?

Another question. When a user creates a profile using Facebook, if that user then wants to log in again just using username and password - how does he/she know what the username and password is? Where can I find it?

Regards,

Eric.

The topic has been locked.

alzander
Offline

Support Specialist

11 years 8 months ago #47245 by alzander

Replied by alzander on topic Configuring JFB Connect

Eric,
Unfortunately, I can't help too much with that module. I'm not sure why it's generating the SQL query error above. I'd have to tell you to contact them to see if they can understand what's going wrong in their code. With narrowing it down and having the specific error, they should be able to determine what's happening pretty quickly, I'd hope.

For username/password, that shouldn't be a problem. JFBConnect should email the user their Joomla credentials that they can use to authenticate later. If that's not happening, let me know.

Thanks,
Alex

The topic has been locked.

Start
Prev
1
Next
End

SourceCoast Login

Configuring JFB Connect