Notice

The forum is in read only mode.

Support Forum

Welcome! Support Forums have been reactivated
Welcome the Technical Support section. Help us in assisting you by providing us with a concise and descriptive elaboration of your issues. Be specific and if possible, provide us with a step-by-step instruction in replicating your problem.

Update stucked at "Updating JomSocial database"

6 years 1 month ago
  • Elie's Avatar
    Topic Author
  • Elie
  • Offline
  • Fresh Boarder
  • Posts: 63
  • Thank you received: 0
Licenses:
JomSocial Active Socialize Expired

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

6 years 1 month ago
Licenses:
JomSocial Active GURU Active Publisher Active AdAgency Active iSEO Active Socialize Active

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.

6 years 1 month ago
  • Elie's Avatar
    Topic Author
  • Elie
  • Offline
  • Fresh Boarder
  • Posts: 63
  • Thank you received: 0
Licenses:
JomSocial Active Socialize Expired

Hi, I had checked. All settings are OK.

6 years 1 month ago
Licenses:
JomSocial Active GURU Active Publisher Active AdAgency Active iSEO Active Socialize Active

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.

6 years 1 month ago
  • Elie's Avatar
    Topic Author
  • Elie
  • Offline
  • Fresh Boarder
  • Posts: 63
  • Thank you received: 0
Licenses:
JomSocial Active Socialize Expired

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

You can access files through extplorer extension.

6 years 1 month ago
Licenses:
JomSocial Active GURU Active Publisher Active AdAgency Active iSEO Active Socialize Active

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.

6 years 1 month ago
  • Elie's Avatar
    Topic Author
  • Elie
  • Offline
  • Fresh Boarder
  • Posts: 63
  • Thank you received: 0
Licenses:
JomSocial Active Socialize Expired

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?

6 years 1 month ago
  • Elie's Avatar
    Topic Author
  • Elie
  • Offline
  • Fresh Boarder
  • Posts: 63
  • Thank you received: 0
Licenses:
JomSocial Active Socialize Expired

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

6 years 1 month ago
Licenses:
JomSocial Active GURU Active Publisher Active AdAgency Active iSEO Active Socialize Active

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.

6 years 2 weeks ago
  • Elie's Avatar
    Topic Author
  • Elie
  • Offline
  • Fresh Boarder
  • Posts: 63
  • Thank you received: 0
Licenses:
JomSocial Active Socialize Expired

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

6 years 2 weeks ago
  • Elie's Avatar
    Topic Author
  • Elie
  • Offline
  • Fresh Boarder
  • Posts: 63
  • Thank you received: 0
Licenses:
JomSocial Active Socialize Expired

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

6 years 2 weeks ago
Licenses:
JomSocial Active GURU Active Publisher Active AdAgency Active iSEO Active Socialize Active

Hi

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

6 years 2 weeks ago
  • Elie's Avatar
    Topic Author
  • Elie
  • Offline
  • Fresh Boarder
  • Posts: 63
  • Thank you received: 0
Licenses:
JomSocial Active Socialize Expired

I think you had not gone through all my messages.

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

6 years 2 weeks ago
  • Elie's Avatar
    Topic Author
  • Elie
  • Offline
  • Fresh Boarder
  • Posts: 63
  • Thank you received: 0
Licenses:
JomSocial Active Socialize Expired

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

Moderators: Piotr Garasiński
Powered by Kunena Forum

Join 180,000 websites creating Amazing communities

JomSocial is the most complete, easy-to-use addon that turns Joomla CMS into a
full -fledged, social networking site

TRY NOW BUY NOW