Re: Error after installation of jfbconnect with easyblog 5
Yesterday 23:59:21

Thanks for letting us have access to the admin area. It definitely helped narrow down where the problem lies. EasyBlog now has some code to integrate with JFBConnect to display the user's avatar. The problem is that it seems like that code isn't working properly on your site, and I can't really see why.

The problem code is in the administrator/components/com_easyblog/includes/avatar/adapters/jfbconnect/client.php, starting at line 34:
Code:

// Set the default column
$query = 'SELECT ' . $db->quoteName('fb_user_id') . ' AS ' . $db->quoteName('id');

// If it is new version
if (isset($columns['provider_user_id'])) {
$query = 'SELECT ' . $db->quoteName('provider_user_id') . ' AS ' . $db->quoteName('id');
}

That code is setting up a MySQL query to get some data out of the JFBConnect table. The first line is for a very old version of JFBConnect, whereas the the second $query line is for the most recent versions of JFBConnect from the last 2 years. For some reason, your site is trying to use the first line, which is throwing the SQL query error.

The quickest fix is to edit the code above to simply look like:
Code:

// Set the default column
$query = 'SELECT ' . $db->quoteName('provider_user_id') . ' AS ' . $db->quoteName('id');

Basically, removing most of it.

Of course, that's not a good long term solution as future upgrades to EasyBlog will need to be re-edited. I looked at your system configuration, and you're running Linux with MariaDB, which should be fine.

Accessing EasyBlog5 on our development site, we can't see the same query (either correct or incorrect) being called. I'm not sure why it's being called on yours but not ours (or others that we've heard of). Do you know if you have any features in EasyBlog configured to use JFBConnect? I haven't seen options like that before, but it's possible some setting is causing the problem.

Please let us know anything you find and we'll gladly help investigate... and report whatever we find to the EB developers.

Thanks,
Melissa