Hi,
I am in the process of updating jom-social and Joomla version. But Jom-social got stuck at a particular point "Updating JomSocial database". Everything is OK. Database connect limit etc. is already 120 but still it is not proceeding further.

I can not see any error in error log.

May I know the reason behind this issue?

Thanks
Nirmal

Hi

Please check jomsocial requirements here documentation.jomsocial.com/wiki/JomSoci..._System_Requirements

Pay close attention to php.ini file settings. There as I believe is the problem with database not having enough time for update.

Additionally please disable showing errors, so if any would appear during the update it will not affect the process.

Hi, I had checked. All settings are OK.

Hi

Sorry for delay. I got sick.

Please try update Your joomla to 3.8.x as well. New Jomsocial was designed for this Joomla version, so I'm not entirely sure, but it may been affecting the database update. If this will not change installation process please attache an FTP and PHPMyAdmin access as well.

Updated Joomla version also but still it is showing same error.

You can access files through extplorer extension.

Hi

I was able to push the update through. Blocking was done by a warning message being send from database. Unfortunately could not see the message, but when I check the database update was finished, so I skipped to next point of installation. Please check if everything is in place.

Thank you.. Everything is in place but an error has occured on home page "1054 - Unknown column 'c.type' in 'field list'". Let me know how to fix this?

Hi,

When I disabled chat from admin, jom-social stream appears fine but this is wrong. Please let me know changes which I need to perform to fix this error "1054 - Unknown column 'c.type' in 'field list'".

We have another website on same cloudways. I doubt that update may stop at the same situation which occurred on dev server but that one is live site and we can bear such risk. Last time you told me, " I was able to push the update through. Blocking was done by a warning message being send from database. ". Why this warning message did not appear to me and how can I resolve this issue by my own?

Thanks

Hi

The warning was shown in background, at the mysql server, not on the site or any visible area.

Column 'type' can be seen in couple of jomsocial tables:

_community_avatar
`type` tinyint(3) UNSIGNED NOT NULL COMMENT '0 = small, 1 = medium, 2=large'

_community_blocklist
`type` varchar(50) NOT NULL

_community_chat
`type` char(50) NOT NULL

_community_connect_users
`type` varchar(255) NOT NULL

_community_events
`type` varchar(255) NOT NULL DEFAULT 'profile' COMMENT 'profile, group'

_community_event_stats
`type` varchar(255) NOT NULL

_community_featured
`type` varchar(255) NOT NULL

_community_fields
`type` varchar(255) NOT NULL

_community_files
`type` varchar(255) DEFAULT NULL

_community_group_stats
`type` varchar(255) NOT NULL

_community_memberlist_criteria
`type` varchar(255) NOT NULL

_community_notifications
`type` varchar(200) NOT NULL,

_community_photos_albums
`type` varchar(255) NOT NULL

_community_photo_stats
`type` varchar(255) NOT NULL

_community_profile_stats
`type` varchar(255) NOT NULL

_community_videos
`type` varchar(200) NOT NULL DEFAULT 'file'

_community_video_stats
`type` varchar(255) NOT NULL

_community_wall
`type` varchar(200) NOT NULL


Please check which one is missing and add it manually or send me an access to phpmyadmin so I'll do that for You.

Hi,
We updated Jomsocial on Development server earlier and it got stucked on updating database option which you fixed and I don't know how you did. Now, I tried to update jomsocial on live server www.blabber.buzz , I am ended up with same problem. Update database is still going on. May I know how much time it will take?

Also same error "1054 - Unknown column 'c.type' in 'field list'" appearing on homepage which I fixed by disabling chat functionality from jom-social and which I can't do right now as I am not able to access jom-social admin.

Please help me in this. Issue is on live site so it is affecting site's reputation also.

All credentials are same which I had shared earlier except URL.

Thanks

I replaced chat table with the new table, sql of which is already in latest Jomsocial. Now, front end of site is looking OK. Please fix admin end so that I will check if any change required.

Thanks

Hi

Are the url same as for the last site I've been working with ? I see no issues in joomla panel after login.

I think you had not gone through all my messages.

Anyhow, I had updated right site URL etc. Please review.

In the morning, I again tried to access Jom-social and it finished further step and every thing is OK now.
Thanks