Topic-icon JFBconnect conflict with jreviews

Active Subscriptions:

None
12 years 4 months ago #40517 by sgshell
hi,
joomla 3.2.1
jreviews v2.4.12.2
jfbconnect 5.2.2

i notice there JFBCSystem is causing problem in jreviews as mention below:
1) security code - the security code will not show
2) the "report this comment link" - it will have this warning message :
Warning: mysqli_fetch_row() expects parameter 1 to be mysqli_result, boolean given in /home/xxx/public_html/libraries/joomla/database/driver/mysqli.php on line 777
Warning: mysqli_free_result() expects parameter 1 to be mysqli_result, boolean given in /home/xxx/public_html/libraries/joomla/database/driver/mysqli.php on line 820

pls help to rectify asap.. thank you.
The topic has been locked.
Support Specialist
12 years 4 months ago #40521 by alzander
What security code is not showing? Can you explain more or provide a link to the URL? Specifically, is this the captcha during registration, leaving a review, or some other place?

As for the PHP Notice, I'm not sure where that's coming from. It is a warning message though, and not a real 'error'. If you go to your Joomla -> Global Configuration area, you should be able to set "Error Reporting" to "None" and that message will no longer display or interfere. The "None" setting is what is recommend for any Joomla website in production (live to users).

I hope that helps, but keep us posted on the above.

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

None
12 years 4 months ago #40526 by sgshell
1) that the security code for public to enter when submit comments in Jreviews.
2) the error report is off

Kindly check this link, I activate the security code of jreviews, pls try submit comments without login. pls also click on the comments report icon on the comment post to see the warning message.
obit.sg/id/40-lim-boon-keng.html
The topic has been locked.
Support Specialist
12 years 4 months ago #40533 by alzander
I'm unsure why the security code isn't working, or where that MySQL error is coming from. I'd love to help narrow things down further though, as both issues may be related to each other.

Is it possible to send me admin credentials to the site so we can narrow down what's happening? If so, please Private Message me the credentials, and we'll let you know what we find. You can PM me by clicking the mail icon under my name to the left.

Thanks,
Alex
The topic has been locked.
Support Specialist
12 years 4 months ago #40577 by alzander
Thanks for the credentials. We got in and had a look around today, but were unable to determine what was throwing the PHP warnings from just using the admin area.

We'd really like to narrow things down further, but to do so, we'd need to edit our code on-site to figure out what's going wrong. Would it be possible to send us FTP credentials to your site so we can easily edit our code? There are file management extensions we can install on your site as well, but those are a lot more difficult to use and can cause other issues.

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

None
12 years 4 months ago #40580 by sgshell
yes...pls check your pm....thks
The topic has been locked.
Active Subscriptions:

None
12 years 4 months ago #40601 by sgshell
please let me know the status?
The topic has been locked.
Support Specialist
12 years 4 months ago #40635 by alzander
Thank you for your patience. We really appreciate the FTP access. It helped us to narrow down, and fix, the bug in JFBConnect that was throwing the PHP warning. That warning was causing both of the issues you reported above.

The change will definitely be in the next release of JFBConnect, so you shouldn't have to deal with this again.

In your PM, you also noted that Google was throwing a white page. I couldn't find where you setup the login area, so please let me know, and we'll gladly test. Also, I set Error Reporting to "Maximum" in the Joomla Global Configuration area. If you try to login with Google again, it will likely show you a PHP error message. That message will also help narrow down what's going wrong there.

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

None
12 years 4 months ago #40646 by sgshell
hi,

As mention in PM, both login using Sclogin and in registration form ,
1)
a) the facebook login is very slow, it take 30-40second, (i try my others site with community builder it almost instant login without problem, but same slow login problem for jfbconnect)
b) login by google take forever to load after that a blank screen, i got this error message after changing the theme to protostar - joomla Default

1064 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 'INT) suffix FROM utspe_users WHERE `username` ~ '^destan[0-9]+$' ORDER BY `suffi' at line 1 SQL=SELECT CAST(REPLACE(username, 'destan', '') AS INT) suffix FROM utspe_users WHERE `username` ~ '^destan[0-9]+$' ORDER BY `suffix` DESC LIMIT 1

2) i found another bug that if the joomla Captcha - ReCaptcha plugin is on in registration, the user registration could not be complete, error message:
Could not open socket
The topic has been locked.
Support Specialist
12 years 4 months ago #40666 by alzander
Please test with Google again. I made another fix on your site that is already planned for the next release. It should fix that problem.

As for logging in with Facebook, I just tried and it took about 9 seconds for the page to reload. Whenever I navigate to any page on your site, it takes about 5 seconds to load. I don't think Facebook authentication is adding an excessive amount of load. It seems that your server may be underpowered or not have a fast internet connection right now since all content takes a few seconds to load. There are a lot of queries that JFBConnect has to make to Facebook.com to log a user in and get their information, so if your site/server has any connectivity issues, those will be inflated when using social network authentication.

Finally, for captcha, the same error occurs if you try to register using the standard Joomla registration page. There is some sort of server connectivity issue that is preventing captcha from working. I'm not sure what it is, but it's not related to JFBConnect. The same problem could be causing the slow Facebook authentication though.

I hope that helps,
Alex
The topic has been locked.