Hi.
I've just installed jomsocial on my Joomla 2.5 site and imported users into the DB.
When I login though, I just get a blank page. I have found some error messages which will hopefully help:-

JDatabaseMySQLi::query: 1054 - Unknown column 'b.points' in 'field list' SQL=SELECT *, b.points FROM `k5dxv_users` AS a ORDER BY registerDate DESC

was the first I encountered, and when trying 'advanced search', I got this lot:-

500 - JDatabaseMySQLi::query: 1044 - Access denied for user 'cl38-a-jooml-3iw'@'%' to database 'cl38-a-jooml-3iw' SQL=CREATE TEMPORARY TABLE tmpadv SELECT DISTINCT( b.`userid` ) as `user_id`, a.`username` AS `username`, a.`name` AS `name`, a.`registerDate` AS `registerDate`, CASE WHEN s.`userid` IS NULL THEN 0 ELSE 1 END AS online FROM `k5dxv_users` AS a LEFT JOIN `k5dxv_session` AS s ON a.`id`=s.`userid` INNER JOIN `k5dxv_community_users` AS b ON a.`id` = b.`userid` AND a.`block` = '0' WHERE a.`name` LIKE '%%'

Please help.
Thanks
Dean

This was also on the page:-


Call stack
# Function Location
1 JSite->dispatch() JROOT/index.php:43
2 JComponentHelper::renderComponent() JROOT/includes/application.php:194
3 JComponentHelper::executeComponent() JROOT/libraries/joomla/application/component/helper.php:348
4 require_once() JROOT/libraries/joomla/application/component/helper.php:380
5 CommunityBaseController->execute() JROOT/components/com_community/community.php:145
6 CommunitySearchController->advanceSearch() JROOT/components/com_community/controllers/controller.php:295
7 CommunityView->get() JROOT/components/com_community/controllers/search.php:263
8 CommunityViewSearch->advanceSearch() JROOT/components/com_community/views/views.php:251
9 CAdvanceSearch::getResult() JROOT/components/com_community/views/search/view.html.php:420
10 CommunityModelSearch->getAdvanceSearch() JROOT/components/com_community/libraries/advancesearch.php:71
11 JDatabase->query() JROOT/components/com_community/models/search.php:494
12 JDatabaseMySQLi->execute() JROOT/libraries/joomla/database/database.php:1279
13 JError::raiseError() JROOT/libraries/joomla/database/database/mysqli.php:396
14 JError::raise() JROOT/libraries/joomla/error/error.php:251

Hi, Dean.

It seems that you have TWO separated and unrelated issues on your site:

1. JDatabaseMySQLi::query: 1054 - Unknown column 'b.points' in 'field list' SQL=SELECT *, b.points FROM `k5dxv_users` AS a ORDER BY registerDate DESC

It means that your table is incomplete - it lacks b.points column in k5dxv_users table.

2. 500 - JDatabaseMySQLi::query: 1044 - Access denied for user 'cl38-a-jooml-3iw'@'%' to database 'cl38-a-jooml-3iw'

It means that user cl38-a-jooml-3iw'@'% have no rights to access cl38-a-jooml-3iw database.

I'll fix first one for you but you must provide PhPMyAdmin access (edit your first post and add credentials to Miscellaneous box). But before I do that please check user and database name you entered in configuration.php file in Joomla! main folder (change permissions to that file as it has chmod 444 and doesn't allow to write in it. Change chmod for that file to 644 and change user name or data base name.

Also check permissions in cPanel if this user has access rights to database.

If your are not sure how to do it - ask your hosting provider for help.

Great.
Thanks Michal. I'll edit it now.

Thanks Michal, but I've got to get cracking on it, so I'll try starting again with Joomla 3 instead of 2.5.

Hi, Dean.

Ok, but I think that issues could be resolved without starting again... but it's up to you ;)
I mark this thread as resolved - you can reopen it again if you'll have this issues again.
Open new threads for new issues.