Albertus, Thanks for continuing you help !
I got another error: screen shot attached
Regards

1054 - Unknown column 'group_access' in 'field list' SQL=INSERT INTO `j25_community_activities` (`actor`,`actors`,`target`,`title`,`content`,`app`,`cid`,`groupid`,`eventid`,`group_access`,`event_access`,`created`,`access`,`params`,`points`,`location`,`comment_id`,`comment_type`,`like_id`,`like_type`) VALUES ('62','','0','','','events','72','0','72','0','0','2015-09-16 02:40:57','0','{\"action\":\"events.create\",\"event_url\":\"index.php?option=com_community&view=events&task=viewevent&eventid=72\",\"event_category_url\":\"index.php?option=com_community&view=events&task=display&categoryid=1\"}','1','199 Paradise Rd Athens Ga 30607','72','events','72','events')


Albertus,
Please retry DB access as I know you would know how to do that QUERY more efficiently than I would. I rechecked your access & you should be ok. Regards, Dan

please execute this query at phpmyadmin

ALTER TABLE `j25_community_activities` ADD `groupid` INT(10) NULL AFTER `cid`, ADD `eventid` INT(10) NULL AFTER `groupid`;

[please let me know if any DB error again. I cannot access the DB anymore. seem the login detail has been disabled.]

Albertus,
Sorry to keep bugging you but another error ...item "groupid" (attached image)
Is there any general "fix" for these issues or is it just 1 at a time until repaired.
Thank you

Hi,

not sure why summary field was missing. to fix it I execute this query

ALTER TABLE `j25_community_events` ADD `summary` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `location`;

Hi,

please execute this query at phpmyadmin

ALTER TABLE `j25_community_activities` ADD `groupid` INT(10) NULL AFTER `cid`, ADD `eventid` INT(10) NULL AFTER `groupid`;

Hi,

please check it. I did it for you. please let me know if any DB issues.

Regards

Hi,

please check it again.
seem there is a 3rd party that made a changes at jomsocial activities table. because there is updated_at field. jomsocial never have that field.

if the issue still exist. please use "reply" instead of edit your first post.
if using reply, I will get notification about it.

Regards

Albertus,
Thank you very much for your help & persistence in successfully solving this support ticket. I do not know how the "updated_at" field or some of the others issues which were causing Create Event problems. Thanks again. Regards.