I'm having trouble getting my community - activity stream to work - it's just not displaying (attachment 1)
I'm also having problems creating groups front and backend (attachment 2)...
500 - An error has occurred.
DB function failed with error number 1054 <br /><span style="color: red;">Unknown column 'groupid' in 'where clause' SQL=UPDATE `jos_community_activities` SET `group_access`='0' WHERE `groupid`=''
DB function failed with error number 1054
Unknown column 'a.group_access' in 'where clause' SQL=SELECT a.* FROM `jos_community_activities` as a WHERE ( 1 AND ( (a.`group_access`='0') OR (a.`groupid` IN ('' ) ) OR (a.`groupid`='0')) AND (a.`event_access`='0') AND (a.`groupid` OR (((a.`access` = 0) ) OR ((a.`access` = 10) ) OR ((a.`access` = 20) AND ( '667' != 0) ) OR ((a.`access` = '40') AND (a.`actor` = '667') ) OR ((a.`access` = '30') AND ((a.`actor`IN (SELECT c.`connect_to` FROM `jos_community_connection` as c WHERE c.`connect_from` = '667' AND c.`status` = '1' ) ) OR (a.`actor` = '667') ) ))) ) AND a.`archived` = 0 GROUP BY a.`id` ORDER BY a.`created` DESC, a. `id` DESC LIMIT 20
Unknown column 'a.eventid' in 'where clause' SQL=SELECT a.* FROM `jos_community_activities` as a WHERE ( 1 AND a.id < 1000000000 AND ( a.eventid = 3 AND a.comment_type != "events") ) AND a.`archived` = 0 GROUP BY a.`id` ORDER BY a.`created` DESC, a. `id` DESC LIMIT 20
Hi Matthew,
I can access administrator page, got this:
Database Error: Unable to connect to the database:Could not connect to MySQL
seem joomla configuration not setup properly.
please edit your first post at this topic, put credential information at site info form.
i need valid joomla or jomsocial site URL, administrator URL, and FTP access detail. that things for debugging purpose.
Regards,
Albert
Hi Matthew,
seem the jomsocial DB still using old version, but here the fixes that I did from phpmyadmin:
ALTER TABLE `jos_community_activities` ADD `groupid` INT NULL AFTER `cid`, ADD `eventid` INT NULL AFTER `groupid`;
ALTER TABLE `jos_community_activities` ADD `group_access` TINYINT(4) NOT NULL AFTER `eventid`;
ALTER TABLE `jos_community_activities` ADD `event_access` TINYINT(4) NOT NULL AFTER `group_access`;
Hi Matthew,
DB problem. I added this field.
ALTER TABLE `jos_community_activities` ADD `verb` VARCHAR(200) NOT NULL AFTER `app`;